The simplest way to share an Excel file

To share an Excel file, save it to a location both you and the other person can reach — either a shared folder on your computer network, a cloud service like OneDrive or Google Drive, or email it as an attachment. The method you choose depends on whether you need the other person to edit the file, see live updates as you work, or just review a snapshot.

If you are sharing within a workplace, ask your IT department or manager which method your organization uses. Many companies have a preferred system already set up. If you are sharing with someone outside your organization, OneDrive or Google Drive are the most straightforward because they work across different networks without requiring special software.

Key Takeaways

  • Email works for one-time sharing but does not show real-time changes, and creates multiple versions if both people edit the file.
  • OneDrive and Google Drive let multiple people edit the same file at once and see changes when ready, but require a free account.
  • A shared network folder works well inside a company but requires access permission from your IT department.
  • You can restrict what others can do — view only, edit, or comment — depending on the sharing method you choose.

Sharing through email

Email is the fastest way to send a file to one or a few people. Open your email program, start a new message, and use the Attach button (usually a paperclip icon) to select the Excel file from your computer. The recipient gets a copy they can open and edit, but you do not see their changes unless they send the file back to you.

The main drawback is version confusion. If you both edit the file and email it back and forth, you end up with multiple versions with different names — "Budget Final," "Budget Final 2," "Budget Final ACTUAL" — and it becomes unclear which one is current. Email works best when one person is the main editor and others are just reviewing.

Sharing through OneDrive or Google Drive

OneDrive (Microsoft's cloud storage) and Google Drive (Google's equivalent) both let you upload an Excel file and share a link. The person you share with can open the file in their web browser, and if you give them edit permission, you both see changes in real time as either of you works.

To share through OneDrive: upload the file to your OneDrive folder, right-click the file, select "Share," choose who can access it (specific people or anyone with the link), and decide whether they can edit or only view. OneDrive is built into Windows 10 and 11, so the folder usually exists on your computer already.

To share through Google Drive: go to drive.google.com, upload the file, right-click it, select "Share," enter the email addresses of people you want to share with, and choose their permission level. Google Drive works on any computer with a web browser, including Windows, Mac, and Linux.

Both services keep one master copy, so there is no confusion about which version is correct. They also track who made which changes and when, which is useful if you need to see the history of edits.

Sharing through a network folder at work

Many workplaces have shared folders on a company server that multiple people can access. If your organization uses this system, save your Excel file to the shared folder instead of your personal computer. Everyone with access to that folder can then open the file directly.

To find the shared folder, open File Explorer (Windows) or Finder (Mac), look for a network location or shared drive, and ask your IT department or manager for the folder path if you cannot find it. Once you save the file there, you do not need to send it to anyone — they straightforward navigate to the same folder and open it.

The advantage is that everyone works from the same file, so there is only one version. The disadvantage is that only one person can edit it at a time on older versions of Excel, though newer versions of Excel with OneDrive integration allow simultaneous editing.

Setting permissions so others cannot accidentally change things

If you want someone to see the file but not edit it, most sharing methods let you set read-only permission. In OneDrive and Google Drive, this is a dropdown menu when you share — choose "Viewer" instead of "Editor." The person can open and read the file but cannot make changes.

In email, you can right-click the file before attaching it, select Properties (Windows) or Get Info (Mac), and check the "Read-only" box. This prevents accidental edits, though a determined person can still remove the restriction.

If you are sharing through a network folder, ask your IT department to set the folder permission to read-only for certain people. This is the most find method because it is enforced by the system, not just a setting on the file.

What to do if the other person cannot open the file

If someone says they cannot open your Excel file, the most common reason is that they do not have Excel installed. OneDrive and Google Drive solve this because they open Excel files in a web browser — no software needed. If you are sharing by email or network folder, the person needs either Microsoft Excel, the free Excel Online (through OneDrive), or a free alternative like LibreOffice Calc.

Ask the person what error message they see. "File not found" usually means the file is in a location they cannot reach. "Cannot open file" usually means they lack the software. If they are using an older version of Excel, very new files sometimes do not open — in that case, save the file in an older format: go to File, Save As, and choose "Excel 97-2003 Workbook" from the format dropdown.

Sharing large files or many files at once

If your Excel file is larger than 25 MB, email may reject it. OneDrive and Google Drive both handle large files without issue. If you need to share many Excel files at once, create a folder in OneDrive or Google Drive, put all the files in it, and share the folder instead of individual files.

Another option is to compress the files into a .zip folder. Right-click the files you want to share, select "Send to" (Windows) or "Compress" (Mac), and email the resulting .zip file. The recipient can then extract the files on their end.

Frequently Asked Questions

Can two people edit the same Excel file at the same time?

Yes, if you use OneDrive, Google Drive, or a network folder with modern Excel. Both people can open the file and see each other's changes in real time. With email, only one person can edit at a time — the other person's changes will overwrite theirs if they both send the file back.

What happens if I share a file and then delete it from my computer?

If you shared through OneDrive or Google Drive, the file stays in the cloud and the other person can still access it. If you shared by email, the file on their computer is separate from yours, so deleting yours does not affect theirs. If you shared through a network folder, deleting it removes it for everyone.

Can I stop someone from sharing the file with a third person?

In OneDrive and Google Drive, you can change the sharing settings at any time — remove their access, change them from Editor to Viewer, or switch from "anyone with the link" to "specific people." In email, once you send the file, you cannot control what they do with it. Network folders depend on your IT department's settings.

Is it safe to share Excel files through the cloud?

OneDrive and Google Drive use encryption and are generally considered safe for non-sensitive information. If the file contains passwords, financial data, or personal information, check your organization's data security policy first — some workplaces require files to stay on internal networks only.

How do I know if someone has edited my shared file?

OneDrive and Google Drive both show a version history. Right-click the file and select "Version history" (OneDrive) or look for the clock icon in the toolbar (Google Drive). You can see who made changes, when, and what changed. Network folders and email do not have this feature built in.