In this tutorial, you will learn how to convert a Google Sheets document to an Excel file.
How To Convert Google Sheets To Excel
When working with a project in Google Sheets, you might find yourself in a situation where you need to download your spreadsheet as an Excel file.
For example, you might be collaborating on a project with someone who doesn’t use Google Sheets and they need the data in Excel format. Or you may want to create an offline backup of the current project.
Luckily, it is easy to download a Google Sheet as an Excel file. In this guide, we’ll show you how to convert a Google Sheets project into an Excel file.
How To Export a Google Sheets Document to an Excel File
Here’s how to export a Google Sheets document to an Excel file.
Open the Google Sheets document you want to convert into an Excel file.
Click on the File menu on the upper-left corner of the screen.
Select the option Download > Microsoft Excel (.xlsx) to download the current project as an Excel file.
The output file will include all sheets found in the current Google Sheets document. Sheets that are hidden will also appear as hidden sheets in the Excel output file.
You should now have an Excel file containing all data found in your Google Sheets spreadsheet.
Do note that there are several formular and features that may not be compatible with Microsoft Excel. For example, functions such as IMPORTRANGE or GOOGLEFINANCE will return an error in the output file.
We can also convert a Google Sheets document to Excel from Google Drive. First, navigate to the folder containing the Google Sheets document you want to convert.
Right-click on the file and select the Download option.
Google Drive will indicate to the user that it is converting to Excel. Depending on how large the project is, the user will have to wait for a few seconds.
Your browser may prompt you to either open the file or save it in a specific location.
Similar to the previous method, the output of the download option will be an Excel file containing all sheets from the target Google Sheets document.
This guide should be everything you need to convert Google Sheets spreadsheets into Excel files.
You may make a copy of this example spreadsheet to test it out on your own.