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.
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.