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:
- First, go to the following link to open Google Sheets webpage:
- Then, click on the Blank page option to open a blank sheet.
- 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.
- 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.
- After selecting or opening the Excel file from the local storage, there will appear a new window.
- Here, click on the Import Data
- 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
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:
- First, go to your Google Drive using the following link and log in to your Google Account:
- Then, click on the New button on the left top corner of the Webpage.
- Here, click on the File upload option.
- 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.
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:
- First, open an Excel in Google Sheets.
- Then, go to the File tab.
- Select the Save as Google Sheets option.
- Thus, you can easily open and save an Excel file as Google Sheets.
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.
- 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.
- 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.
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.
- 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.
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.