In this article we will show you how to convert Excel to Google Sheets in just a few clicks. Simply follow the steps below.
Open Google Sheets and in the file menu click Import .
A popup box will appear showing different locations to import your excel file from.
In our example we will upload a file from our computer by clicking Browse in the ‘upload’ option.
In the file location popup window, select the location on your computer where your excel file is located.
Select the file and then click the Open button.
A new menu will appear that will display different import options for your excel file.
In our example below, we will import an excel spreadsheet into the blank Google Sheets page we already have open so we will click “Replace spreadsheet”.
A warning will appear letting you know that any pre-existing data in your google sheet will be lost and replaced with your imported excel sheet.
The file will then open in Google Sheets and will be immediately converted from excel to google sheets.
In Google Drive, right click in the center of the screen and from the dropdown menu select File upload.
A file explorer window will appear. Select the location of your file, then click it to upload.
Alternatively, drag and drop the file directly into your Google Drive.
In the below example we have dragged and dropped the file.
Once your excel file appears in your drive folder you can double click it to automatically open it in Google Sheets.
Note at the top of the page the excel file type “.XLSX” is displayed.
To convert your excel file to Google Sheets, click File in the file menu. From the dropdown select Save as Google Sheets
A new window will open to display your file, this time in Google Sheets format. The “.XLSX” display will also have been removed from the top of the page.
In your Google Drive folder both files will now be present, one in Excel format and the other in Google Sheets format.
In our below example, the new Google Sheets file is on the right (with the .XLSX excel file type)
We hope this article has helped you and given you a better understanding of how to convert Excel to Google Sheets. You might also like our articles on how to import a Zendesk report to Google Sheets and how to convert Google Sheets to Excel.
To optimize your workflow, we recommend reading our guide on how to send emails from Google Sheets and trying our software to help you manage renewals efficiently.
Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.
.png)
