How to Share Excel Files in Google Sheets or Excel

How-to basics · Updated November 21, 2026

To share an Excel workbook in Google Sheets, upload the .xlsx file to Google Drive, open it with Google Sheets, and use the Share button to set who can access it. If you want a live shared Excel workbook instead, save it to OneDrive and share it from Excel; that keeps it in Excel rather than converting it to a Google spreadsheet.

Choose Whether to Convert or Keep the Excel File

“Share Excel to spreadsheet” can mean two different things: opening an Excel file in Google Sheets and sharing it there, or letting other people collaborate on the original Excel workbook. Pick the route based on where your collaborators work and whether the workbook depends on Excel-specific features.

  • Choose Google Sheets if the group uses Google accounts and you want a browser-based spreadsheet that collaborators can edit together.
  • Keep it in Excel with OneDrive if people need Excel features, the workbook has complex formatting or data tools, or the team already uses Microsoft 365.
  • Send a copy if recipients only need to read or work independently. This does not provide live collaboration on one shared file.

Uploading a workbook is not the same as converting it. Google Sheets can open and edit many Excel files in their original Office format, but conversion creates a Google Sheets file. The original Excel file can remain in Drive as a separate copy, so check which file you are sharing before sending the link.

Prepare the Workbook Before Uploading

Before moving a workbook, save a clean copy and make sure it opens correctly in Excel for Microsoft 365 on Windows. Remove temporary sheets or private information that recipients should not see, check that formulas show expected results, and give the file a recognizable name. If the workbook contains confidential data, decide who should have access before uploading it to a shared Drive or folder.

For the smoothest transfer, use the .xlsx format for a standard workbook. Excel may also use formats such as .xlsm for macro-enabled workbooks, but Google Sheets does not run Excel VBA macros. If a workbook relies on macros, Power Query, specialized add-ins, or complex data connections, preserve an untouched Excel copy and test a duplicate in Sheets before asking others to rely on it.

It is also useful to note any important details that may not be obvious after conversion: named ranges, data validation rules, chart behavior, external links, and protected ranges. A quick visual check of the important worksheets can reveal issues that are easy to miss in a large workbook.

Upload and Open the Excel File in Google Sheets

In a web browser, sign in to Google Drive with the account that should own or manage the file. Select New > File upload, choose the Excel workbook from your computer, and wait for the upload to finish. You can also drag a file into a Drive folder in the browser. If it belongs in a shared folder, make sure you have permission to add files there.

Once the workbook appears in Drive, right-click it and choose Open with > Google Sheets. Depending on your Drive layout, you may also be able to open the file and select Google Sheets from the app options. When Sheets opens an Excel file without converting it, it can remain an Office-format file. Look for an Office file indicator or the .xlsx filename to confirm its format.

To create a native Google Sheets version, open the workbook and select File > Save as Google Sheets. Sheets creates a new spreadsheet in Google format; it does not mean the original .xlsx has been replaced. Rename the new file if needed, then inspect the converted workbook before sharing it. If you do not see that menu option, check that the file is open in Google Sheets and that your account or organization permits conversion.

Share the Spreadsheet and Set Access

With the correct spreadsheet open, select Share near the upper-right corner. Add a person’s email address to invite them directly, or use the general-access control to decide whether access is restricted or available to people with a link. Google Workspace administrators can limit the options, so a link-sharing choice may not be available in every organization.

For direct invitations, enter the recipient’s address and choose the role that matches the task:

  • Viewer: can read the spreadsheet but cannot change its contents.
  • Commenter: can read and add comments or suggestions, but cannot edit cell contents.
  • Editor: can change the spreadsheet. Give this access only to people who need to make changes.

For link access, choose the appropriate general-access setting and role, then copy the link and send it through a suitable channel. A link is not automatically public simply because it has been copied; the access setting determines who can use it. Conversely, “anyone with the link” may allow the link to be forwarded beyond the intended group, so use restricted access for sensitive material.

Recipients may need to sign in to the Google account that was invited. If someone reports that the link does not work, check whether their address was added correctly, whether they are signed into the right account, and whether their role is sufficient. Access to a shared folder can also affect the permissions they receive.

Check What Changed During Conversion

Google Sheets and Excel share many everyday spreadsheet capabilities, but they are not identical applications. After conversion, review formulas, formatting, charts, dropdowns, conditional formatting, frozen rows, filters, and print settings. A feature that looks similar may behave differently in the other program, and a workbook can contain elements that do not convert as expected.

Pay particular attention to formulas that use Excel functions or references that may not be supported in Sheets, as well as external data connections and links to other workbooks. Excel VBA macros do not become working Google Sheets scripts automatically. Google Apps Script is a separate system and requires its own code; it is not a drop-in way to run VBA.

For a small workbook, open each important sheet and compare key results with the original. For a business-critical file, test common tasks such as entering new data, refreshing information, printing, and using dropdowns. Keep the original Excel workbook until the converted file has been checked and the people who need it can use it successfully.

Share the Workbook in Excel with OneDrive Instead

If you want collaborators to work in Excel, store the workbook in OneDrive or a SharePoint location that supports sharing. In Excel for Microsoft 365 on Windows, save the workbook to that cloud location, then select Share in the upper-right area. Follow the sharing dialog to invite people or create a link, and set whether they can edit or only view. The exact options can depend on your Microsoft account and organization settings.

After sharing, collaborators can open the workbook in Excel for the web or a compatible Excel app, subject to their access and the workbook’s features. Cloud-based sharing lets people work from a common file instead of emailing separate versions back and forth. Avoid making multiple downloaded copies the main workflow: edits to a downloaded file do not automatically update the cloud workbook.

On Excel for Mac, the cloud-sharing process is also based on saving the workbook to OneDrive or SharePoint and using Share; wording and dialog layout can differ by app version. Excel for the web uses browser controls. If a colleague has only a Google account or is expected to work in Sheets, sharing a OneDrive link may not provide the experience they need—use the Google Sheets route or agree on a file format and application first.

Common Problems and Practical Fixes

  • The file opens as .xlsx, not as a Google Sheets file: that can be normal. Use File > Save as Google Sheets to make a converted copy, if conversion is available.
  • The Share button is missing or disabled: confirm you are signed in, that the file has finished uploading, and that your account has permission to share it. A school or work administrator may restrict sharing.
  • A recipient gets an access request: check the exact account they used and review the file’s sharing dialog. They may have opened the link while signed into a different account.
  • Formulas or formatting look different: compare the converted file with the original and test the affected cells. Keep using Excel for workbooks that depend on unsupported features.
  • Two people appear to have different versions: verify that everyone is opening the same Drive or OneDrive file, not an attachment or downloaded copy with a similar name.

When a workbook is shared from a folder, folder-level permissions may give people access even if you did not invite them individually to that file. Review the folder’s access as well as the spreadsheet’s settings if the audience seems broader than expected.

Protect the File and Its Information

Use the least access needed: Viewer for readers, Commenter for feedback, and Editor only for people who need to change cells or structure. Review access after a project ends and remove people who no longer need it. For sensitive workbooks, do not rely on a hidden sheet or a hard-to-guess link as protection; remove information that recipients should not receive and use your organization’s approved storage and sharing rules.

Sharing permissions control access to the file, but they are not the same as protecting individual cells or preventing every possible copy. An editor may be able to change data, and viewers may still have options to download or print depending on the service and settings. If the contents require stronger controls, ask the organization’s administrator about its approved information-protection tools.

Frequently Asked Questions

Can I share an Excel file in Google Sheets without converting it?
Yes. Upload the .xlsx file to Drive and open it with Google Sheets; it can remain an Office-format file. Convert it with File > Save as Google Sheets only if you want a native Sheets copy.

Will the original Excel file be deleted when I convert it?
No. Saving as Google Sheets creates a separate converted file in Drive. Keep track of both filenames so collaborators do not edit the wrong copy.

Can people edit the spreadsheet at the same time?
They can collaborate on the same shared Google Sheets file if they have Editor access. Excel also supports shared cloud workbooks through OneDrive or SharePoint when collaborators have suitable access and compatible apps.

Do Excel macros work in Google Sheets?
No. Google Sheets does not run Excel VBA macros. A macro-dependent workbook should generally remain in Excel unless its automation is deliberately rebuilt for a suitable Google environment.

How do I stop someone from changing the spreadsheet?
Set their role to Viewer or Commenter in the sharing dialog, rather than Editor. If they already have access through a shared folder or group, review those permissions too.

Can I share an Excel workbook with someone who does not have Excel?
Often, yes: a recipient may be able to view or edit through Excel for the web if they have the required Microsoft account and permissions. For Google-based collaboration, use a Google Sheets file and grant access through Google Drive.

Which Sharing Method Should You Use?

Use Google Drive and Google Sheets when the goal is a Google-based, browser-accessible shared spreadsheet, and verify the converted copy before relying on it. Use OneDrive or SharePoint when the workbook needs to remain an Excel file or depends on Excel-specific behavior. In either case, share one cloud-stored working copy, choose permissions deliberately, and tell collaborators which version is authoritative.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.