Google Sheets are a great way to keep track of data, but they can be difficult to convert to Excel. Here are some tips to help you get started:
- Start by creating a new Google Sheet. This will give you a clean slate and will be easier to work with.
- In the sheet’s header, enter the name of the spreadsheet you want to convert. For example, “MySheet1”.
- In the “Data” section, enter the data you want to track in Excel. For example, your sales data from last year.
- In the “Workbook” section, enter the name of your spreadsheet and click on the “Create Workbook” button.
- In the “Workbook” section, click on the “Add Data Sources” button and select your sales data from last year from the list that appears. Click on OK to add your data and close the sheet’s window.
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.
RELATED: How to Convert a Google Docs Document to Microsoft Office Format
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.
RELATED: How to Import an Excel Document into Google Sheets
