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.
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
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.
"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
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?
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
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
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.
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, 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.
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.
It was helpful. Thanks. Also, i've seen too many TH-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
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.
Learn how to * Auto-Sync data from Google Sheets to Excel* (Opposite method): th-cam.com/video/ArKeYS_AUA0/w-d-xo.html
MASSIVE FILE, SEEM TO LARGE TO LINK. NOW WHAT ARE MY OPTIONS
Ok, but long method
Thank you so much for this superb video.
It helps me a lot
Thank You very much
You are most welcome
Thank you, this tool is experimental and works temporarily. I want a free method that works permanently
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.
Very helpful and it's sorted my problem....Thanks keep updating
When I try selecting source file from my one drive folders the pop up is blocked what can I do
You need to allow the pop-up on the browser
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
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.
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.
Noy working
Pls help on this error "This workbook is not accessible through Microsoft Excel API. Please contact our support team for assistance."
Excelent aportation :)
Hello I have the "empty_window_error" when I try to select the xls file to connect. How can I solve this issue ?
"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
Subscribe! Subscribe! Subscribe! 😊
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.
Is there other way to do it, beacuse this tool is not free 😢
Omg thank you so much I really thank you cuz this help me a lot
You are welcome
So what is the format of this Imported sheet. Excel format or Google sheet ?
Brother. Can we use google drive instead of one drive?
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!
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?
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
Can we not take all columns but select only some of the columns
how do i solve the problem of couplier expire ? thank for sharing useful tips
ThankYou !!!! I subscribed
Thank you
verry good explaination thank you so much
You are welcome.
thank sr
IF excel file was deleted does google sheet will retain my data?
Thank this very useful to me bro
Welcome
Will this be okay for some large files?
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.
there are no extensions choice when i open a new spreadsheet in onedrive...
Amazing what i had been searching for.
Glad I could help.
Please share & subscribe!
@@technologiate I have already done :)
thanks
Thank you very much 🙂
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.
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.
Why not use a Google drive
Thanks brother
Welcome
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?
thank you
You are welcome
What of updating multiple worksheets
You to create multiple connections.
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.
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.
Coupler is paid app we only have 14 day trial free
Yes
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 to sync excel from same google account
Check this out: th-cam.com/video/ArKeYS_AUA0/w-d-xo.html
Thank You Very Informative
You are welcome
Thank you very for much for the video, this is what i searched for a long time
You are welcome
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
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!
ممكن هذة الطريقة تستخدم من الهاتف
No
@technologiate
This tool can work permanently for free
@@حماده-ج9ي 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
It was helpful. Thanks.
Also, i've seen too many TH-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 ❤
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 ☺