In this tutorial we would learn 1. How to synchronize data between Google Sheets and MS Excel 2. We would also learn how to publish Google sheets on Web
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 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.
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?
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
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" ?
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 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
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
Fabulous tutorial. I was able to use this immediately. Thank you.
Glad it was helpful!
Thank you so much for your videos!
You are so welcome!
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
clear crisp useful ! thankyou
Glad it was helpful!
Thanks for the video and simple explanation.
Glad it was helpful!
Thank you
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, so much!
Glad it helped!
Keep it up ❤️
Big fan of your work ❤️❤️
Thank you so much 😀
Thanks Bro,,, new subscriber from indonesia
Welcome!
Nice tutorial! Subcribled!
Awesome, thank you!
Thanks for the video. Very useful
Glad you liked it
THANK YOU!
You're welcome!
Awesome video, superb explanations
Glad you liked it
Awesome bro 👍🙏 very helpful ❤️
Glad to hear that
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.
Thank you for a very nice n useful tutorial
Glad you liked it
Lovely brother very important information
Thanks and welcome
Is there a way to do it the other way i.e. excel to google sheets ?
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?
THANK YOU SO MUCH ....
You're welcome!
Sir, if the data too much, and after i want to refresh, the load wait for 5 minutes ya?
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
Any way to move the data at selected cells. in a formatted excel.
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 sharing
welcome
CAN WE SYNC IMAGES PRESENT IN GOOGLE SHEET.
CAN WE USE VBA TO REFRESH OUR EXCEL EVERY 5 MINUTES?
what about privacy of document? Everyone have that url also can view data in Google Sheet
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?
Thank you for your video. So far I know, Excel have some option to update the data after a certain period.
Glad it helped!
Sir how can we fatch data from google sheet to excel sheet and vice- versa. Make a video based upon this.
nicely explained
Thank you 😃
Thanks for this video! But google forms response spreadsheet not capturing to excel automatically please help me bro
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
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
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
I want ot send Excel data from local file to Google Sheet. Please help.
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
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
Thanks
Welcome
Can it be done PRIVATELY?
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?
But after synchronization hyperlinks gone
How to keep hyperlink
i tried it but instead of data following things appear. I dont know whats the issue is.
Which excel version you are using in this video
2016
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
how to sync the data "Not" as Table format in Excel. It should just be a Cell
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
Hi sir; only once i was able to next time i tried am unable to do this
Why this is not working for me. I copied the link in excel but not getting the table
How about you are writing in excel and automatically sync in google sheet?
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
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
Good video
Thanks for the visit
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.
Hey Thanks a lot today you saved me from my boss 😂
Glad to hear that
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
Sir is it possible vice versa. Pls reply.
not that I am aware of
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
at the beggining,my data can't synchron into google sheet whereas I have activated XML.3.0
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.
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
please check your emails thanks!
These instructions don't match anything on my sheets
How to Automatically Sync Excel with Google sheet?
Edit:- I found the way
how did you do it?
Hi please explain how
Thanks
Welcome