Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Convert Excel Sheet to Google Sheets (3 Easy Ways)

You have come to the right place if you are looking for the answer or some unique tips to convert an Excel sheet to google sheets. There are 3 ways to convert an Excel sheet to google sheets. This article will walk you through each and every step with appropriate examples. As a result, you can use them easily for your purpose. Let’s move on to the article’s main discussion.


3 Methods to Convert an Excel Sheet to Google Sheets

In this section, I will show you 3 quick and easy methods to convert excel sheet to google sheets on the Windows operating system. This article contains detailed explanations with clear illustrations for everything. I have used the Microsoft 365 version here. However, you may use any other version depending on your availability. Please leave a comment if any part of this article does not work in your version.

1. By Importing an Excel File into Google Sheets

It is very easy to convert an Excel file to Google Sheets. You can simply import an Excel file in Google sheets to convert that. For this, follow the steps below:

📌 Steps:

  • First, go to the following link to open Google Sheets webpage:
  • Then, click on the Blank page option to open a blank sheet.

opening blank worksheet to Convert Excel Sheet to Google Sheets

  • Now, click on the File tab on the left-top corner of the blank sheet.
  • Here, you will a list of options. Then click on the Open or Import option to open an Excel file from the local storage.

Importing Excel file to Convert Excel Sheet to Google Sheets

  • Now, there will open a window named Import File.
  • Here, go to the Upload option.
  • Now, drag the Excel file from the local folder to the box in the window or click on “Select a file from your device” to select the Excel file by going to the folder.

Uploading Excel Sheet to Convert to Google Sheets

  • After selecting or opening the Excel file from the local storage, there will appear a new window.
  • Here, click on the Import Data

Clicking Import data button

  • Thus, you can easily open and convert an Excel file to Google Sheets.

Things Lost While Converting Excel Files to Google Sheets:

Some things in the Excel file will not work after converting to Google Sheets are:

  • Macros and VBA Codes
  • Interactive Controls
  • Charts, Split Worksheets, Linked Shapes.

Excel File Formats That Are Compatible with Google Sheets

The supported formats of Excel files are as follows:

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

Read More: How to Import Data from Excel to Google Sheets (2 Easy Ways)


2. Upload Excel File to Google Drive and then Open

Alternatively, you can upload the Excel file to Google Drive and open it to convert it to Google Sheets. For this, follow the steps below:

📌 Steps:

  • First, go to your Google Drive using the following link and log in to your Google Account:

drive.google.com

  • Then, click on the New button on the left top corner of the Webpage.
  • Here, click on the File upload option.

uploading file in Google Drive

  • Then, go to the file location and select it to open.
  • Thus, you have opened an Excel file in Google Sheets but still, this file has an extension as .xlsx.

Converted Excel file to Google Sheets

Read More: How to Open Password Protected Excel File in Google Sheets


3. Upload Excel File and Save as Google Sheets

Now, If you want to upload an Excel file in Google Sheets and save it as Google Sheets then follow the below steps:

📌 Steps:

  • First, open an Excel in Google Sheets.
  • Then, go to the File tab.
  • Select the Save as Google Sheets option.

Saving Excel file as Google Sheets

  • Thus, you can easily open and save an Excel file as Google Sheets.

Read More: How to Sync Excel to Google Sheets (with Simple Steps)


How Can We Save an Excel File as a Google Sheet Automatically in Google Drive

You can automate the conversion of Excel files to Google Sheets while uploading the Excel file to Google Drive. Follow the steps below:

  • First, go to the Google drive webpage and click on the Settings icon,
  • Then, click on the Settings option.

Clicking Settings Icon in Google Drive

  • In the Settings window, go to the General tab.
  • Here, mark the box saying ”Convert uploaded files Google Docs editor format”.
  • Then, press the Done button.

How Excel File Will Save as a Google Sheet Automatically in Google Drive

  • Now, after uploading an Excel file in Google Drive, it will automatically updated as Google Sheets.

Issues You May Face While Converting Large Excel Files to Google Sheets

While converting an Excel file to Google Sheets, you may face a problem that it is saying “This worksheet is too large to import” in Google Sheets.

Reasons:

There are some limits to Google Sheets while importing data from an Excel file

  • You can import a maximum of 10 million cells or 18,278 columns from an Excel od CSV file.
  • If any cell in the Excel file contains more than 50,000 characters, will be removed.

Solution:

  • Split the Excel file and import them individually.
  • If the dataset is very smaller than the limit but still says it is too large then check whether there are any unnecessary cells at the end of the worksheet or not. If there is, then remove those cell values.

Read More: Pros and Cons of Google Sheets vs Excel – Which Will Be Better?


Conclusion

In this article, you have found how to convert an Excel sheet to google sheets. I hope you found this article helpful. You can visit our website, ExcelDemy, to get more Excel-related content. Please leave comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Osman Goni Ridwan

Osman Goni Ridwan

I am Ridwan, graduated from Naval Architecture and Marine Engineering Dept, BUET, currently residing in Dhaka, Bangladesh. And my passion is to grow up my skillsets with industry demands. My prime goal is to be a data analyst as I do love to solve problems and play with data.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo