Will Google Sheets Open Excel Files? Formats and Tips

Updated 6 November 2026 · Standard formula, shown below

Yes. Google Sheets can open Excel workbooks, including common .xlsx and .xls files, either by importing a file or opening it from Google Drive. You can work with the spreadsheet in Sheets and, when needed, download or save a copy in an Excel format.

Which Excel files can Google Sheets open?

Sheets supports the main Excel workbook formats used for everyday spreadsheets. These include .xlsx, the standard format for modern Excel workbooks, and .xls, an older Excel format. It can also work with other common tabular files, such as comma-separated values (.csv), although a CSV is data rather than a full spreadsheet workbook: it does not preserve multiple sheets, formulas in the same way, or most formatting.

Opening a file does not guarantee that every Excel feature will behave identically. Basic cells, formulas, tables of figures, and much ordinary formatting usually transfer well. Specialized features or workbook elements may need adjustment after conversion.

How to open an Excel file in Google Sheets

There are two common routes: open the file directly from your computer, or upload it to Google Drive first. The labels and layout can vary slightly as Google updates its interface, but the general workflow is straightforward.

Open Sheets: Go to Google Sheets and sign in to the Google account you want to use.
Choose a file: From the Sheets home screen, use the option to open or upload a file, then select the Excel workbook from your device. Alternatively, upload the file to Google Drive and open it there; Drive can open compatible spreadsheets with Sheets.
Review the workbook: Check its tabs, formulas, number formats, charts, and any features important to your work. If prompted to import or convert, read the options before proceeding.
Decide how to save: Keep the workbook in its original Excel format if you need to preserve it as an .xlsx or .xls file, or convert it to a Google Sheets file if you want a native Sheets document.

For a one-time look, opening an uploaded Excel file without converting it may be enough. If you plan to collaborate or edit it regularly in Sheets, converting it can make the document easier to manage with Google’s sharing and editing tools.

Opening versus converting: what changes?

Opening an Excel workbook and converting it to Google Sheets are related but different actions. When you work with an Excel file in its original format, Sheets can let you edit it while retaining the Excel file type. A converted file is saved as a Google Sheets document instead. The choice affects the file format and can affect feature compatibility, so keep the original if it is an important workbook.

Conversion is not the same as making a perfect, feature-for-feature copy. A workbook may contain Excel-specific features that Sheets cannot reproduce exactly. If compatibility matters, keep a backup and compare the converted version with the original before relying on it.

Keep Excel format: Useful when colleagues expect an .xlsx file or the workbook must return to an Excel-based workflow.
Convert to Sheets: Useful when you want to work primarily in Google Sheets, share through Drive, or use Sheets-specific collaboration features.
Keep both: A sensible option for important files: preserve the original Excel workbook and work from a separate converted copy.

What may not transfer perfectly?

Most simple workbooks are easy to use across both applications, but complex files deserve a careful review. Potential trouble spots include advanced formulas, macros, certain chart types, conditional formatting, data validation, external connections, and specialized Excel add-ins or features. A formula may be supported but display differently, or a workbook feature may be unavailable in Sheets.

Excel macros are a frequent source of confusion. Sheets does not run Excel’s VBA macros as if it were Excel. If a workbook depends on VBA to automate tasks, opening it in Sheets will not make those macros run. Google Sheets has its own automation options, but adapting an Excel macro may require rewriting the automation rather than simply importing it.

After opening or converting a complex workbook, check calculations and outputs rather than assuming that a successful upload means every function is intact. Pay special attention to financial models, reports, charts, and worksheets with hidden or protected content.

Sharing, editing, and downloading

Once a workbook is open in Sheets, you can use Google Drive’s sharing controls to collaborate, subject to the account and file permissions. People who only need to view a file do not necessarily need to edit it; choose access settings deliberately. If the workbook contains sensitive information, avoid sharing a public link and confirm who has access.

To return a Sheets document to Excel format, use the download options in Sheets and choose Microsoft Excel (.xlsx). The downloaded file is a separate copy; later edits to it do not automatically update the Google Sheets document, and edits in Sheets do not automatically update a copy already downloaded to your computer. If several people edit different copies, changes can diverge, so agree on which file is the main version.

Common problems and fixes

The file will not upload: Check that it is a supported spreadsheet file, that you selected the intended file, and that your internet connection is working. If it is unusually large or complex, try opening it in Excel and saving a fresh .xlsx copy.
Numbers or dates look wrong: Check the cell format and spreadsheet locale. Dates and decimal separators can be interpreted differently depending on regional settings, so compare a few known values with the original.
Formulas show errors: Confirm that the formula is supported and that referenced sheets or ranges came across. Compare the formula and its result in the original workbook before changing data.
A chart or layout changed: Review the relevant chart settings, page layout, and formatting in Sheets. For print-ready or presentation-critical work, inspect a downloaded Excel copy in Excel too.
You cannot edit: Check whether the file is view-only or whether you have permission to edit it. A file owner or administrator may need to change access.

Frequently Asked Questions

Can Google Sheets open .xlsx files?
Yes. You can upload or open an .xlsx workbook in Google Sheets, then edit it or convert it to a Google Sheets file. Review complex features after opening.

Can Google Sheets open .xls files?
Yes, Sheets can work with the older .xls Excel format. For an older or complicated workbook, check formulas and layout after it opens.

Will opening an Excel file change the original?
Not simply because you selected it to open. The exact behavior depends on whether you keep it as an Excel file or convert it. Preserve a separate copy when the original must remain unchanged.

Can I edit an Excel file in Google Sheets and save it as Excel?
Yes. You can edit a compatible workbook and download it in .xlsx format. Check the downloaded copy, since some Excel-specific features may not be preserved perfectly.

Do Excel macros work in Google Sheets?
No. Sheets does not run Excel VBA macros. A workbook that relies on VBA automation may need to remain in Excel or have its automation recreated for Sheets.

Can I open an Excel file in Sheets on my phone?
Sheets and Drive mobile apps can open compatible spreadsheet files, though some editing and file-management options may differ from the desktop experience. For complex workbooks, a computer can make it easier to inspect every sheet and feature.

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.