Auto-Sync Data from Excel to Google Sheets

Learn how to auto-sync data from Microsft Excel to Google Sheets.
You have an Excel file on your computer, and you want to update the data to Google Sheets when you make some updates to the Excel file.

The process is completely automated. You need to set it up for one time only.

Make sure you have Microsoft OneDrive installed on your computer, and always save the file to the OneDrive folder. It creates the bridge between your computer and Google Sheets.

Subscribe to the channel:

Follow and engage on social media:

#googlesheets #microsoftexcel #autosync

[حماده-جي]

Thank you, this tool is experimental and works temporarily. I want a free method that works permanently

[alpesh]

Very helpful and it's sorted my problem....Thanks keep updating

[pedromartinto]

thank you very much! after trying to find a way to this for a couple of hours your solution was the only one that worked!

[CF-wjhc]

Thanks for this video. I am concerned with giving all those permissions to the app and logging with credentials within the app potentially giving it access to everything. Its a great tool but seems risky.

[.edosatriautama]

Thank you very for much for the video, this is what i searched for a long time

[shoaibtahir]

It was helpful. Thanks.
Also, i've seen too many YouTubers fail because they step into too many boats at once. Pick a theme like "business automation" or "google sheets for office" etc and make a foundation before tou jump into the next category. I pray for your success in the future. I sub

[karlsenpaul]

Thank you so much for this superb video.
It helps me a lot
Thank You very much

[camioneur]

You might hve said it was $49 / month before I started this, works well other than the formatting doesn't import so currency and centreing dissappears after a run

[cshipooo]

Amazing what i had been searching for.

[davozuniga]

Omg thank you so much I really thank you cuz this help me a lot

[Topcey]

verry good explaination thank you so much

[diegoeduardo]

when you close the excel and open it again, for every update after that you'll have to save and close and then click run to update the information in google sheets

[serpantin_tv]

Hi there, very good video! Maybe you could help and explain how is it possible to execute the following task.
There is one Google Sheet, where is placed all the information about each artikul (Position) in the warehouse and its quantity.
There is an Excel file which is on my computer, I always make a copy from the original one and insere some Data, and this Excel file counts how many pieces of exact product I need to use.
E.g. Artikul: Pen - 10 pcs.
I would like to upload this Excel file in Google Drive and somehow the Google Sheet should take this data from this Excel file placed in Google Drive and insert this quantity in the certain cell in Google Sheet.
How do you think it is possible to do it?
We need this to always see the current quantity on the warehouse and so all material expances that leave our warehouse. And so it will help the correct planing of the next orders.

P.S. Sorry, if my English level is bot that high and I really hope you got the idea.

[gkgtxte]

Tanks of your solution. how I can replace Drop Box with the One Drive ?

[DataDears]

So what is the format of this Imported sheet. Excel format or Google sheet ?

[informantunggal]

Brother. Can we use google drive instead of one drive?

[chanatthamsuriya]

Can we not take all columns but select only some of the columns

[NicolaDambrosio-hp]

Hello I have the "empty_window_error" when I try to select the xls file to connect. How can I solve this issue ?

[loliyoki]

how do i solve the problem of couplier expire ? thank for sharing useful tips

[skalim]

"You do not have permissions to open this file in the browser." i am facing this issue while selecting the file while Adding the "importer" . Please help me get this clear