How to Convert Excel Files to Google Sheets: A Step-by-Step Guide

If you are utilizing Google Sheets, you are likely aware of its capability to easily handle spreadsheets from applications like Microsoft Excel. It’s also possible to convert existing Excel files into Google Sheets format. Whether you’re transitioning from Excel for better collaboration features or simply wish to utilize Google Sheets, follow these simple steps to change Excel files into Google Sheets.

Converting Excel files via Google Sheets’ Import feature

Step 1: Launch Google Sheets and create a new spreadsheet.

Step 2: Click on the File menu and select Import.

Image used with permission by copyright holder

Step 3: Go to the Upload tab.

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

Step 4: Either drag your Excel file into the designated area or click Select a file from your device to find your file.

Step 5: After the Excel document is chosen, use the drop-down menu in Sheets to select an import location.

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

Step 6: Click on Import data. For this example, we have chosen the Create new spreadsheet option, which will confirm with a “file imported successfully” message, along with an Open now link.

After clicking the Open now link, the content from your Excel sheet will be visible in a Google Sheets file and saved in your Sheets homepage and Google Drive.

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

Converting Excel files via Google Drive

Another method for converting Excel files to Google Sheets involves using Google Drive.

Step 1: Access Google Drive. Click the New button followed by File upload.

The File upload button on Google Drive. — Digital Trends

Step 2: Choose the Excel file from your device.

Step 3: On the Google Drive homepage, right-click the file, select Open with, and then click on Google Sheets.

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

Step 4: Navigate to File > Save as Google Sheets.

Your Excel document is now saved as a Google Sheets spreadsheet and can be accessed from 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 additional guidance on using Google Sheets, explore our tutorials on searching within Google Sheets and identifying duplicate entries.