How to convert Excel files to Google Sheets

For those who use Google Sheets, then you definitely’ll know that it’s a versatile software that may decide up and run with any present spreadsheets from purposes like Microsoft Excel. You possibly can even convert present Excel spreadsheets to Google Sheet paperwork. Whether or not you are seeking to using Microsoft Excel or need the improved ease of collaboration and sharing that Sheets provides for that specific spreadsheet, here is methods to convert Excel recordsdata to Google Sheets in only a few steps.

Changing Excel recordsdata by way of Google Sheets’ Import function

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

Step 2: Choose the File menu and select Import.

Step 3: Choose the Add tab.

Step 4: Drag an Excel file into the window or hit the Choose a file out of your machine button and find your file.

Step 5: As soon as the Excel file is chosen, select an import location by way of the drop-down menu in Sheets.

Step 6: Choose the Import knowledge button. For demonstration functions, we’ve used the Create new spreadsheet choice, which is able to show a “file imported efficiently” message alongside an Open now hyperlink.

After you’ve chosen that Open now hyperlink, the Excel spreadsheet and its contents will load onto a Google Sheets file and also will be saved onto your Sheets homepage, in addition to Google Drive.

Changing Excel recordsdata by way of Google Drive

One other approach to convert Excel recordsdata to Google Sheets is by way of Google Drive.

Step 1: Open Google Drive. Choose the New button after which File add.

Step 2: Choose the Excel file out of your laptop.

Step 3: In your Drive homepage, choose the file by right-clicking on it. Select the Open with subject after which Google Sheets.

Step 4: Choose File > Save as Google Sheets.

The Excel file will now be saved as a Google Sheet spreadsheet and may be accessed by way of each Google Drive and Google Sheets’ homepages.

For extra on methods to use Google Sheets, take a look at our guides on how to search in Google Sheets and methods to highlight duplicates.