Thank you for this video. I would recommend using a different approach today doesn't require to wait for the 5 minutes republishing to take effect. Instead of doing publish to web, it's possible to share the file and set "anyone with the link" as viewer. Then replace the end of the URL link to be "export?format=xlsx". This causes excel to read the Sheets file , regardless of publishing to the web. Then any refresh of the query in Excel, will bring the most up to date data.
Hi, do u think it's safe way ? no one can get your data ? because when i did the same approach I found new users ( anonyme ...) so I changed the setting immediatly i conclud that it's not as safe for confidential Data
@@samihakhenaka3845 Hi there For sure it's not safe 100% safe and not recommended for confidential data. But what are the odds of someone finding your link? 😊
@@excelratiTahnks for your replay as I told you I just found strange profiles connecting to my documents with strange names ( anonyme ant and so on ) so i'm not sure about the safty of this method
@@excelrati sI don't think excel will use strange profiles which have animal names :) ?! I hope that people who faced the same situation share with us their experience
Hi bro, Thank you so much for this helpful video. I got one question: Is there anyway to sync all spreadsheets I have in Google Sheets to excel? In the video tutorial as I can see we only able to sync only one Google Sheet to excel sheet. Thank you so much
Thank you for this --- very helpful. One question - can you add a notes column only to the excel file and will any notes you add stay with their respective rows once you refresh? I like using google forms to collect data, but I would prefer the data to go directly to Excel where the formatting is easier. I do not want to use a product like Zapier, have to add coding, or depend on manually downloading anything. So I'm hopeful I will be able to add information in both google forms and Excel, and have the google sheets just sit there in the background to shuttle info over to Excel.
Thank you for the great video and simple explanation. I have a concern though, if I close the excel/csv file that is linked to the Google Sheet, it loses the connection. Is there a way to keep the connection even after closing the excel/csv. I would like to sync the data from GS to csv and link the csv to QGIS as a joined table to shapefiles. If you have a solution to this, or anyone who reads this, please assist me. Thanks in advance.
Good info .. thanks. I have a Microsoft Office 365 subscription. Can I publish my Excel worksheet to the web and then sync with my Google Sheet ? I do not see that option under "Publish" ?
Hey thanks for this but one query like will it possible otherway like syncing from excel sheet to google sheet > like every time i make Changes in excel should also reflects to Google sheets
Great Video. Subscribed! One question though... If I alter the excel file, would it reflect within the original google sheet? Basically, is it a one-way or two-way sync?
Hi, I have an issue with this where when a change is made in excel it wont send that change back to google sheets. This means the link isnt bidirectional, do you have a workaround for this?
I have a small business and keep all my lead data on a Google sheet. After I get lead update from my client, I manually update lead status change in google sheet. Is there an easy way to auto update lead status from an excel report that I get from client?
hey bro can you make an updated version of automating complex google form entries with google scripts? because theres a new update and it does not work anymore thanks
Bro Can we open multiple url/link on chrome using Excel via VBA automatically Can you suggest how to do it My ask is to open multiple url one at a time taking input from Excel and using vba
I have a question you might be able to help with. Thanks in advance if you can. Every time I download an Excel file or open an Excel file, Google is creating a sheet. How do I stop this?
Sorry i didnt understand the question. Can you please elaborate. When you download/open MS excel or Google sheet you see this behaviour? Where the sheet is getting created on Google drive or your computer's hard drive?
I followed the same steps as you explained, but I get only below 2 rows after setting the Data connection from Web instead of the actual data I have on Google sheet. After pasting the url on the popup, in the next step (Navigator) I only see the Document item but no Sheet 0 Kind Name Text Element HTML
This tutorial was really helpful for me and my career which I just started as an IT Intern. Thank you very much. ❤
Thank you for this video.
I would recommend using a different approach today doesn't require to wait for the 5 minutes republishing to take effect.
Instead of doing publish to web, it's possible to share the file and set "anyone with the link" as viewer. Then replace the end of the URL link to be "export?format=xlsx".
This causes excel to read the Sheets file , regardless of publishing to the web.
Then any refresh of the query in Excel, will bring the most up to date data.
Hi, do u think it's safe way ? no one can get your data ? because when i did the same approach I found new users ( anonyme ...) so I changed the setting immediatly i conclud that it's not as safe for confidential Data
@@samihakhenaka3845
Hi there
For sure it's not safe 100% safe and not recommended for confidential data.
But what are the odds of someone finding your link? 😊
@@excelratiTahnks for your replay as I told you I just found strange profiles connecting to my documents with strange names ( anonyme ant and so on ) so i'm not sure about the safty of this method
@@samihakhenaka3845
Could it be that the Excel is the anonymous profile?
@@excelrati sI don't think excel will use strange profiles which have animal names :) ?! I hope that people who faced the same situation share with us their experience
Hi bro, Thank you so much for this helpful video. I got one question: Is there anyway to sync all spreadsheets I have in Google Sheets to excel? In the video tutorial as I can see we only able to sync only one Google Sheet to excel sheet. Thank you so much
Lovely brother very important information
Thanks and welcome
Thank you for this --- very helpful. One question - can you add a notes column only to the excel file and will any notes you add stay with their respective rows once you refresh? I like using google forms to collect data, but I would prefer the data to go directly to Excel where the formatting is easier. I do not want to use a product like Zapier, have to add coding, or depend on manually downloading anything. So I'm hopeful I will be able to add information in both google forms and Excel, and have the google sheets just sit there in the background to shuttle info over to Excel.
Thanks Bro,,, new subscriber from indonesia
Welcome!
Thank you for a very nice n useful tutorial
Glad you liked it
Thank you for the great video and simple explanation. I have a concern though, if I close the excel/csv file that is linked to the Google Sheet, it loses the connection. Is there a way to keep the connection even after closing the excel/csv. I would like to sync the data from GS to csv and link the csv to QGIS as a joined table to shapefiles. If you have a solution to this, or anyone who reads this, please assist me. Thanks in advance.
If your referring to excel to google sheet synchronization. Please refer below tutorial:
th-cam.com/video/Qu0pD7Tq4P4/w-d-xo.html
Thank you
Is there a way to do it the other way i.e. excel to google sheets ?
Good info .. thanks. I have a Microsoft Office 365 subscription. Can I publish my Excel worksheet to the web and then sync with my Google Sheet ? I do not see that option under "Publish" ?
Following
Thank you for your video. So far I know, Excel have some option to update the data after a certain period.
Glad it helped!
hallo. it seems that on a Mac in excel the "data - From web " functionality is not possible .. do you know how to solve this issue ? thanks a lot
Hello great video...
Is there any solution to sync one way Excel > Google Sheet...???
Refer below tutorial. (Solution is bit complicated and involves lot of scripting)
th-cam.com/video/Qu0pD7Tq4P4/w-d-xo.html
Ok Great...Please also confirm can we syn data excel to Google Sheet
Well that's a bit complicated but possible. Refer below tutorial.
th-cam.com/video/Qu0pD7Tq4P4/w-d-xo.html
Thanks for the video and simple explanation.
Glad it was helpful!
Hey thanks for this but one query like will it possible otherway like syncing from excel sheet to google sheet > like every time i make Changes in excel should also reflects to Google sheets
its possible but a bit complex. All steps are explained in below tutorial:
th-cam.com/video/Qu0pD7Tq4P4/w-d-xo.html
Great Video. Subscribed! One question though... If I alter the excel file, would it reflect within the original google sheet? Basically, is it a one-way or two-way sync?
no .. two way sync no feasible
Two way sync not feasible means he doesn't know how. So look for Randy Austin Excel for Freelancers has 2 way sync.
Hi, I have an issue with this where when a change is made in excel it wont send that change back to google sheets. This means the link isnt bidirectional, do you have a workaround for this?
Any way to move the data at selected cells. in a formatted excel.
clear crisp useful ! thankyou
Glad it was helpful!
Is there a way to get the excel file to refresh automatically as well? Or at least refresh everytime the file is opened.
this would be possible with a bit of VBA script.
Definitely possible, try this
th-cam.com/video/vkiRw9h7cm4/w-d-xo.html
The navigator says the current preview is too complex to display. What can I do about it ?
Thanks for the video. Very useful
Glad you liked it
I have a small business and keep all my lead data on a Google sheet. After I get lead update from my client, I manually update lead status change in google sheet. Is there an easy way to auto update lead status from an excel report that I get from client?
CAN WE SYNC IMAGES PRESENT IN GOOGLE SHEET.
CAN WE USE VBA TO REFRESH OUR EXCEL EVERY 5 MINUTES?
Sir, if the data too much, and after i want to refresh, the load wait for 5 minutes ya?
what about privacy of document? Everyone have that url also can view data in Google Sheet
Fabulous tutorial. I was able to use this immediately. Thank you.
Glad it was helpful!
Can it be done PRIVATELY?
Thank you for sharing
welcome
hi I would like to do the vice versa... from excel to google sheets...
47 other people asked this same question. read one and look at reply that has link it says works.
Which excel version you are using in this video
2016
hey bro can you make an updated version of automating complex google form entries with google scripts? because theres a new update and it does not work anymore thanks
Sir how can we fatch data from google sheet to excel sheet and vice- versa. Make a video based upon this.
Awesome bro 👍🙏 very helpful ❤️
Glad to hear that
Hi, thanks and viceversa, how would it be
Keep it up ❤️
Big fan of your work ❤️❤️
Thank you so much 😀
I want ot send Excel data from local file to Google Sheet. Please help.
Very nice but how can we do it vise versa from online excel to Google sheet? Is there any ways, thanks in advance.
Let me check
EVEN I AM WAITING FOR THIS..
@@ssbstock3093 let's see if he can help us.
I need to know too
As of now I do not have a solution. I am still researching. If I find something will surely share.
nicely explained
Thank you 😃
Bro
Can we open multiple url/link on chrome using Excel via VBA automatically
Can you suggest how to do it
My ask is to open multiple url one at a time taking input from Excel and using vba
Refer below tutorial:
th-cam.com/video/-GUw22ecRwI/w-d-xo.html
I have a question you might be able to help with. Thanks in advance if you can. Every time I download an Excel file or open an Excel file, Google is creating a sheet. How do I stop this?
Sorry i didnt understand the question. Can you please elaborate.
When you download/open MS excel or Google sheet you see this behaviour?
Where the sheet is getting created on Google drive or your computer's hard drive?
Awesome video, superb explanations
Glad you liked it
i tried it but instead of data following things appear. I dont know whats the issue is.
Hey Thanks a lot today you saved me from my boss 😂
Glad to hear that
Sir is it possible vice versa. Pls reply.
not that I am aware of
How about you are writing in excel and automatically sync in google sheet?
Bro I published entire document and oh this document there is 4 sheet but it only showing me first sheet or single table in navigator ??
yet it works for one sheet at a time. You can pubilsh other google sheets and link the url to an excel as an alternate approach.
What to do if I have multiple sheets
Why this is not working for me. I copied the link in excel but not getting the table
Hi sir; only once i was able to next time i tried am unable to do this
Good video
Thanks for the visit
How to do the reverse? Excel in P.c to Google sheets online.
refer below tutorial:
th-cam.com/video/Qu0pD7Tq4P4/w-d-xo.html
Really interesting but what would be the procedure if we inverse the process. Sync Excel to Google sheet in real time
refer below tutorial:
th-cam.com/video/Qu0pD7Tq4P4/w-d-xo.html
But after synchronization hyperlinks gone
How to keep hyperlink
Thank you so much for your videos!
You are so welcome!
Can you find a way to exchange data between Google sheet and Excel in Real Time?
not real time. there will be a delay of around 5 mins
THANK YOU SO MUCH ....
You're welcome!
Nice tutorial! Subcribled!
Awesome, thank you!
Thank you, so much!
Glad it helped!
how to sync the data "Not" as Table format in Excel. It should just be a Cell
CAN YOU TELL US THE REVERSE PROCECESS, THAT MEANS SEND REAL TIME DATA FROM EXCEL TO GOOGLE SHEET
refer below tutorial:
th-cam.com/video/Qu0pD7Tq4P4/w-d-xo.html
THANK YOU!
You're welcome!
at the beggining,my data can't synchron into google sheet whereas I have activated XML.3.0
How to Automatically Sync Excel with Google sheet?
Edit:- I found the way
how did you do it?
Hi please explain how
I followed the same steps as you explained, but I get only below 2 rows after setting the Data connection from Web instead of the actual data I have on Google sheet.
After pasting the url on the popup, in the next step (Navigator) I only see the Document item but no Sheet 0
Kind Name Text
Element HTML
Same with me
u can not see it update when i update my google sheet
if you have to click buttons to sync, why not save all these hassle, just go file-download and that's 2 clicks
Thanks
Welcome
These instructions don't match anything on my sheets
please check your emails thanks!
Thanks
Welcome