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

<< Go Back to Export Excel to Google Sheets | Export Data from Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Fahim Shahriyar Dipto
Fahim Shahriyar Dipto

Fahim Shahriyar Dipto is a graduate of Mechanical Engineering at BUET. With over 1.5 years of experience at Exceldemy, he authored 70+ articles on ExcelDemy. He has expertise in designing worksheets at You’ve Got This Math. Currently, He is a Team Leader at Brainor. Dipto's passion extends to exploring various aspects of Excel. Beyond tech, he enjoys creating engaging kids' worksheets using Illustrator. A dedicated employee and innovative content developer, He incorporates a commitment to academic excellence and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo