Last Updated on December 5, 2022 by Jake Sheridan
If you’re used to working in Microsoft Excel, you may be wondering how to convert your Excel files over to Google Sheets. There are many possible reasons why you want to convert an Excel file to Google Sheets.
For example, you may have a local Excel file that you want to share with other collaborators through Google Drive.
In this guide, we will show you how to convert your Excel files to Google Sheets step-by-step.
How To Convert Excel To Google Sheets
In addition to Google Sheets files, you can also store Excel files in Google Drive.
Excel files will appear in Google Drive with a different icon from Google Sheets Files. Both icons are green but Excel icons have a white X and Google Sheets icons have a white cross:
And when the file is open, you can tell that it is an Excel file by the green “.XLSX” badge beside the filename:
It’s possible to edit Excel files within Google Drive, and Google continues to improve editing capabilities for Excel files.
But there are some features and collaboration tools that are unavailable when working with Excel files in Google Drive, so you may want to convert Excel files that you store in Google Drive into Google Sheets.
Convert Excel Files
To convert an Excel file in Google Drive into Google Sheets, follow these steps:
Open the file you want to convert by double clicking on it in Google Drive.
Bring up the File menu and select Save as Google Sheets:
A Google Sheets copy of the Excel file will be created in the same Google Drive folder and automatically opened in a new tab
Most Excel features are available in Google Sheets so the majority of Excel files will convert perfectly into Google Sheets, but it’s a good idea to check the converted file to be sure it’s working correctly and the formatting looks right before sharing it with collaborators.
How to Upload an Excel File as a Google Sheets Document
Here’s how to upload an Excel file as a Google Sheets document.
First, we’ll explain how to convert an Excel file that has not yet been uploaded to Google Drive. In the Google Sheets homepage, click on the Open file picker icon.
In the Open a file dialog box, head to the Upload tab. You may either click the Browse button to select a file or drag the file into the window yourself with your cursor.
Excel will now convert the Excel file into a format that is compatible with Google Sheets. This process may take up to a minute for larger files.
You should now be able to view the contents of your Excel file in the Google Sheets editor.
If your Excel file is already uploaded in Google Drive, there is an even quicker way to convert the file to Google Sheets. Right-click on the file and select Open with > Google Sheets.
You should now be able to view and edit the Excel file as if it was a Google Sheets document.
You may make a copy of this example spreadsheet to test it out on your own.
Example GSheets Spreadsheet: Make a copy of the example spreadsheet
Example .XLSX Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to convert Excel to Google Sheets. Want more? Check out all the Google Sheets Tutorials.