How to Connect Microsoft Excel with Google Sheets | Auto-Sync Google Sheets with Excel
HTML-код
- Опубликовано: 15 июл 2024
- With this video, you can connect Google Sheets with Microsoft Excel. This is a one-time setup. After that, when you update the Google Sheets, the updates will be reflected in the Excel file.
One thing to note, Google Sheets synchronizes the data every five minutes. There is a 5 minutes cycle.
Do not forget to save the Excel file after creating the connection for the first time.
Subscribe to the channel:
/ @technologiate
Follow and engage on social media:
Facebook: / technologiate
Instagram: / technologiate
Twitter: / technolo_giate Наука
Watch how to get data from Excel to Google Sheets *(auto-sync from Excel to Google Sheets)* : ruclips.net/video/hXSSehC8LTY/видео.html
So much valuable education in less than 5 minutes of content. Thank you!!!!
This is really helpful, Thanks :)🤩
Glad it was helpful!
Interesting and informative. Thanks
You are welcome
Thank you so much❤❤❤❤
You are welcome
great video and thx for sharing it! may i ask can we use vba macro on the local connected file (which will need to search some files from the google drive source), for example "load value into cell A1 from "?
Yes you can!
nice video
Thanks
muito bom
Obrigado! Fico feliz que você gostou.
what if i just want specified cell intwo google sheet
Great... Will it do vice versa too? If I will work on excel and it will be updated in Google sheets ?
It doesn't work vice versa. Please watch this to sync data from Excel to Google Sheets: ruclips.net/video/hXSSehC8LTY/видео.html
If I make a change in the excel file does it reflect in Google sheet too??
excel changed, right? can't find the "from web" option.
Yeah, did you ever find a solution?
never. asking a friend specialist on power bi i'll let you know@@ellapeterson1231
hi does this work if we operate the excel on website not the app? and does it support complex formula like using dropdown or checkbox features for example? thanks
I haven't tried any complex formula. It may not work with the formulas that Google Sheets doesn't support.
You can use Excel online instead of Google Sheets in that case.
1:55
I’m trying to follow this, but am hitting a barrier when trying to import data from the web. There is a warning that my credentials could not be authenticated. Any ideas how to resolve this?
Can we do the reverse ? From excel to move data to a spreadsheet ? This is what I am trying to do but I don;t know how . Thank you
Here you go: ruclips.net/video/hXSSehC8LTY/видео.htmlsi=gzVGUUQVGe7GF2L3
How to process muptiple sheets in GOOGLE SHEET ?
Is that possible in not setting the privacy to public? and set it only in private?
It's private
how to refresh without click refresh. mean auto generate data live
You can set auto-refresh for your desired time by following the instructions at 1:56.
I want the opposite to work with an excel file and talk to the data in Google Sheet
Here is the video: ruclips.net/video/hXSSehC8LTY/видео.html
If we can change any thing in excel sheet it be appear in Google sheet a???
Hi, this works only one way. Please watch this video for both wat synchronization: ruclips.net/video/hXSSehC8LTY/видео.html
I didn't get the more options in properties for automate refresh the data
Select the table and select the Query tab, you will see the Properties option.
which version of excel are you using?
I used the Excel that comes with Microsoft 365 Business Standard package.
how can I share this linked sheet with other Users
You can share the Google sheet. If you are trying to share the Excel sheet, keep the Excel file inside the OndeDrive folder, and then you can share it with other users.
Can we save the Excel file in Google Drive instead of OneDrive?
Yes, in that case, you won't need any third-party service.
Will publishing to web put my data at risk?
When publishing the data, anyone can access the data with the link.
@@technologiate What of we can keep the link without leaking
@@et.sachin In that case, it will be private. Google doesn't publish the link to the web.