How to Convert Your Excel Spreadsheets to Google Sheets

Posted June 4, 2019 by Sheraz Ali in Microsoft Excel

microsoft excel

Most people prefer working on the smooth interface of Google Sheets. It’s interactive and easily shareable with other users. Because of this users often feel the need to import their Excel files to Google Sheets and work on them there. In this tutorial, we will teach you how to convert your Excel spreadsheets to Google Sheets so that you can follow in their footsteps.

There are many methods you can go on about doing this. However, in this tutorial, we will focus on the quickest and easiest one.

Step-By-Step: How to Convert Your Excel Spreadsheets to Google Sheets

1.  Make sure the Excel File you want to convert is stored in your computer.

2. Proceed to Google Sheets main homepage.

3. Click the file picker icon (folder-shaped button), located underneath your listed Google Spreadsheets.How to convert Your Excel Spreadsheets to Google Sheets tutorial

4. Tap Upload (upper-right corner) in the next window.How to convert Your Excel Spreadsheets to Google Sheets tutorial 1

5. Select or drag the Excel File you want to convert to a Google Spreadsheet from your computer and wait for it to upload.How to convert Your Excel Spreadsheets to Google Sheets tutorial 2

6. Done! Here’s the final result.How to convert Your Excel Spreadsheets to Google Sheets tutorial 3

Automatically Converting Your Uploaded Excel Files to Google Sheets

You can also regulate the behavior of Google drive to fit your purpose. There’s an in-built option to convert all incoming documents to the spreadsheet format.

Here’s how you can activate it.

1. Go to Google drive’s home page.

2. Locate the Gear icon and select Settings from the drop-down menu.How to convert Your Excel Spreadsheets to Google Sheets tutorial 5

3. Check the “Convert imported files to Google Docs Editor Format” option.How to convert Your Excel Spreadsheets to Google Sheets tutorial 6

Is Google Sheets a good Alternative of Microsoft Excel?

With time, “Google sheets” has evolved into a full-fledged alternative to Microsoft Excel.

Many of Excel’s features, including the ability to add a drop-down list, write custom functions, have been integrated to Google’s answer to Microsoft Excel. Future updates promise a lot more to catch up and completely replicate Microsoft’s popular accounting software.

So yes, In my opinion, Google sheets is as good as Microsoft Excel, and may even surpass it in the future.

Where Does Google Sheets lag behind?

Despite Google Sheets many useful components, Microsoft Excel remains the superior product, for now. Especially the charting capacities in Google Sheets are limiting. Excel gives you more freedom when it comes to advanced chart labeling and adding chart trendlines.

Hopefully, in future updates, Google sheets will address these shortcomings.

 

About Sheraz Ali

An established copywriter, with a longstanding experience in a vast array of industries, including but not limited to spirituality, technology, cannabis and travel.
View more articles by Sheraz Ali

The Conversation

Follow the reactions below and share your own thoughts.

Leave a Reply