Geek Dashboard Home
  • News
  • Smartphones
    • Android
    • iOS
  • Computers
    • Windows
    • macOS
  • Internet
  • Reviews
  • Tools
    • Password Generator
    • iFrame Tester
Search Geek Dashboard
Home • Internet

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

Vivek Singh Negi • Updated March 27, 2020 • 5 min read •

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

Internet Google Drive Google Sheets Google+ Microsoft Microsoft Excel

Be the Change!

Spread the word and help us create better tech content

Facebook Twitter Reddit WhatsApp Pinterest
Avatar for Vivek Singh Negi

Vivek Singh Negi

•
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.

Read all 38 articles from Vivek

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

Over 1,30,286+ Followers

Join now to get all latest updates from Geek Dashboard

Facebook Twitter Telegram Pinterest YouTube Instagram

Recently Published

  1. TAGRY X08 True Wireless Earbuds Review: Budget-Friendly Excellence with Long Battery Life
  2. Why Are Tech Lawsuits Becoming the New Normal in the US
  3. My Experience of Using TuneFab Amazon Video Downloader
  4. Wondershare Dr. Fone 13 Review - The Ultimate Mobile Toolkit for iOS and Android
  5. TOZO OpenEgo Review - Is It a Reliable and Practical Headphone?
  6. Samsung Lost its Crown as the Top Foldable Smartphone Seller Worldwide

Download the Apps Now

We put a lot of effort and resources in writing our articles, and we believe it is our responsibility to satisfy your tech hunger

Download Geek Dashboard Android App on Google PlayAndroid App onGoogle Play Download Geek Dashboard Extension on Chrome Web StoreBrowser Extension onChrome Web Store
Geek Dashboard Logo

Geek Dashboard brings you the latest and greatest in technology news, reviews, and how-to guides. From smartphones to laptops, drones to VR and everything in between, we've got you covered

Got a Tip? Write In? tip@geekdashboard.com

© 2012 - 2025 · 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