See all How-To Articles

How to Convert an Excel File to Google Sheets

This tutorial demonstrates how to convert an Excel file to a document in Google Sheets.

 

excel file convert to google sheets

 

An Excel file may be converted to Google Sheets in two ways: by uploading a file from a computer or by converting an existing file from Google Drive.

Convert an Excel File

Upload to Google Drive

An Excel file can be converted while uploading it from a computer to Google Drive. Say you have an Excel file containing the data pictured below that you want to convert to Google Sheets.

 

excel file convert

 

  1. Click on the New button in Google Drive.

 

google drive upload file

 

  1. Choose File upload from the menu.

 

google drive upload file 2

 

  1. In the Open window, select an Excel file and click Open.

 

google drive upload file 3

 

As a result, the Excel file is uploaded to Google Drive and converted to a Google Sheets file with the same name. When you open the file, it has the same content and structure as the original Excel file, shown in the picture below.

 

google sheets file from excel

 

Convert Google Drive File

If you already have an Excel file in Google Drive, you can easily convert it to Google Sheets.

  1. Right-click on the file in Google Drive.
  2. Go to Open with.
  3. Then click Google Sheets.

 

convert excel file from google drive

 

The result is the same as in the previous section: The Excel file is converted to Google Sheets.

Convert Excel to Google Sheets Automatically

In addition to the previous methods, you can also change your Google Drive settings to automatically convert all uploaded Excel files to Google Sheets format.

  1. In the top right corner of Google Drive, click the Settings icon, and choose Settings.

 

google drive settings

 

  1. In the Settings window, check Convert uploaded files to Google Docs editor format and click Done.

 

google drive settings 2

 

  1. Now if you upload the Excel file to Google Drive, it will be automatically converted to Google Sheets.

 

google drive settings 3

The green icon next to the file name means that the file has the Google Sheets format.