How to Convert Excel to Google Sheets (Quick and Easy)

How to Convert Excel to Google Sheets

In this video tutorial, we’re gonna go through how to convert Excel to Google Sheets in a quick and easy way.

Ready to start?

Would you rather watch this tutorial? Click the play button below!

To convert an Excel file to a Google Sheets document, open your Google Drive first.

How to Convert Excel to Google Sheets - Open Google Drive

Then find the button ‘New’ in the upper left corner and choose ‘Google Sheets’.

How to Convert Excel to Google Sheets - Open google sheet

A new Google Sheets document opens, so go to ‘File’, select ‘Import’ and you’ll see a window with several options to import a file.

How to Convert Excel to Google Sheets - New Google Sheet Document - Import

The Excel file can be imported directly from your Drive, shared documents, recent documents or you can simply upload it from your computer.

How to Convert Excel to Google Sheets - Import options

We’ll go for the option ‘Upload’, where we can directly drag and drop the file we want to import or browse the computer using this blue button.

How to Convert Excel to Google Sheets - upload

So, we’ll click on the blue button now, select the file from the computer and click on ‘Open’.

How to Convert Excel to Google Sheets - select the file

Google Sheets now offers three options for the file import.

Since we opened a new, empty Google Sheets document just a while ago, we can simply go for ‘Replace spreadsheet’ – this option is the most convenient in this case.

How to Convert Excel to Google Sheets - three options

Now click on ‘Import data’ and that’s it!

How to Convert Excel to Google Sheets - import data

The data now shows in the Google Sheets document and as you can see, the feature ‘Filter’ is still there, so it’s been transferred from the Excel file automatically.

How to Convert Excel to Google Sheets - converted to google sheets
How to Convert Excel to Google Sheets - the feature filter

It’s important to remember the following couple of things though.

Excel File vs. Google Sheets Document

Some features and settings can change with the conversion. Excel is more advanced than Google Sheets in terms of formatting spreadsheets, so it offers more options which might not work in the latter.

Also, bear in mind that macros don’t work in tables imported from Excel to Google Sheets, and some functions supported by Excel but not yet supported by Google Sheets might get lost in the conversion.

Nevertheless, the data will always appear as in the original Excel file, so you can definitely rely on that!

Don’t miss out a great opportunity to learn:

If you found this tutorial helpful, give us a like and watch other tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers!

Thanks for watching and I’ll see you in the next tutorial!

Comments

Add comment

Your email address will not be published.

Your personal information will only be used for the purpose of processing this comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.