How to Convert Excel to Google Sheets (a Step-by-Step Tutorial)

If you work with Google Sheets, there may be times when you have to convert Excel to Google Sheets. This allows you to collaborate with others and benefit from the powerful features of Google Sheets.

There are a couple of ways to convert Excel to Google Sheets:

  1. Convert by importing an Excel file to Google Sheets
  2. Convert while uploading to Google Drive
  3. Upload to Google Drive and then Convert

Let’s go through these methods in detail.

Convert Excel To Google Sheets by Importing an Excel File to Google Sheets

Here are the steps to convert Excel to Google Sheets by importing the Excel file:

  1. Go to Google Drive Homepage and log in using your credentials.
  2. In the Google Drive Homepage, click on the New button and select Google Sheets.Convert Excel To Google Sheets - New Google Sheets
  3. In the new Google Sheet that opens, go to File and click on Import.Convert Excel To Google Sheets - import
  4. In the Import File dialog box, select the Upload tab.
  5. Drag the Excel file that you want to convert to the dialog box, or click on ‘Select a file from your computer’ and then select it manually.Convert Excel To Google Sheets - Upload
  6. Once the file is uploaded, you will see a dialog box as shown below. You can create a new spreadsheet, insert new sheets in the open Google Sheet, or replace the open Google Sheet with the imported file. Convert Excel To Google Sheets - import dialog box

In my opinion, the conversion is almost flawless. I have converted many Excel files into Google Sheets (that had formulas and conditional formatting), and in most of the cases, I got a perfect conversion.

However, in some cases, you would lose some functionalities when you convert an Excel to Google Sheets:

  • Macros don’t work in Google Sheets.
  • Interactive controls would not work.
  • There are features in Excel that are not yet available in Google Sheets (such as split worksheet, linked shapes, and charts)

This method is best suited when you have a couple of Excel files that you want to convert to Google Sheets.

Convert Excel to Google Sheets while uploading to Google Drive

This method is best suited when you have a lot of Excel files that you want to convert to Google Sheets.

Here are the steps to convert Excel to Google Sheets while uploading to Google Drive:

  1. Go to Google Drive Homepage and log in using your credentials.
  2. Click on the gear icon on the top right.Convert Excel To Google Sheets - gear
  3. Click on Settings.Convert Excel To Google Sheets - gear settings
  4. In the Setting dialog box, select the option ‘Convert uploaded files to Google Docs editor format’.
  5. Click on Done.

Now, when you upload an Excel file to Google Drive, it will automatically be converted into the Google Sheets format.

Upload An Excel File to Google Drive and then Convert to Google Sheets

If you already have some Excel files in Google Drive, or if you don’t like the idea of Google Drive automatically converting your files to Google Sheets format, this method is for you.

You can choose to convert selected files into the Google Sheets format.

Here are the steps to Convert an Excel file in Google Drive into Google Sheets:

  • Right-click on the file that you want to open in Google Sheets.
  • Go to Open with and click on Google Sheets.Convert Excel To Google Sheets - from google drive

This will open the file in Google Sheets, however, your file in the Google Drive would continue to be in the Excel file format.

Related Tutorials:

You May Also Like the Following Google Sheets Tutorials:

FREE Google Sheets Tips Ebook

Get Work Done Faster with these 10 Google Sheets Tips

X