Тёмный

Auto-Sync Data from Excel to Google Sheets 

Technologiate
Подписаться 5 тыс.
Просмотров 72 тыс.
50% 1

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

Наука

Опубликовано:

 

6 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 93   
@technologiate
@technologiate Год назад
Learn how to * Auto-Sync data from Google Sheets to Excel* (Opposite method): ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ArKeYS_AUA0.html
@jonshellington8155
@jonshellington8155 Год назад
MASSIVE FILE, SEEM TO LARGE TO LINK. NOW WHAT ARE MY OPTIONS
@pedromartinto2190
@pedromartinto2190 Год назад
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!
@user-xu1jc8ob7h
@user-xu1jc8ob7h Год назад
Thank you, this tool is experimental and works temporarily. I want a free method that works permanently
@11.edosatriautama79
@11.edosatriautama79 Год назад
Thank you very for much for the video, this is what i searched for a long time
@technologiate
@technologiate Год назад
You are welcome
@SURAMINERA
@SURAMINERA 2 месяца назад
Excelent aportation :)
@karlsenpaul9660
@karlsenpaul9660 Год назад
Thank you so much for this superb video. It helps me a lot Thank You very much
@technologiate
@technologiate Год назад
You are most welcome
@sylviayvette
@sylviayvette Год назад
Thank You Very Informative
@technologiate
@technologiate Год назад
You are welcome
@Topcey1213
@Topcey1213 Год назад
verry good explaination thank you so much
@technologiate
@technologiate Год назад
You are welcome.
@cshipooo
@cshipooo Год назад
Amazing what i had been searching for.
@technologiate
@technologiate Год назад
Glad I could help. Please share & subscribe!
@cshipooo
@cshipooo Год назад
@@technologiate I have already done :) thanks
@technologiate
@technologiate Год назад
Thank you very much 🙂
@pratyushjha5961
@pratyushjha5961 2 месяца назад
ThankYou !!!! I subscribed
@technologiate
@technologiate 2 месяца назад
Thank you
@davozuniga3701
@davozuniga3701 4 месяца назад
Omg thank you so much I really thank you cuz this help me a lot
@technologiate
@technologiate 4 месяца назад
You are welcome
@loliyoki2097
@loliyoki2097 6 месяцев назад
how do i solve the problem of couplier expire ? thank for sharing useful tips
@harrishragav5952
@harrishragav5952 Год назад
Thank this very useful to me bro
@technologiate
@technologiate Год назад
Welcome
@CF-wj5hc
@CF-wj5hc 3 месяца назад
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.
@moehaymanhnin7513
@moehaymanhnin7513 10 месяцев назад
thank sr
@shoaibtahir575
@shoaibtahir575 Год назад
It was helpful. Thanks. Also, i've seen too many RU-vidrs 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
@technologiate
@technologiate Год назад
Thank you very much ❤
@camioneur
@camioneur 9 месяцев назад
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
@user-xo9ep6vo5w
@user-xo9ep6vo5w Год назад
Thanks brother
@technologiate
@technologiate Год назад
Welcome
@emadalrikabi988
@emadalrikabi988 3 месяца назад
thank you
@technologiate
@technologiate 3 месяца назад
You are welcome
@user-gk3gt1xt7e
@user-gk3gt1xt7e 7 месяцев назад
Tanks of your solution. how I can replace Drop Box with the One Drive ?
@technologiate
@technologiate 7 месяцев назад
You can use Dropbox as the source destination. 1. Select Dropbox as a source. 2. Select the XLSX file from the Dropbox folder.
@valeriabenitez8245
@valeriabenitez8245 Год назад
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?
@technologiate
@technologiate Год назад
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.
@cristophersandyharsoyo7666
@cristophersandyharsoyo7666 8 месяцев назад
@@technologiate is the any update to sync more than 10K rows?
@mhmdseadawy8228
@mhmdseadawy8228 8 месяцев назад
Yes, I need to sync more data as well!
@diegoeduardo4487
@diegoeduardo4487 Год назад
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
@user-jy8pr4ne2b
@user-jy8pr4ne2b Год назад
there are no extensions choice when i open a new spreadsheet in onedrive...
@DataDears
@DataDears Месяц назад
So what is the format of this Imported sheet. Excel format or Google sheet ?
@diegoeduardo4487
@diegoeduardo4487 Год назад
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?
@andresmichael359
@andresmichael359 2 месяца назад
Will this be okay for some large files?
@Riyaswelgate
@Riyaswelgate Год назад
Can it bring and sync the formulas and formatting also from the excel sheet saved in one drive.
@technologiate
@technologiate Год назад
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.
@viveksharma4193
@viveksharma4193 Год назад
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
@technologiate
@technologiate Год назад
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.
@chanatthamsuriya2697
@chanatthamsuriya2697 2 дня назад
Can we not take all columns but select only some of the columns
@kattwong
@kattwong Год назад
Hi Bro, Is it work on android?
@serpantin_tv
@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.
@STDOMINICSSHTPROVIDENTFUND
@STDOMINICSSHTPROVIDENTFUND Год назад
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
@technologiate
@technologiate Год назад
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.
@NicolaDambrosio-h9p
@NicolaDambrosio-h9p 12 дней назад
Hello I have the "empty_window_error" when I try to select the xls file to connect. How can I solve this issue ?
@user-dz8ym9ew1l
@user-dz8ym9ew1l 8 месяцев назад
IF excel file was deleted does google sheet will retain my data?
@SSR27
@SSR27 5 месяцев назад
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
@technologiate
@technologiate 5 месяцев назад
You can use OneDrive to access the Excel files on the phone.
@informantunggal9749
@informantunggal9749 22 дня назад
Brother. Can we use google drive instead of one drive?
@skalim6081
@skalim6081 20 дней назад
"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
@jamesmwanza4289
@jamesmwanza4289 Год назад
What of updating multiple worksheets
@technologiate
@technologiate Год назад
You to create multiple connections.
@RanjanNayak-ur3lz
@RanjanNayak-ur3lz 6 месяцев назад
Hi, not able to import more than 3000 row , is there is any other options ..please help
@technologiate
@technologiate 6 месяцев назад
Hi, I am working on a new video. I will upload it soon. Thank you.
@mustansirujjain
@mustansirujjain Год назад
How to sync excel from same google account
@technologiate
@technologiate Год назад
Check this out: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ArKeYS_AUA0.html
@husainlaatsaheb2626
@husainlaatsaheb2626 3 месяца назад
Pls help on this error "This workbook is not accessible through Microsoft Excel API. Please contact our support team for assistance."
@santoshtodkar4463
@santoshtodkar4463 Год назад
It's a subscription base add on 24 $ per month
@technologiate
@technologiate Год назад
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.
@arjunghodke7382
@arjunghodke7382 Год назад
Is it lock till 10k row only ?
@technologiate
@technologiate Год назад
Hi, the trial plan supports 10K rows in one run
@user-xu1jc8ob7h
@user-xu1jc8ob7h Год назад
How do we do this method on the phone
@technologiate
@technologiate Год назад
This method works on computers only.
@ebimoghankelvin2466
@ebimoghankelvin2466 4 дня назад
When I try selecting source file from my one drive folders the pop up is blocked what can I do
@technologiate
@technologiate 4 дня назад
You need to allow the pop-up on the browser
@Accountingpapers
@Accountingpapers 3 месяца назад
Is there other way to do it, beacuse this tool is not free 😢
@technologiate
@technologiate Год назад
Subscribe! Subscribe! Subscribe! 😊
@polymach7379
@polymach7379 Год назад
Why not use a Google drive
@KatarinaRosanLeovac
@KatarinaRosanLeovac Год назад
Nice but there is no free basic version and it's to pricey for me when I need it for 3 files a year
@technologiate
@technologiate Год назад
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.
@user-xu1jc8ob7h
@user-xu1jc8ob7h Год назад
ممكن هذة الطريقة تستخدم من الهاتف
@technologiate
@technologiate Год назад
No
@user-xu1jc8ob7h
@user-xu1jc8ob7h Год назад
@technologiate This tool can work permanently for free
@technologiate
@technologiate Год назад
@@user-xu1jc8ob7h No, it's not free. You can use this for free for 14 days.
@user-xu1jc8ob7h
@user-xu1jc8ob7h Год назад
@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
@user-lw8no7kr8j
@user-lw8no7kr8j Год назад
Coupler is paid app we only have 14 day trial free
@technologiate
@technologiate Год назад
Yes
@indranilsarkar4046
@indranilsarkar4046 Месяц назад
Ok, but long method
@eaSynergyeyecare
@eaSynergyeyecare 5 месяцев назад
No use, the add on is on paid version, asking to sign up and not able to connect thru any medium. Useless video
@technologiate
@technologiate 5 месяцев назад
Coupler.io offers a free trial to try it out.
@LostMyLines
@LostMyLines Год назад
@ann0ynim0us
@ann0ynim0us 10 месяцев назад
is there any other add on that is free ?? Coupler.io requires montly subscription!!
@technologiate
@technologiate 10 месяцев назад
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.
@ann0ynim0us
@ann0ynim0us 10 месяцев назад
@@technologiate ok thank you! I will check again in a months time ☺
Далее
Automate Writing Excel Formula | Excel Formula Bot
5:58
Upload/Export Data To Google Sheets Excel VBA Macro
10:57
🤯️ Vini Jr. ✖️ Brahim 🤯
00:13
Просмотров 3,8 млн
Пиратские котики
00:50
Просмотров 109 тыс.
How to import Excel to Google Sheets [AUTOMATICALLY]
5:59
How to connect Google Sheets to Excel
5:31
Просмотров 126 тыс.
This is how I ACTUALLY analyze data using Excel
24:05
Просмотров 109 тыс.
How To Automatically Sync Excel With Google Sheets
44:40
✨ Google Sheets Introduces Tables
7:27
Просмотров 26 тыс.
Nokia 3310 top
0:20
Просмотров 4,3 млн
Cool Gaming PC Build! #shorts
1:00
Просмотров 3,2 млн
Чем нельзя протирать экран?
0:44