How to Save Excel Files to Google Sheets (3 Quick Methods)

Get FREE Advanced Excel Exercises with Solutions!

Sometimes, we need to save our Excel files to Google Sheets. As you know, online editing is handy with Google Sheets. But when dealing with a large amount of data and comprehensive analysis, you may find difficulties working with Google Sheets. So, you may work in Excel and save it to Google Sheets. It gives your work speed and saves your valuable time. What do you think? Tough chores, right? But sorry to say, you are wrong. It is an extremely easy task to do. In this article, we are going to show you 3 effective methods to save Excel to Google Sheets. So, let’s get started.


Download Practice Workbook

Download the following practice workbook. It will help you to realize the topic more clearly.


3 Quick Methods to Save Excel Files to Google Sheets

First, you need to create a dataset in Excel. We have taken a dataset of “Sales of January” for the corresponding “Sales Rep”.

Dataset

To save this dataset, you may follow these three simple methods. We have tried to cover all three methods. You can use any preferable method from there.

Not to mention, we have used the Microsoft 365 version. You can use any other version at your convenience.


1. Importing Excel Files into Google Sheets

You can import your Excel files into Google Sheets and save them automatically. Follow the below steps to do that.

📌 Steps:

  • Firstly, open your Google Sheets and open a blank sheet just like the below image.

Importing Excel Files into Google Sheets to save excel to google sheets

  • In this step, go to the File tab >> choose Import.

import file to save excel to google sheets

  • At this moment, an Import file dialog wizard pops out. Choose Upload and pick Select a file from your device.

Import file

  • Apparently, it takes you to the folder group of your pc. Choose the desired file that you want to save in Google Sheets. Then, click on Open.

  • Now, the Import file dialog box appears again. Select Import data.

Eventually, your worksheet in Excel is saved to Google Sheets.

Saved Excel to Google Sheets

Read More: How to Import Data from Excel to Google Sheets (2 Easy Ways)


2. Uploading Excel Files in Google Drive

Google Drive is a widely used software where we can store our data. So, you can upload your Excel files to Google Drive and then open them. We have demonstrated the simple steps to you for your better understanding.

📌 Steps:

  • Initially, open your drive and select the New option and then pick File upload.

Uploading Excel Files in Google Drive to save excel to google sheets

  • Consequently, a file folder appears for choosing your desired file. Press Open then.

Browse file option to save excel to google sheets

Finally, your Excel file has been opened in Google Sheets.

Read More: How to Copy from Excel to Google Sheets (4 Easy Methods)


3. Opening Excel Files to Google Sheets

You can use the Open command in Google Sheets to open and save the Excel files. It is an easy and time-saving task. Follow the below steps to do it.

📌 Steps:

  • Firstly, open a blank sheet in Google Sheets and go to File tab >> pick up Open.

Opening Excel Files to Google Sheets and save

Note: You can also do the task by pressing CTRL + O.

  • Subsequently, an Open a file window appears. Go to Upload and hit the Browse area.

Upload Window

  • At this time, choose your relative file to store it in the sheets and click on Open.

Finally, you have added your Excel file to Google Sheets. See the below image for proper clarification.

Read More: How to Open Password Protected Excel File in Google Sheets


How to Convert Excel Files to Google Sheets Files Automatically

You can automate the conversion of Excel files to Google Sheets while uploading the Excel file files to Google Drive. Follow the steps below:

📌 Steps:

  • First, go to the Google drive webpage and click on the Settings icon,
  • Then, click on the Settings option.

How to Convert Excel to Google Sheets Automatically

  • In the Settings window, go to the General tab.
  • Here, mark the box saying, “Convert uploaded files Google Docs editor format” and press Done.

Finally, after uploading an Excel file to Google Drive, it will automatically be updated as Google Sheets.

Read More: How to Convert Excel Sheet to Google Sheets (3 Easy Ways)


How to Sync Excel Files to Google Sheets

You can also sync Excel to Google Sheets. It means whenever you enter or change single or multiple datasets in Google Sheets, they will be changed automatically in your Excel file. See the image here. We have changed the value of the C5 cell by $3000 and it has also been changed in the Excel file by $3000 (next image).

How to Sync Excel to Google Sheets


Conclusion

That’s all about today’s session. And these are some easy methods to save Excel to Google Sheets. Please let us know in the comments section if you have any questions or suggestions. For a better understanding, please download the practice sheet. Visit our website, Exceldemy, a one-stop Excel solution provider, to find out about diverse kinds of Excel methods. Thanks for your patience in reading this article.


Related Articles

Fahim Shahriyar Dipto
Fahim Shahriyar Dipto

Hello! Welcome to my Excel blog! I am a big fan of MS Excel. I am learning new and exciting things in Excel and writing the process here. I think this will be helpful for you to get used to Excel. Keep visiting our website for new and updated Excel methods.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo