The simplest way to share an Excel file
The easiest method is to save your file to a cloud storage service — OneDrive, Google Drive, or Dropbox — then send the link to the people who need it. They open the link in their browser, and Excel opens automatically. Everyone sees the same file, and changes appear for all users within seconds. No email attachments, no confusion about which version is current, no manual merging of edits.
This works on Windows, Mac, iPad, and phones. The person who receives the link does not need to own Excel; they can edit in the browser version for free. If they do own Excel on their computer, they can open it there instead and get a slightly richer editing experience, but the browser version handles most everyday tasks.
The trade-off is that everyone with the link can see and change everything in the file unless you set permissions to read-only. If you need tighter control — say, one person can edit but others can only view — you adjust the sharing settings before you send the link.
Key Takeaways
- Cloud storage (OneDrive, Google Drive, or Dropbox) is the standard way to let multiple people edit the same Excel file at once, and changes sync within seconds.
- You can share a link instead of sending file attachments, which eliminates confusion about which version is current.
- Sharing settings let you choose whether people can edit, comment only, or view only — set this before you send the link.
- People can edit in a web browser for free even if they do not own Excel, or they can open the file in the desktop version if they have it installed.
- If you need to work offline or keep the file on your computer only, you can email the file, but then you have to manually merge changes from multiple people.
Setting up OneDrive sharing (Windows and Mac)
OneDrive is built into Windows 10 and later, and available free on Mac. Save your Excel file to your OneDrive folder on your computer — it is usually under your user account name. The file syncs to the cloud automatically. Once it is there, right-click the file, select Share, and choose whether people can edit or view only. Copy the link and send it however you normally communicate — email, Slack, text, Teams.
The people you send it to click the link and see the file open in their browser. If they have Excel installed on their computer, they can also click Open in Desktop App to edit in the full version. Either way, their changes save automatically and appear for everyone else within a few seconds.
If someone does not have a Microsoft account, they can still open the file — OneDrive will ask them to sign in with a Microsoft account or a work account, or let them continue as a guest. The guest option is the easiest if you are sharing with someone outside your organization.
Using Google Drive if you do not have OneDrive
Google Drive works the same way as OneDrive but does not require a Microsoft account. Go to drive.google.com, upload your Excel file, right-click it, and select Share. Choose whether people can edit or view, copy the link, and send it. Google Drive opens Excel files in a browser editor that handles most common tasks — formulas, formatting, charts, pivot tables.
The main limitation is that some advanced Excel features (certain macros, complex add-ins, or very large files) may not work perfectly in the browser. For everyday spreadsheets, this is rarely a problem. If someone needs the full Excel experience, they can read the file to their computer, edit it there, and upload it back — but this defeats the purpose of real-time sharing.
Google Drive is free with a Google account. If you run out of storage space, you can buy more, but most people have enough free space for dozens of spreadsheets.
Dropbox as an alternative
Dropbox works similarly to OneDrive and Google Drive. Upload your file to Dropbox, share the link with edit or view permissions, and people can open it in their browser or read it to their computer. Dropbox syncs changes across devices, so if someone edits the file on their phone and someone else edits it on their laptop at the same time, Dropbox keeps both versions in sync.
Dropbox is free for basic use, though storage limits are lower than Google Drive. It is often the choice for people who already use Dropbox for other file sharing, since everything lives in one place.
What to do if you must email the file instead
If you cannot use cloud storage — for example, your organization blocks it — you can email the file to everyone who needs it. The problem is that now you have multiple copies floating around. If person A edits their copy and person B edits their copy, you have to manually combine the changes, which is error-prone and time-consuming.
To minimize confusion, establish a clear process: one person owns the file and sends it out, everyone else makes their edits and sends it back to that person, and that person merges all changes into a single master copy. Use the Track Changes feature in Excel (under the Review tab) so you can see exactly what each person changed and accept or reject each change one by one.
This method works for small teams and one-time projects, but it breaks down quickly if many people need to edit at once or if the file changes frequently. Cloud storage is faster and less error-prone.
Controlling who can do what with sharing permissions
When you share a file from OneDrive, Google Drive, or Dropbox, you choose a permission level before you send the link. Edit means people can change anything in the file. View means they can open it but cannot change it. Some services also offer Comment, which lets people add notes without changing the actual data.
Set the permission to match what you actually need. If you are sharing a budget spreadsheet with your team for feedback, Edit is appropriate. If you are sharing a read-only report, View prevents accidental changes. If you are sharing a draft and want input without letting people overwrite your work, Comment is the middle ground.
You can also change permissions after you share — for example, if you shared with Edit but later want to lock the file, you can change it to View and everyone's access updates when ready. The file itself does not change; only what people are allowed to do with it.
Handling conflicts when two people edit at the same time
Cloud storage services handle simultaneous edits gracefully. If you and a coworker both edit the same cell at the same time, the service usually keeps both changes or shows you a conflict and asks which one to keep. This is rare in practice because most people are not editing the exact same cell at the exact same moment.
If conflicts do happen, the service shows you both versions and lets you choose. You do not lose work — you just decide which version to keep. This is one of the main reasons cloud sharing is better than emailing files: the service manages the complexity for you.
To avoid conflicts altogether, divide the work: one person handles columns A through D, another handles E through H, and so on. Or one person works on the file Monday and Wednesday, another works Tuesday and Thursday. Communication prevents most conflicts before they start.
Frequently Asked Questions
Do I need to buy Excel to share a file with someone?
No. The person receiving the link can edit in a web browser for free, even if they do not own Excel. If they have Excel installed on their computer, they can open the file there instead, but the browser version is sufficient for most tasks. Only advanced features like certain macros or complex add-ins require the desktop version.
What happens if someone loses internet connection while editing?
Most cloud services let you work offline. Changes save locally on your device, and when you reconnect to the internet, they sync to the cloud and appear for everyone else. OneDrive, Google Drive, and Dropbox all support this. Check your service's settings to turn on offline editing if you need it.
Can I password-protect a shared Excel file?
You can password-protect the file itself (so people need a password to open it), but this is separate from sharing permissions. Set the file password in Excel under File > Info > Protect Workbook. Then share the link and tell people the password separately. This adds a layer of security if the link is forwarded to someone you did not intend to share with.
What if I want to stop sharing the file?
Go back to your cloud storage service, open the sharing settings for that file, and change the permission to View or remove the link entirely. Anyone with the old link can no longer access it. This takes effect when ready — you do not have to contact people individually.
Can I see who edited what and when?
Yes. OneDrive and Google Drive both show a version history. Click Version History or See all versions in the file menu, and you can see who made changes and when. You can even restore an earlier version if someone made a mistake. This is another advantage of cloud sharing over emailing files.