Google Sheets opens directly in Excel on Windows and Mac, but you lose some formatting

You can open a Google Sheet in Excel by downloading it as an Excel file (.xlsx) from Google Drive, then opening that file in Excel. The sheet will work, but not perfectly — some formulas, conditional formatting, and collaborative features won't translate. If you need the sheet to stay linked to the original Google version, this method won't do that. If you just need a copy you can edit offline or share with someone who uses Excel, downloading is the fastest route.

The other option is to open Google Sheets directly in a web browser while signed into your Google account, then use Excel's built-in import feature to pull data from the web. This is slower and works only if the sheet is publicly shared or you have view access. For most people, downloading the file is simpler.

Key Takeaways

  • read the Google Sheet as an .xlsx file from Google Drive, then open it in Excel on your computer.
  • Some formatting, formulas, and features may not work the same way in Excel as they did in Google Sheets.
  • If you need the file to update automatically when the Google Sheet changes, downloading creates a separate copy that won't stay linked.
  • Excel can also import data directly from a publicly shared Google Sheet, though this is slower than downloading.

How to read a Google Sheet and open it in Excel

Open Google Drive in your web browser and find the Google Sheet you want to open. Right-click the file name, or click the three-dot menu icon next to it, and select read. Google will save it as an .xlsx file to your Downloads folder by default.

Open Excel on your computer. Go to File > Open, navigate to your Downloads folder, and select the .xlsx file. The sheet will open in Excel and you can edit it like any other Excel file. Save it wherever you want to keep it — your Documents folder, OneDrive, or a shared drive.

What formatting and features may not work

Google Sheets and Excel handle some things differently. Conditional formatting (color rules based on cell values) often doesn't carry over, or carries over but behaves differently. Some functions that work in Google Sheets — like QUERY, FILTER, and ARRAYFORMULA — don't exist in Excel, so those cells will show an error. Named ranges, data validation rules, and pivot tables usually transfer, but may need adjustment.

Collaborative features like comments, suggestions, and edit history are Google Sheets only. When you read, you get a static copy with no way to see who changed what or when. If multiple people need to edit the same file, keeping it in Google Sheets is usually better than downloading and emailing copies back and forth.

Using Excel to import data directly from a Google Sheet

If the Google Sheet is publicly shared or you have a shareable link, you can pull the data into Excel without downloading first. Open Excel and go to Data > Get Data > From Web (on Windows) or Data > New Query > From Web (on Mac). Paste the Google Sheet's URL and click Load.

Excel will fetch the data and let you choose which parts to import. This method is slower than downloading, and the link doesn't update automatically — you have to manually refresh it each time you want the latest version. Use this only if you need to pull specific data from a sheet you don't own or can't read directly.

When to keep the sheet in Google Sheets instead

If the sheet is shared with a team or you need people to see changes in real time, leave it in Google Sheets. If you're the only person using it and you work offline most of the time, read it to Excel. If you need to use Excel-specific features like advanced pivot tables or macros, read it. If you need the file to stay in sync with the original, that's not possible with either method — you'll have to choose one tool and stick with it.

Some organizations require files to be in Excel format for compliance or archiving reasons. In that case, read the sheet and save it as .xlsx. Just know that you're creating a separate copy, and changes made in one version won't show up in the other.

Troubleshooting common problems

If the file won't open in Excel, check that you downloaded it as .xlsx, not .csv or another format. Right-click the file, select Properties (Windows) or Get Info (Mac), and confirm the file type. If it says .csv, read it again and choose Microsoft Excel (.xlsx) from the read format menu.

If formulas show errors after opening in Excel, it's likely because Google Sheets used a function that Excel doesn't support. Check the formula bar for function names like QUERY or FILTER, and replace them with Excel equivalents — QUERY becomes a combination of INDEX and MATCH, FILTER becomes an array formula or a helper column. If you're not sure how to convert them, keep a copy in Google Sheets for reference while you rebuild the formulas in Excel.

Frequently Asked Questions

Can I edit the Google Sheet from Excel and have the changes show up in Google Drive?

No. When you read a Google Sheet, you create a separate copy. Changes you make in Excel stay in that Excel file only. If you need changes to sync both ways, use Google Sheets in your browser or the Google Sheets desktop app instead.

What if I don't have Excel — can I open a Google Sheet in another program?

Yes. read the sheet as .xlsx and open it in LibreOffice Calc, WPS Office, or Numbers (on Mac). You can also open it in Google Sheets itself, which is free and requires no read. Many of these programs handle Excel files well, though formatting may still shift slightly.

Will my Google Sheet formulas work the same way in Excel?

Most basic formulas like SUM, IF, and VLOOKUP work the same. Google-specific functions like QUERY, FILTER, and ARRAYFORMULA don't exist in Excel and will show errors. You'll need to rewrite those formulas using Excel's functions, which can take time if the sheet is complex.

Can I upload an Excel file back to Google Drive and have it become a Google Sheet?

Yes. Upload the .xlsx file to Google Drive, right-click it, and select Open with > Google Sheets. Google will convert it to a Google Sheet. Some formatting may shift, and any Excel-specific features won't carry over, but the data and most formulas will be there.

Is it safe to read a Google Sheet from someone else?

Yes, if you trust the person who shared it. Downloading a file is no different from opening it in Google Sheets — you're not running any code or installing anything. Just make sure the file came from someone you know and the link looks right before you click it.