How to Upload Your Excel Sheets on Google Sheets

Prefer watching a video tutorial? View ours here:

If you work with Google Sheets, at that place may be times when you lot have to convert Excel to Google Sheets. This allows you lot to collaborate with others and benefit from the powerful features of Google Sheets.

Although there's no method relating to how to save Excel as Google Sheet, At that place are a couple of means to convert Excel to Google Sheets:

1. Catechumen by importing an Excel file to Google Sheets
2. Catechumen while uploading to Google Drive
3. Upload to Google Bulldoze and and then Convert

Let's look at some examples os you tin can learn how to turn Excel into Google Sheets in particular.

Compatible Excel Spreadsheet to Google Sheets File Formats

You can utilise the following Excel files in Google Sheets:

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

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

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

1. Go to Google Drive Homepage and log in using your credentials.
2. In the Google Bulldoze Homepage, click on the New button and select Google Sheets.
3. In the new Google Sheet that opens, become to File and click on Import.
4. In the Import File dialog box, select the Upload tab.
5. Drag the Excel file that you want to convert to the dialog box, or click on 'Select a file from your computer' and then select it manually.
6. One time the file is uploaded, you volition see a dialog box as shown below. You lot tin create a new spreadsheet, insert new sheets in the open up Google Sheet, or replace the open Google Sheet with the imported file.

In my opinion, the conversion is almost flawless. I have converted many Excel files into Google Sheets (that had formulas and provisional formatting), and in near of the cases, I got a perfect conversion.

However, in some cases, you would lose some functionalities when you catechumen an Excel to Google Sheets:

• Macros don't piece of work in Google Sheets.
• Interactive controls would not work.
• There are features in Excel that are not yet available in Google Sheets (such every bit carve up worksheet, linked shapes, and charts)

This method is best suited when you lot have a couple of Excel files that you want to convert to Google Sheets.

Convert Excel to Google Sheets While Uploading to Google Bulldoze

This method is best suited when you have a lot of Excel files that you desire to convert to Google Sheets.

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

1. Go to Google Bulldoze Homepage and log in using your credentials.
2. Click on the gear icon on the meridian right.
3. Click on Settings.
4. In the Setting dialog box, select the selection 'Convert uploaded files to Google Docs editor format'.
5. Click on Washed.

Now, when y'all upload an Excel file to Google Bulldoze, it will automatically be converted into the Google Sheets format.

Upload An Excel File to Google Drive then Catechumen to Google Sheets

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

You tin can cull to convert selected files into the Google Sheets format.

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

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

This will open the file in Google Sheets, however, your file in Google Bulldoze would keep to be in the Excel file format.

Exporting a Google Sheets File every bit an Excel Spreadsheet

After you've been working on an excel spreadsheet in Google Sheets, you may need to download the changes and send them back every bit an Excel file. To do this, just follow these steps:

1. Navigate to File > Download
2. Click on Microsoft Excel (.Xlsx)

Google Sheets Formulas That Don't Piece of work in Microsoft Excel

The following Google Sheets functions are incompatible with Microsoft Excel, so be conscientious non to include them in a file you intend to ship to an Excel user:

• UPLUS
• UNIQUE
• UNARY_PERCENT
• UMINUS
• TO_TEXT
• TO_PERCENT
• TO_DOLLARS
• TO_DATE
• Split
• SPARKLINE
• SORT
• QUERY
• POW
• MULTIPLY
• MINUS
• LTE
• LT
• Bring together
• IMPORTXML
• IMPORTRANGE
• IMPORTHTML
• IMPORTFEED
• IMPORTDATA
• IMAGE
• GTE
• GT
• GOOGLETRANSLATE
• GOOGLETOURNAMENT
• GOOGLEFINANCE
• FILTER
• EQ
• DIVIDE
• DETECTLANGUAGE
• COUNTUNIQUE
• Go along
• CONCAT
• ARRAYFORMULA
• Add together

How to Convert an Excel File to Google Sheets FAQ

How Do I Convert an Excel File to Google Sheets?

The simplest method of how to transfer Excel to Google Sheets is to:

1. Open an empty Google Sheets folio
2. Navigate to File > Import > Upload
3. Drag the Excel file into the pop-upwardly window
4. Click Select to upload Excel to Google Sheets

Tin can You Convert .xlsx to Google Sheets?

Yeah, y'all can learn how to export excel to Google Sheets by using Google Drive in 2 steps:

1. Correct-click the file
2. Navigate to Open with > Google Sheets

Now You lot Know how to Convert Excel to Google Sheets, You May Also Like the Following Google Sheets Tutorials:

• How to Create a Drop Down List in Google Sheets.
• FREE Employee / Educatee Get out Tracker Template in Google Sheets (for 2018).
• How to Speedily 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

Sumit

Spreadsheet Proficient at Productivity Spot | Website | + posts

Google Sheets and Microsoft Excel Expert.

• Sumit

  https://productivityspot.com/writer/sumitbansal23/

• Sumit

  https://productivityspot.com/author/sumitbansal23/

• Sumit

  https://productivityspot.com/author/sumitbansal23/

• Sumit

  https://productivityspot.com/author/sumitbansal23/

Yous May Too Like the Following Tutorials:

stewardbeld1970.blogspot.com

Source: https://productivityspot.com/convert-excel-to-google-sheets/

Share this post