Buy Now
Convert-Excel-to-Google-Sheets

Can You Convert Excel to Google Sheets: Everything You Need to Know

May 26, 2022

If you find yourself working in Google Sheets quite frequently, you will notice there comes a time when you need to convert Excel to Google Sheets. This conversion will let you collaborate with colleagues and gain some of the many benefits and features available on Google Sheets.

Unfortunately, there is no clear method of saving an Excel file as a Google Sheets document, but there are a few ways to convert Excel to Google Sheets.

This article will look at the three main ways to convert Excel to Google Sheets so that you never get stuck when it becomes time to collaborate online.

Compatible Excel Spreadsheet to Google Sheets File Formats

Only certain file formats are compatible in Google Sheets:


.xls /.xlsx / .xlsm / .xlt / .ods / .csv / .tsv / .tab


How to Convert Excel To Google Sheets: Importing an Excel File to Google Sheets

Here's how you can convert Excel to Google Sheets via importing an Excel file:

  • Head to the Google Drive Homepage, and log into your Google account.

  • From there, select the New button, and choose Google Sheets.

  • Within your new Google Sheets spreadsheet, head to File and select Import.

  • Within the Import File section, choose the Upload tab.

  • Drag your chosen Excel file into the dialog box or tap on "Select a File From Your Computer."

  • After your file has successfully been uploaded, you will notice a dialog box appears. From here, you can build a new Google Sheets spreadsheet, add new sheets to your open Google Sheet, or replace your open Google Sheet spreadsheet with your imported file.

Convert Excel to Google Sheets Alongside Uploading to Google Drive

This option is a great choice if you are trying to convert multiple Excel files to Google Sheets documents.

Here's how you can convert Excel to Google Sheets alongside uploading to Google Drive:

  • Head to the Google Drive Homepage, and log into your Google account.

  • Select the gear icon from the top right corner of your screen.

  • Choose settings.

  • From the Settings dialog box, choose "Convert Uploaded Files to Google Docs Editor Format."

  • Select Done.

After this, once you upload an Excel file to your Google Drive, it will immediately be converted to Google Sheets format.

How to Upload An Excel File to Google Drive Before Converting it to Google Sheets

If you've already got a few Excel files within Google Drive or are not a fan of Google Drive automatically converting your Excel files to Google Sheets format, you might want to try this method.

Here's how you can convert Excel to Google Sheets in Google Drive.

  • Right-click on your chosen file you would like to open in Google Sheets.

  • Click on Open with and select Google Sheets.

This action will cause your file to open in Google Sheets, but your file will remain in Excel file format in Google Drive.

How to export a Google Sheets File as an Excel Spreadsheet

Once you have worked on an Excel file within Google Sheets, you might be required to download the amends and save them as an Excel spreadsheet. To do this is extremely simple and straightforward.

Head to the File tab, press Download, and select Microsoft Excel.

Certain Google Sheets Formulas Don't Work in Microsoft Excel.

It is worth noting that the following Google Sheets functions are not possible within Microsoft Excel, so be cautious. You don't include these formulas in your spreadsheet if you want an Excel user to open it.

Here are the formulas to avoid:


UPLUS / UNIQUE / UNARY_PERCENT / UMINUS / TO_TEXT / TO_PERCENT / TO_DOLLARS / TO_DATE / SPLIT / SPARKLINE / SORT / QUERY / POW / MULTIPLY / MINUS / LTE / LT / JOIN / IMPORTXML / IMPORTRANGE / IMPORTHTML / IMPORTFEED / IMPORTDATA / IMAGE / GTE / GT / GOOGLETRANSLATE / GOOGLETOURNAMENT / GOOGLEFINANCE / FILTER / EQ / DIVIDE / DETECTLANGUAGE / COUNTUNIQUE / CONTINUE / CONCAT / ARRAYFORMULA / ADD


Frequently Asked Questions

Can you convert XLSX to Google Sheets?

Yes, you can! Select the More button from the top of your Google Drive homepage, and choose Export to Google Docs or Export to Google Sheets from the drop-down menu. From there, your XLS file will get converted.

Is it easy to convert Excel to Google Sheets?

Once you know how to convert Excel to Google Sheets, it is very simple! You can upload Excel files straight to Google Sheets. Open a blank Google Sheet, head to File, then Open. Select the file upload tab and drag your Excel file into the space before pressing Open.

How do I automatically import Excel to Google Sheets?

  • Open up your Google Sheets file.

  • Head to File, then Import data.

  • Pick your Excel file and hit Select.

  • Pick whether you want to create a new spreadsheet, insert a new sheet, or replace a spreadsheet.

  • Select import data.

Related Articles

How to Search in Google Sheets: 3 Quick and Easy Options

Google Sheets Dark Mode: Everything You Need to Know

Pivot Table Google Sheets Walkthrough

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras sed sapien quam. Sed dapibus est id enim facilisis, at posuere turpis adipiscing. Quisque sit amet dui dui.

Call To Action

Stay connected with news and updates!

Join our mailing list to receive the latest news and updates from our team.
Don't worry, your information will not be shared.

We hate SPAM. We will never sell your information, for any reason.