Auto-Sync Data from Excel to Google Sheets
HTML-код
- Опубликовано: 4 июл 2024
- 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.
If you want to learn the opposite method ( create auto-sync data from Google Sheets to Microsoft Excel), watch this video: • How to Connect Microso...
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.
Download OneDrive: www.microsoft.com/en-in/micro...
Subscribe to the channel:
/ @technologiate
Follow and engage on social media:
Facebook: / technologiate
Instagram: / technologiate
Twitter: / technolo_giate
#googlesheets #microsoftexcel #autosync 
Наука
Learn how to * Auto-Sync data from Google Sheets to Excel* (Opposite method): ruclips.net/video/ArKeYS_AUA0/видео.html
MASSIVE FILE, SEEM TO LARGE TO LINK. NOW WHAT ARE MY OPTIONS
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!
Thank you, this tool is experimental and works temporarily. I want a free method that works permanently
Thank you very for much for the video, this is what i searched for a long time
You are welcome
Amazing what i had been searching for.
Glad I could help.
Please share & subscribe!
@@technologiate I have already done :)
thanks
Thank you very much 🙂
Thank You Very Informative
You are welcome
verry good explaination thank you so much
You are welcome.
ThankYou !!!! I subscribed
Thank you
Thank you so much for this superb video.
It helps me a lot
Thank You very much
You are most welcome
Excelent aportation :)
Thank this very useful to me bro
Welcome
Thanks brother
Welcome
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.
Omg thank you so much I really thank you cuz this help me a lot
You are welcome
thank sr
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
thank you
You are welcome
It was helpful. Thanks.
Also, i've seen too many RUclipsrs 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
Thank you very much ❤
how do i solve the problem of couplier expire ? thank for sharing useful tips
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
So what is the format of this Imported sheet. Excel format or Google sheet ?
Will this be okay for some large files?
there are no extensions choice when i open a new spreadsheet in onedrive...
Bro, excuse me, I closed the excel that was synchronized with google sheets and when I reopened that file it wasn't updating anymore with google sheets, is it normal?
Tanks of your solution. how I can replace Drop Box with the One Drive ?
You can use Dropbox as the source destination.
1. Select Dropbox as a source.
2. Select the XLSX file from the Dropbox folder.
Can it bring and sync the formulas and formatting also from the excel sheet saved in one drive.
To be honest, I didn't try synchronizing the formulas and formatting.
If it doesn't you can create the same formulas & formatings in the Google Sheets as well.
I loved the video! I tried it out and it worked. But I have a big problem and would really appreciate some help. Is there any way to synchronize more than 10k rows?
Hi Valeria,
If you need to sync more than 10K rows at once, you need to get their Squad or Business plan, which will let you sync 50K and 100K, respectively.
I didn't try any other method yet, will create another video with different features soon.
@@technologiate is the any update to sync more than 10K rows?
Yes, I need to sync more data as well!
I followed the tuts to the destination point and i couldn't select multiples sheets though i could select multiple sheets for the source and it ended up merging all the sheets in the destination file
Hi, when you select multiple sheets it merge all the data and show it in one sheet. If you need the sheets on multiple sheets then you have to create the synchronization on different sheets on the Google Sheets. Hope it works for you.
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.
Can we done through app script...i want upload the data automatically in Google drive instead of one drive from local computer then auto sync in Google sheets
When the file is on Google Drive then you can open it on Google Sheets, you do not need any synchronizations. I am not sure if you want this.
Hi Bro, Is it work on android?
IF excel file was deleted does google sheet will retain my data?
What of updating multiple worksheets
You to create multiple connections.
Importing web data into pc excel and enable auto refresh.
Is any way can I access see real refresh data on mobile excel please reply
You can use OneDrive to access the Excel files on the phone.
It's a subscription base add on 24 $ per month
Hi,
Yes, it's a premium Google Sheets add-on. Besides, it provides a lot of other tools as well.
You can try the add-on before purchasing the premium plan.
Hi, not able to import more than 3000 row , is there is any other options ..please help
Hi, I am working on a new video. I will upload it soon.
Thank you.
How to sync excel from same google account
Check this out: ruclips.net/video/ArKeYS_AUA0/видео.html
Pls help on this error "This workbook is not accessible through Microsoft Excel API. Please contact our support team for assistance."
How do we do this method on the phone
This method works on computers only.
Is it lock till 10k row only ?
Hi, the trial plan supports 10K rows in one run
Is there other way to do it, beacuse this tool is not free 😢
Why not use a Google drive
Subscribe! Subscribe! Subscribe! 😊
Nice but there is no free basic version and it's to pricey for me when I need it for 3 files a year
I agree; the price for the addon is a bit pricey.
Soon I will create another video to connect Google Sheets with Excel via Microsoft 365 apps.
Please subscribe to stay tuned.
ممكن هذة الطريقة تستخدم من الهاتف
No
@technologiate
This tool can work permanently for free
@@user-xu1jc8ob7h No, it's not free. You can use this for free for 14 days.
@technolo
@technologiate
I want a free method
We do not have the money to participate. We are from Yemen and you know the situation in Yemen
Coupler is paid app we only have 14 day trial free
Yes
Ok, but long method
No use, the add on is on paid version, asking to sign up and not able to connect thru any medium. Useless video
Coupler.io offers a free trial to try it out.
is there any other add on that is free ?? Coupler.io requires montly subscription!!
Hi, I am on a new view to show how to synchronize Google Sheets with Microsoft Excel without a third-party extension.
NOTE: It will require API from Google. I will show the complete process in the video.
Stay tuned.
@@technologiate ok thank you! I will check again in a months time ☺