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”.
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.
- Firstly, open your Google Sheets and open a blank sheet just like the below image.
- In this step, go to the File tab >> choose Import.
- At this moment, an Import file dialog wizard pops out. Choose Upload and pick Select a file from your device.
- 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.
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.
- Initially, open your drive and select the New option and then pick File upload.
- Consequently, a file folder appears for choosing your desired file. Press Open then.
Finally, your Excel file has been opened in Google Sheets.
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.
- Firstly, open a blank sheet in Google Sheets and go to File tab >> pick up Open.
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.
- 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.
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:
- First, go to the Google drive webpage and click on the Settings icon,
- Then, click on the Settings option.
- 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.
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).
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.