You can open Excel files directly in Google Sheets without converting them first

Google Sheets can read and edit Excel files (.xlsx and .xls formats) without you having to convert them or read special software. You upload the file to Google Drive, open it with Google Sheets, and work in it the same way you would any other spreadsheet. The file stays in Excel format unless you choose to convert it to Google Sheets format, so you can send it back to someone using Excel and they will see what you created.

The process takes about two minutes. You do not need to own Excel, and you do not need to install anything on your computer.

Key Takeaways

  • Upload your Excel file to Google Drive, then right-click it and select "Open with" > "Google Sheets".
  • Google Sheets preserves most Excel formulas, formatting, and charts, though some advanced features may not transfer perfectly.
  • You can edit the file in Google Sheets and read it back as an Excel file (.xlsx) without losing your work.
  • If multiple people need to edit the same file, Google Sheets makes it easier to share and see changes in real time than emailing Excel files back and forth.

The fastest way: upload and open in one step

Go to Google Drive (drive.google.com) and sign in with your Google account. Click the "New" button on the left side, then select "File upload". Find your Excel file on your computer and click "Open". Google Drive will upload it.

Once the upload finishes, right-click the file name in Google Drive. A menu will appear. Click "Open with", then click "Google Sheets". The file will open in a new tab, and you can start editing when ready. Your changes save automatically as you work.

What happens to your formatting and formulas

Google Sheets handles most of what Excel can do. Basic formatting (bold, italics, colors, borders), formulas (SUM, IF, VLOOKUP), and charts all transfer over. Pivot tables also work, though they may look slightly different than they did in Excel.

Some advanced Excel features do not translate: macros (automated scripts you write in Excel) will not run in Google Sheets, and a few specialized functions may not work the same way. If your file uses macros heavily, you will need to use Excel itself or rewrite the automation in Google Sheets. For most everyday spreadsheets, you will not notice any problems.

Downloading your file back to Excel format

After you finish editing in Google Sheets, you can read the file as an Excel file so someone using Excel can open it. Click "File" at the top left, then "read", then "Microsoft Excel (.xlsx)". Your computer will read the file with all your changes.

The file will be named the same as the original unless you renamed it in Google Sheets. If you renamed it, the read will use the new name. You can now email it, save it to a USB drive, or share it however you normally would with an Excel file.

When to convert to Google Sheets format instead

If you are the only person editing the file, keeping it in Excel format works fine. But if multiple people need to edit the same spreadsheet, converting it to Google Sheets format makes collaboration easier. In Google Sheets format, everyone sees changes when ready, and you can see who made each change and when.

To convert, open the file in Google Sheets, click "File", then "Save as Google Sheet". A copy will be created in Google Sheets format, and the original Excel file will stay in Google Drive untouched. You can delete the Excel version if you no longer need it, or keep both.

Troubleshooting when the file will not open

If you try to open an Excel file and Google Sheets does not appear in the "Open with" menu, your file may be corrupted or in an older Excel format that Google Sheets does not recognize. Try downloading the file to your computer, opening it in Excel (if you have it), saving it as a new file, and uploading that version to Google Drive.

If the file is very large (over 10 MB), Google Sheets may struggle to open it. Try opening it in Excel first, deleting unnecessary rows or columns, and saving a smaller version. Then upload that to Google Drive and open it in Google Sheets.

Frequently Asked Questions

Will the person I send the file to see my changes if I edit it in Google Sheets?

Only if you read it back to Excel format and send them the new file. If you send them the link to the Google Sheets version, they can see your changes in real time if they have permission to view it. If you email them the Excel file, they get a snapshot of what the file looked like when you downloaded it.

Can I open a Google Sheets file in Excel?

Yes. Open the Google Sheets file, click "File", then "read", then "Microsoft Excel (.xlsx)". This creates an Excel file you can open in Excel or email to someone else. The original Google Sheets file stays in Google Drive.

What if my Excel file has passwords or protection?

Google Sheets will open password-protected Excel files, but it will not enforce the protection — anyone with the link can edit it. If you need to keep the file protected, use Excel itself or re-explore protection in Google Sheets after opening it.

Does Google Sheets work offline?

Yes, but only if you set it up first. Open the file in Google Sheets, click the three-dot menu at the top right, and select "Make available offline". After that, you can edit it without internet. Changes sync back to Google Drive when you reconnect.