Auto-Sync Data from Excel to Google Sheets
Вставка
- Опубліковано 12 чер 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): ua-cam.com/video/ArKeYS_AUA0/v-deo.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
Excelent aportation :)
Amazing what i had been searching for.
Glad I could help.
Please share & subscribe!
@@technologiate I have already done :)
thanks
Thank you very much 🙂
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.
Thank you so much for this superb video.
It helps me a lot
Thank You very much
You are most welcome
verry good explaination thank you so much
You are welcome.
Thank You Very Informative
You are welcome
Thank this very useful to me bro
Welcome
ThankYou !!!! I subscribed
Thank you
Omg thank you so much I really thank you cuz this help me a lot
You are welcome
It was helpful. Thanks.
Also, i've seen too many UA-camrs 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 ❤
Thanks brother
Welcome
how do i solve the problem of couplier expire ? thank for sharing useful tips
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
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!
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.
Will this be okay for some large files?
thank you
You are welcome
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.
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?
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.
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
there are no extensions choice when i open a new spreadsheet in onedrive...
Pls help on this error "This workbook is not accessible through Microsoft Excel API. Please contact our support team for assistance."
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 Bro, Is it work on android?
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.
IF excel file was deleted does google sheet will retain my data?
What of updating multiple worksheets
You to create multiple connections.
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.
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 😢
How to sync excel from same google account
Check this out: ua-cam.com/video/ArKeYS_AUA0/v-deo.html
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.
How do we do this method on the phone
This method works on computers only.
Why not use a Google drive
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
Subscribe! Subscribe! Subscribe! 😊
Coupler is paid app we only have 14 day trial free
Yes
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 ☺