Skip to main content
  1. Home
  2. Computing
  3. Guides

How to convert Excel files to Google Sheets

By
A MacBook on a table using Google Sheets.
Image used with permission by copyright holder

If you use Google Sheets, then you'll know that it is a versatile tool that can pick up and run with any existing spreadsheets from applications like Microsoft Excel. You can even convert existing Excel spreadsheets to Google Sheet documents. Whether you're looking to using Microsoft Excel or want the improved ease of collaboration and sharing that Sheets offers for that particular spreadsheet, here's how to convert Excel files to Google Sheets in just a few steps.

Recommended Videos

Difficulty

Easy

Duration

5 minutes

What You Need

  • Computer, laptop, tablet, or phone with access to Google Sheets

Converting Excel files via Google Sheets’ Import feature

Step 1: Open Google Sheets and create a new spreadsheet file.

Step 2: Select the File menu and choose Import.

The Import button on Google Sheets.
Image used with permission by copyright holder
Related

Step 3: Select the Upload tab.

The Upload button within the Import feature on Google Sheets.
Image used with permission by copyright holder

Step 4: Drag an Excel file into the window or hit the Select a file from your device button and locate your file.

Step 5: Once the Excel file is selected, choose an import location via the drop-down menu in Sheets.

Choosing an import location for an Excel file on Google Sheets.
Image used with permission by copyright holder

Step 6: Select the Import data button. For demonstration purposes, we’ve used the Create new spreadsheet option, which will display a "file imported successfully" message alongside an Open now hyperlink.

After you’ve selected that Open now link, the Excel spreadsheet and its contents will load onto a Google Sheets file and will also be saved onto your Sheets homepage, as well as Google Drive.

The Import Data button on Google Sheets.
Image used with permission by copyright holder

Converting Excel files via Google Drive

Another way to convert Excel files to Google Sheets is via Google Drive.

Step 1: Open Google Drive. Select the New button and then File upload.

The File upload button on Google Drive.
Digital Trends

Step 2: Select the Excel file from your computer.

Step 3: On your Drive homepage, select the file by right-clicking on it. Choose the Open with field and then Google Sheets.

The Open with button on Google Drive.
Image used with permission by copyright holder

Step 4: Select File > Save as Google Sheets.

The Excel file will now be saved as a Google Sheet spreadsheet and can be accessed via both Google Drive and Google Sheets’ homepages.

The Save with Google Sheets option on Google Sheets for an Excel file.
Image used with permission by copyright holder

For more on how to use Google Sheets, check out our guides on how to search in Google Sheets and how to highlight duplicates.

Editors’ Recommendations

Topics
Zak Islam
Zak Islam
Former Digital Trends Contributor
Zak Islam was a freelance writer at Digital Trends covering the latest news in the technology world, particularly the…
How to find duplicates in Excel

When you're working with a spreadsheet, duplicate data can sometimes make its way in and cause all sorts of problems. In this how-to, we demonstrate two methods of using Microsoft Excel for identifying and removing duplicate data.

Read more
How to use concatenate in Excel
A man using a PC to view an Excel spreadsheet.

The concatenate function may not be as well known as other common Excel features such as IF and VLOOKUP, but it’s still effective, even though it performs a more simple function in nature. If you are using Microsoft Excel, you can use concatenate to merge the data you have inserted into columns into a single cell or column. For example, you could combine columns detailing revenue and profit for a given month into one cell.

Read more
How to add a column in Excel

Microsoft Excel is a powerful database management tool with all sorts of in-depth problem-solving functions and dynamic formatting. To make the most of it, though, you need to know the basics. Using Microsoft Excel to add a column is quick and easy. You can do it in just a few quick steps once you've learned how.

Read more