How To Upload Excel File To Google Sheets

Prefer watching a video tutorial? View ours hither:

If you work with Google Sheets, in that location may be times when yous have to convert Excel to Google Sheets. This allows you to interact with others and benefit from the powerful features of Google Sheets.

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

Convert by importing an Excel file to Google Sheets
Convert while uploading to Google Drive
Upload to Google Drive and then Convert

Allow's go through these methods in item.

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

Hither are the steps to catechumen Excel to Google Sheets by importing the Excel file:

Go to Google Drive Homepage and log in using your credentials.
In the Google Drive Homepage, click on the New button and select Google Sheets.
In the new Google Sheet that opens, go to File and click on Import.
In the Import File dialog box, select the Upload tab.
Drag the Excel file that yous want to convert to the dialog box, or click on 'Select a file from your computer' and then select it manually.
Once the file is uploaded, you will see a dialog box every bit shown beneath. Yous tin create a new spreadsheet, insert new sheets in the open up Google Canvas, or replace the open Google Canvass with the imported file.

In my stance, the conversion is about 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.

All the same, 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 piece of work.
At that place are features in Excel that are not yet bachelor in Google Sheets (such as split worksheet, linked shapes, and charts)

This method is all-time 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 lot desire to convert to Google Sheets.

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

Go to Google Bulldoze Homepage and log in using your credentials.
Click on the gear icon on the top right.
Click on Settings.
In the Setting dialog box, select the option 'Convert uploaded files to Google Docs editor format'.
Click on Done.

Now, when yous 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 so Convert to Google Sheets

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

Y'all can choose to convert selected files into the Google Sheets format.

Hither are the steps to Convert an Excel file in Google Bulldoze into Google Sheets:

Right-click on the file that you want to open in Google Sheets.
Go to Open up with and click on Google Sheets.

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

You May Also Like the Following Google Sheets Tutorials:

How to Create a Drib Downwards List in Google Sheets.
Gratuitous Employee / Student Leave Tracker Template in Google Sheets (for 2018).
How to Rapidly Freeze Rows in Google Sheets.
How to zoom-in and zoom-out in Google Sheets.
How To Recover Deleted Google Sheets Files
How to Open CSV File in Google Sheets?
How to Convert PDF to Google Sheets