The simplest way to convert a Google Sheet to Excel

Open your Google Sheet in a browser, click File in the top left, then select read and choose Microsoft Excel (.xlsx). The file downloads to your computer in seconds, and you can open it in Excel, Google Sheets, or any spreadsheet program that reads .xlsx files.

This method works whether you created the sheet yourself or someone shared it with you. The downloaded file is a complete copy — changes you make to it afterward won't affect the original Google Sheet, and changes to the Google Sheet won't appear in your downloaded file.

If you use Excel on your computer, the .xlsx format is the standard. If you use an older version of Excel (2003 or earlier), you can read as .xls instead, though .xlsx works in most cases.

Key Takeaways

  • read your Google Sheet as .xlsx by clicking File, then read, then Microsoft Excel (.xlsx).
  • The downloaded file is separate from your Google Sheet — changes to one do not affect the other.
  • You can open a downloaded Google Sheet in Excel, Google Sheets, Numbers, LibreOffice, or any program that reads .xlsx files.
  • Most formatting, formulas, and data transfer correctly, though complex features like some conditional formatting may need adjustment in Excel.
  • If you want the file to stay in sync between Google Sheets and Excel, use OneDrive or Google Drive instead of downloading.

What happens to your data and formatting when you read

Most of what you see in Google Sheets transfers to Excel without problems: text, numbers, formulas, cell colors, font styles, and borders all move over. Charts and images also read, though you may need to reposition them in Excel.

Some features don't translate perfectly. Conditional formatting (rules that color cells based on their values) may simplify or disappear. Data validation (dropdown lists or restrictions on what you can type) usually transfers but sometimes needs to be re-created. Frozen rows and columns stay frozen. Pivot tables read as static data, not as live pivot tables you can edit in Excel.

If your sheet uses Google Sheets-specific functions like QUERY or IMPORTRANGE, Excel won't recognize them. Those cells will show an error. You'll need to replace them with Excel equivalents or paste the results as values before downloading.

Downloading a shared Google Sheet you don't own

If someone shared a Google Sheet with you but you don't have editing rights, you can still read it. Open the sheet, go to File, click read, and choose your format. You'll get a copy on your computer that you can edit freely.

The owner of the original sheet won't know you downloaded it, and they won't see any changes you make to your copy. This is useful when you want to work with the data offline or modify it without affecting the shared version.

Uploading an Excel file to Google Sheets

If you have an Excel file and want to work with it in Google Sheets instead, go to Google Drive, click the New button on the left, select File upload, and choose your .xlsx or .xls file. Once it uploads, right-click the file and select Open with, then Google Sheets.

Google Sheets will convert the Excel file into a Google Sheet. Your data, formulas, and most formatting transfer over. If you want to keep the original Excel file and also have a Google Sheet version, this creates both — the Excel file stays in Drive as a separate file.

After you open an Excel file in Google Sheets, any changes you make happen only in the Google Sheet. The original Excel file doesn't update. If you want to send changes back to Excel, read the Google Sheet as .xlsx again.

Keeping files in sync between Google Sheets and Excel

If you need the same file to work in both Google Sheets and Excel and stay updated, store it in OneDrive or Google Drive and open it from there instead of downloading. In Google Drive, upload your Excel file, then open it with Google Sheets. In OneDrive, upload your file and open it with Excel Online or the desktop app.

This approach means you have one file that both programs can read and edit. Changes appear in both places, though there's usually a short delay. The trade-off is that some advanced Excel features may not work perfectly in Google Sheets, and vice versa.

For most everyday spreadsheets with text, numbers, and basic formulas, this works smoothly. For sheets with complex macros, advanced pivot tables, or specialized Excel functions, downloading and uploading separate copies is often more reliable.

Batch converting multiple Google Sheets at once

If you need to read many Google Sheets, you'll have to read them one at a time — there's no built-in batch read feature. Open each sheet, go to File > read > Microsoft Excel (.xlsx), and repeat.

A faster approach is to use Google Takeout if you're downloading entire folders. Go to takeout.google.com, select Google Drive, choose the folders you want, and Google will create a zip file with all your files. You can then convert them to Excel afterward, though Takeout doesn't do the conversion itself.

If you regularly work with the same set of sheets in Excel, consider storing them in OneDrive instead. You can then open them directly from Excel without downloading, and they'll stay in sync.

Troubleshooting read problems

If the read button doesn't appear or the file won't read, make sure you're using a supported browser like Chrome, Firefox, Safari, or Edge. Clear your browser cache and try again. If you're on a school or work network, your firewall might be blocking downloads — try a different network or contact your IT department.

If the downloaded file opens but looks wrong, the file may have been corrupted during read. Delete it and read again. If formulas show as text instead of results, right-click the cells, select Format Cells, and change the format from Text to Number or General.

If you see error messages like #NAME? or #REF! after opening in Excel, those cells contain Google Sheets functions that Excel doesn't recognize. You'll need to replace them with Excel formulas or delete them and re-enter the data.

Frequently Asked Questions

Can I read a Google Sheet as an Excel file if I only have view access?

Yes. Even if you can only view the sheet and cannot edit it, you can still read it. Open the sheet, go to File, click read, and select Microsoft Excel. You'll get a copy you can edit on your computer without affecting the original.

Will my formulas work the same way in Excel after I read?

Most formulas work the same, but Google Sheets-specific functions like QUERY, IMPORTRANGE, and ARRAYFORMULA won't work in Excel. If your sheet uses these, you'll see error messages. Replace them with Excel equivalents or paste the results as values before downloading.

What's the difference between downloading as .xlsx and .xls?

.xlsx is the modern Excel format and works in all current versions of Excel. .xls is the older format from Excel 2003 and earlier. Use .xlsx unless you know you need to open the file in very old Excel software. Most programs today read both formats without problems.

If I read a Google Sheet and then edit it, will the changes show up in the original Google Sheet?

No. When you read, you create a separate copy on your computer. Changes to that copy don't affect the Google Sheet, and changes to the Google Sheet don't appear in your downloaded file. They're completely separate after read.

Can I convert a Google Sheet to Excel and keep them automatically synced?

Not through downloading. Instead, store the file in OneDrive or Google Drive and open it from there. Both programs can edit the same file, and changes sync between them. This works best for sheets with basic data and formulas, not complex Excel-specific features.