By converting your Google Sheet to Microsoft Excel, you can edit your spreadsheet locally with the Excel app on your computer. Weāll show you how to perform this conversion on both the Google Sheets and the Google Drive sites.
Some Google Sheets Functions Donāt Work in Excel
Google Sheets has certain functions that are not supported by Excel. If your spreadsheet uses one or more of these functions, you will need to remove them or replace them with Excel-compatible functions before converting your files. Open as App keeps a list of Google Sheets functions that donāt work in Excel, so check it out to make sure you donāt end up with a broken sheet.
Convert a Google Sheet to Excel From the Google Sheets Website
If you prefer the Google Sheets site to access your spreadsheets, use this method for the conversion.
First, on your Windows, Mac, Linux, or Chromebook computer, launch a web browser and head over to the Google Sheets site. Log in to your account if you arenāt already.
On the Sheets site, select the sheet youād like to convert to Excel.
Your sheet will open on the Sheetsā editing screen.
From the menu bar on the Sheetsā editing screen, select File> Download> Microsoft Excel.
You will see your computerās standard āsaveā window where you can save the resulting Excel file. In this window, choose a folder to save your file in, type a name for your file, and click āSave.ā
And thatās it. The Excel version of your selected Google Sheet is now available in the specified folder on your computer. You can use a similar process to convert Google Docs to Word files.
Convert a Google Sheet to Excel From the Google Drive Website
If you access your Google Sheets from the Google Drive site, use this method for your conversion. A benefit of this method is that you can use this to convert multiple Google Sheets to Excel at once.
Start by launching a web browser on your Windows, Mac, Linux, or Chromebook computer and accessing the Google Drive site. Log in to your account on the site.
On the Google Drive site, find the Google Sheet to convert to Excel.
Right-click the Google Sheet and select āDownloadā from the menu.
You will see your computerās standard āsaveā window to save your Excel file. Here, select a folder to save your file, enter a name for your file, and click āSave.ā
And your Google Sheet is now available as an Excel file on your computer. Enjoy locally editing your spreadsheets!
Went Excel and want to go back?Ā Converting an Excel spreadsheet to Google SheetĀ is as easy as the guide above.