How to Connect Microsoft Excel with Google Sheets | Auto-Sync Google Sheets with Excel

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:

Follow and engage on social media:

[theladieclair]

So much valuable education in less than 5 minutes of content. Thank you!!!!

[lattebossku]

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 <some excel file in another directory which in the same google drive source>"?

[DarkEmPiResadow]

what if i just want specified cell intwo google sheet

[abdulqoodooss]

Great... Will it do vice versa too? If I will work on excel and it will be updated in Google sheets ?

[reginaldzakibelnevan]

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

[ebimoghankelvin]

If I make a change in the excel file does it reflect in Google sheet too??

[ppprismaaa]

excel changed, right? can't find the "from web" option.

[punkboy]

Is that possible in not setting the privacy to public? and set it only in private?

[aegeanorganicslemnos]

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

[yupcylo]

how to refresh without click refresh. mean auto generate data live

[grootgroot]

How to process muptiple sheets in GOOGLE SHEET ?

[mpdunphy]

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?

[xujcobh]

I want the opposite to work with an excel file and talk to the data in Google Sheet

[kamleshrana]

If we can change any thing in excel sheet it be appear in Google sheet a???

[JDen]

Can i hyperlink google sheet to excel cell by cell not a table?

[bhagwangaur]

I didn't get the more options in properties for automate refresh the data

[csmt]

how can I share this linked sheet with other Users

[arpitchokhani]

Can we save the Excel file in Google Drive instead of OneDrive?

[et.sachin]

Will publishing to web put my data at risk?