How to Sync Excel to Google Sheets (with Simple Steps)

Get FREE Advanced Excel Exercises with Solutions!

When you work with a dataset that can be edited online, you have to work in Google Sheets. On the other hand, as Microsoft Excel is a widely used software, you may want to do your necessary work through it too. These two scenarios are almost opposite in nature. But in the case of achieving most of the benefits from these two, you can simply synchronize Excel with Google Sheets. By doing these, you can enhance your work record and be pretty handy. In this article, we’re going to show you the simple steps to sync Excel to Google Sheets. So, let’s get started.

While working with a large dataset, it may seem difficult to do it in Google Sheets. Also, there are some difficulties in working with Google Sheets. So, we have discussed four easy steps to sync Excel to Google Sheets. To get a proper visualization, we have also attached pictures.


Step 1: Creating a Dataset in Google Sheet to Sync Excel to Google Sheets

  • Firstly, enter your necessary dataset in Google Sheets. See the below image.

Dataset in google sheets


Step 2. Exporting Data from Google Sheet

  • Then you need to export the data from the sheet. Go to File >> click on Share >> pick Publish to Web.

Export Data from Google Sheet to sync excel to google sheets

  • Consequently, press the Link and then click on the Web Page dropdown.

Web page link to sync excel to google sheets

Comma-separated value to sync excel to google sheets

  • Finally, select Publish.

  • After publishing the Google Sheets online, a link appears in front of you. Copied the link to your clipboard as you need to paste it later.

Read More: How to Link Excel to Google Sheets


Step 3. Importing Data to Excel to Sync Excel to Google Sheets

  • Sequentially, select the cell where you want to put the file. Then go to the Data tab >> move to From Web.

Import Data to Excel

  • A dialog box of From Web appears. Paste the web link that you published earlier. Then, press OK.

From Web window

  • Apparently, a dialog box pops out. Press Connect there.

  • Consequently, you load your dataset like the image below. Select Load from there.

  • Finally, you loaded your data into your Excel file.

Excel files to sync Excel to google sheets


Step 4. Syncing the Excel File to Google Sheet

  • Then, pick any cell of the dataset and select Refresh.

Sync the Excel File to Google Sheet

  • Subsequently, an External Data Properties window appears. Pick Query Properties there.

External Data Properties Window

  • Apparently, the Query Properties window pops out. Check all the Refresh boxes there like the image below. Hit OK.

  • Finally, you have made the dataset online. Change any of the cells of your Google Sheet as we change ours.

That’s it! Your data has been changed like the image we have attached here.

Refreshed Data

Read More: How to Automatically Convert Excel File to Google Sheets


Importance of Syncing Excel to Google Sheets

  • When working with large amounts of data, Google Sheets performs slower than Excel. To upload your data into Excel and process it more quickly, you can sync Excel to Google Sheets.
  • In contrast to Google Sheets’ constrained services, Excel provides a wide range of data visualization possibilities. Additionally, Google Sheets’ built-in formulas are insufficient for handling complicated bookkeeping and accounting tasks. Excel, on the other hand, can quickly and easily perform complicated computations. As a result, you may sync Excel to Google Sheets and take advantage of Excel’s superior mathematical and visual capabilities for your data.
  • Your data is exposed to risk since Google Sheets stores it in the cloud. Since hackers may access your business email, it’s quite likely that your cloud data will be taken. It is therefore preferable to alter your data on Google Sheets before storing it in Excel for security. As a result, you can sync Excel to Google Sheets and guarantee the security of your data.

Download Practice Workbook

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


Conclusion

That’s all about today’s session. And these are some easy steps to sync 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. Thanks for reading this article.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
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