Geek Dashboard

How-To's, Smartphones, News and Reviews

  • Home
  • News
  • Smartphones
    • Android
    • iOS
  • Computers
    • Windows
    • macOS
  • Internet
  • Reviews
You are at Home » Internet

How to Convert Microsoft Excel Spreadsheet (XLS) to Google Sheets

Last Updated on March 27, 2020 by Vivek Singh Negi 1 Comment

Many people are migrating to Google services for creating documents, spreadsheets, and presentation slides. It’s easy to use, easy to understand and doesn’t have a wall of highly advanced features that scares away a new user. And the best part? They are absolutely free to use and available on the cloud for you to access them anywhere you go. No doubt, Google Sheets has proved to be a highly useful alternative to the expensive Microsoft Excel. The more you use Google Sheets the more you need about converting the Microsoft Excel spreadsheets to Google Sheets.

If you have been using Google Sheets as your primary application to create document files then you must have come across the situation where someone sends you a Microsoft Excel file and ask for modifications. Previously to open an Excel file with the .xls or .xlsx extension, you could just drag and drop that file into your Google drive and it would automatically create a Google Sheet copy of the same. Unfortunately, this method no longer works but worry not! there are two other methods to easily convert Excel (XLS) to Google Sheets to edit them flawlessly.

2 Ways to Convert Excel Files to Google Sheets

Converting the Microsoft Excel to Google Sheets is a very simple task and you can do it easily in either of the two ways which we mention below. Use the first method if you need to upload plenty of Excel files but want to convert only a few of them to Google Sheets manually. On the other hand, the second method will instantly create a copy of the uploaded Excel file and converts it to Google Sheet.

2 ways to convert Excel file to Google Sheets

Method 1: Convert Excel file to Google Sheets Manually

1. Open Google Drive and create a new folder for convenience. Now upload the Microsoft Excel file that you wish to convert by clicking the + New button on the top left. However, you can also drag and drop it in Google Drive root folder or into the new folder you created seconds ago.

Drag and drop your Excel file in Google Drive

2. After uploading your file you will notice that it has an ‘X‘ icon in front of the file name. This icon clearly says it is an XLS file (Excel file) which we need to convert to Google Sheet.

'X' icon showing XLS file in Google Drive

3. Right-click on the Excel file, select Open with and choose Google Sheets from the drop-down options.

Right click on Excel file and open with Google Sheets

Alternatively, you can double click on the Excel file to preview it before opening. Then in the top half of the window, you will find the ‘Open with Google Sheets‘ option and clicking on it will open the Excel file using Google Sheets.

Preview Excel file before opening it with Google Sheets

4. In the Google Sheets new tab, you will see the .xlsx badge at the end of the Excel file name. It is an indication that we have opened an Excel file directly using Google Sheets.

Microsoft XLS indication at the end of file name

6. To convert Excel file to Google Sheets, click on the File menu and select Save as Google Sheets option. Now the XLSX file will be converted to Google Sheet and opens in a new tab. You can now modify it and all new changes on it will be saved in the same Google Sheets file.

Click on Save as Google Sheets option

7. Go back to Google Drive and navigate to the folder where you initially uploaded the Excel Sheet. Here you will see another copy of the Excel sheet but with a different icon in front of its name. Instead of the ‘X’ symbol, you will now have the Google Sheets icon confirming that you have successfully converted your Excel file to Google Sheets. You can now delete the older Excel document to get rid of duplicates.

Microsoft Excel spreadsheet is converted to Google Sheets

Also Read: 10 Ways to Fix “There was a problem sending the command to the program” error in Microsoft Excel

Method 2: Convert Excel file to Google Sheets Automatically

In the above method, we have to manually convert each and every Excel file to Google Sheets and moreover, we again need to delete the duplicate files. This is time-consuming if you have tens of Excel files and not productive work. Don’t worry, we can automate the process when you upload Excel file to Google Sheets website instead of Google Drive. Here is how you can automatically convert Excel files to Google Sheets:

1. Open Google Sheets website and login to your Google account.

2. Click on the folder icon to open File Picker dialog and move to Upload tab.

Click on File icon to open file upload dialog

3. Drag and drop your XLS or Excel file from your desktop into the Google Sheets upload dialog. You can also click on the “Select a file from your device” button to navigate and select your document from the computer.

Drag and drop Excel files to Google Sheets

4. After the upload finishes your file will be automatically converted into a Google Sheets file. You can now double click on it to modify the file.

Excel file automatically converted to Google Sheet

Also Read: 21 Best KPI Dashboard Excel Templates for All Your Needs

Choosing the best way to convert Excel file to Google Sheets

The older method was quicker and you could easily convert Excel to Google Sheet and get a copy of it in the same folder in your Google Drive. But it might get annoying for those people who did not want to create a copy as soon as they upload their document. This can be especially frustrating if you upload a large number of documents at the same time. That may have been the reason why Google removed the older method.

With the new method, you can directly upload a large number of Excel documents in Google Sheets to automatically convert them or upload them in Google Drive to manually convert individual Excel files to Google Sheets.

So to conclude, upload your files on Google Drive to manually convert Microsoft Excel files to Google Sheets. For automatic bulk conversion, upload them directly in Google Sheets website at sheets.google.com

#Google Drive#Google Sheets#Google+#Microsoft#Microsoft Excel
Posted inInternet

Spread the Word!

Avatar for Vivek Singh Negi

Vivek Singh Negi Twitter LinkedIn

A very tiny indie game developer. He also loves to play games, read fiction, watch shows and anime. He is a tech enthusiast currently pursuing Engineering who likes to write.

Related articles

News

Ad Blockers Will Stop Working In Chrome Unless You Are An Enterprise User

Google Chrome
News

Microsoft to Announce Office 2021 Along With Windows 11 on October 5

Microsoft Office
News

Google Decide to Wind Down Free Public Wi-Fi Program After Covering 400+ Railway Stations

Gstation

Comments

  1. Avatar for Derek DangDerek Dang says

    February 5, 2021 at 6:54 PM

    If you go back to your Google Drive, you’ll see that there are now two copies of the file: the original file and the new version in Google Docs format

    Reply

Comment Policy:

The comments section is aimed to help our readers in case of any questions or you can even appreciate us for our hard work. Every comment is strictly moderated before approving it.

Your name and comment will be visible to the public. Never share your personal information in the comments section.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Over 1,30,286+ Followers

Join to get latest updates from Geek Dashboard

Facebook Twitter Telegram Pinterest YouTube Instagram

Recently Published

  1. Samsung Galaxy F13 Launched with Triple Rear Cameras and 6000mAh Battery in India

  2. Infinix InBook X1 Slim with 14-inch IPS Display and 10th Intel Core Processors Launched in India

  3. HP Spectre x360 Series Laptops Launched with 12th Gen Intel Processors in India

  4. Realme V20 5G Launched with MediaTek Dimensity 700 Chipset and a 5000mAh Battery

  5. New Dell XPS 13 and XPS 13 2-in-1 Launched with a Complete Redesign Starting at $999

Geek Dashboard Placeholder

Download the apps and never miss a story from us

We put a lot effort and resources in writing our articles and we believe it is our responsibility to satisfy your tech hunger. We will keep you filled forever!

  • Get Geek Dashboard App from Google Play
  • Get Geek Dashboard App from Chrome Web Store
Advertisement
Geek Dashboard Logo

Geek Dashboard, a technology blog strives to produce high-quality tech for our readers. Here you will find the latest updates on trending tech news, unbiased product reviews, and how-to guides on various gadgets.

Got a Tip? Write In tip@geekdashboard.com

© 2012 - 2022 · Geek Dashboard, product of ikva eSolutions

Blog Advertise About Jobs Contact Privacy Policy Write For Us T&C Office Setup

No dogs were injured while working on this website because we love them