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.
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
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?
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?
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
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
![How To Create A Real-Time Sync Between Excel & Google Sheets Without Excel Add-Ins [Free Download]](http://i.ytimg.com/vi/l5LwGopYSnk/mqdefault.jpg)
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
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:
ruclips.net/video/Qu0pD7Tq4P4/видео.html
clear crisp useful ! thankyou
Glad it was helpful!
Keep it up ❤️
Big fan of your work ❤️❤️
Thank you so much 😀
Nice tutorial! Subcribled!
Awesome, thank you!
Thanks for the video and simple explanation.
Glad it was helpful!
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?
Thanks Bro,,, new subscriber from indonesia
Welcome!
Awesome bro 👍🙏 very helpful ❤️
Glad to hear that
Thank you
Thank you, so much!
Glad it helped!
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.
Awesome video, superb explanations
Glad you liked it
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
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)
ruclips.net/video/Qu0pD7Tq4P4/видео.html
Thanks for the video. Very useful
Glad you liked it
Sir, if the data too much, and after i want to refresh, the load wait for 5 minutes ya?
Thank you for your video. So far I know, Excel have some option to update the data after a certain period.
Glad it helped!
CAN WE SYNC IMAGES PRESENT IN GOOGLE SHEET.
CAN WE USE VBA TO REFRESH OUR EXCEL EVERY 5 MINUTES?
THANK YOU!
You're welcome!
Lovely brother very important information
Thanks and welcome
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 SO MUCH ....
You're welcome!
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
Thanks for this video! But google forms response spreadsheet not capturing to excel automatically please help me bro
what about privacy of document? Everyone have that url also can view data in Google Sheet
I want ot send Excel data from local file to Google Sheet. Please help.
Thank you for sharing
welcome
Sir how can we fatch data from google sheet to excel sheet and vice- versa. Make a video based upon this.
Ok Great...Please also confirm can we syn data excel to Google Sheet
Well that's a bit complicated but possible. Refer below tutorial.
ruclips.net/video/Qu0pD7Tq4P4/видео.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:
ruclips.net/video/Qu0pD7Tq4P4/видео.html
nicely explained
Thank you 😃
What to do if I have multiple sheets
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
ruclips.net/video/vkiRw9h7cm4/видео.html
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:
ruclips.net/video/-GUw22ecRwI/видео.html
Can it be done PRIVATELY?
Thanks
Welcome
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
Hi sir; only once i was able to next time i tried am unable to do this
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?
how to sync the data "Not" as Table format in Excel. It should just be a Cell
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.
Why this is not working for me. I copied the link in excel but not getting the table
Really interesting but what would be the procedure if we inverse the process. Sync Excel to Google sheet in real time
refer below tutorial:
ruclips.net/video/Qu0pD7Tq4P4/видео.html
How to do the reverse? Excel in P.c to Google sheets online.
refer below tutorial:
ruclips.net/video/Qu0pD7Tq4P4/видео.html
Hey Thanks a lot today you saved me from my boss 😂
Glad to hear that
How about you are writing in excel and automatically sync in google sheet?
But after synchronization hyperlinks gone
How to keep hyperlink
Good video
Thanks for the visit
at the beggining,my data can't synchron into google sheet whereas I have activated XML.3.0
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
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:
ruclips.net/video/Qu0pD7Tq4P4/видео.html
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
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
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.
please check your emails thanks!
How to Automatically Sync Excel with Google sheet?
Edit:- I found the way
how did you do it?
Hi please explain how
These instructions don't match anything on my sheets
Thanks
Welcome