In this article:

Convert Excel to Google Sheets (Easiest Way in 2024)

In this article we will show you how to convert Excel to Google Sheets in just a few clicks. Simply follow the steps below.

Convert an Excel File to Google Sheets Via File Import

1. Open a Google Sheet and From the File menu click ‘Import’

Open Google Sheets and in the file menu click Import .

How do i convert an excel spreadsheet to Google Sheets

2. Select the File Import Method  

A popup box will appear showing different locations to import your excel file from.

  • My drive
  • Shared with me
  • Recent
  • Upload 

In our example we will upload a file from our computer by clicking Browse in the ‘upload’ option.

Converting an excel file to Google Sheets

3. Select the Location of the File to Import

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.

Uploading a file to convert to Google Sheets

4. Select the Import Method from the Dropdown Menu

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

Converting excel files into Google Sheets 

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. 

How to import and convert excel files into Google Sheets

5. Click Import Data to Import your Excel Spreadsheet into Google Sheets

The file will then open in Google Sheets and will be immediately converted from excel to google sheets.

Converting files from excel to Google Sheets automatically 

Convert an Excel File to Google Sheets Via Save As

1. Open Google Drive and upload an Excel File. 

In Google Drive, right click in the center of the screen and from the dropdown menu select File upload.

Convert excel to Google Sheets 

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.

How to convert an excel spreadsheet to Google Sheets

2. Double Click on the Excel File to Open it in Google Sheets.

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.

Automatically convert excel spreadsheet to Google Sheets

3. From the File Drop Down Menu Select “Save as Google Sheets”

To convert your excel file to Google Sheets, click File in the file menu. From the dropdown select Save as Google Sheets

How to convert excel spreadsheet to Google Sheets

4. The File has Now Been Converted from Excel to 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.

How to convert an excel file to Google Sheets

5. Return to Google Drive to see both files  

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)

How to convert an excel file to Google Sheets

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.

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
Creates a one- or multiple-day calendar event with optional attendees
Adds an object to Hubspot
Create a Slack channel, and optionally add a topic or members
Makes any HTTP request
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
Makes any HTTP request and returns the response
Inserts given array below defined values in given worksheet
Sends an email using your Google account
Sends an email using your Microsoft Outlook account
Sends a Slack message
Sends an SMS message using your Twilio account
Updates cells with given values
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started