How To Create A Real-Time Sync Between Excel & Google Sheets Without Excel Add-Ins [Free Download]

In this week’s training, I will show you how to sync Excel with Google Sheets, both ways.

⬇𝗗𝗢𝗪𝗡𝗟𝗢𝗔𝗗 𝗧𝗛𝗜𝗦 𝗪𝗘𝗘𝗞'𝗦 𝗪𝗢𝗥𝗞𝗕𝗢𝗢𝗞 𝗧𝗘𝗠𝗣𝗟𝗔𝗧𝗘 𝗛𝗘𝗥𝗘:

EXCEL COURSES:

EXCEL PRODUCTS:


TIMESTAMPS:
0:00 – Introduction
0:26 – Overview
3:40 – Change Event Worksheet
28:40 – Sync from Google
36:04 – Run Sync

Follow me on my Social Media Accounts:

About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.

Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:

New Training Video Uploaded Every Tuesday And Saturday!

Thank you very much for your continued support,
Randy Austin

#exceltraining #googlesheetssync #googlesheet #excelvba

[alkolff]

Good Morning Randy, I have been working on this very topic the last week. It is almost like you read my mind, because this happens so often. May your day be blessed

[joemanflyer]

I used google sheets on my iPhone and it worked great for use as a baseball manager. Great tips in this video

[Mr.Ammaro]

Really amazing, from new to newest, ( ALLAH ) god bless you friend ...

[kailashsoni]

Sir you are awesome

Love from india

[ronilobongga]

Hi sir, I'm from Philippines. Thank you for this tutorial. Love it. I already done subcribing and hitting the bell. God bless.

[sudarshanshewale]

Amazing knowledge!!! Thanks!!Did it & it works fine. But it updates on manual edits only. When got changes in file with macro, changes doesn't reflect on Google sheet.

[expat]

Very nice. Thank you. And thanks for no music! :)

[MichaelKopanaslike]

That must be the most useful video i've ever seen . Thank you so much

[narasimhanandam]

I am very happy with this video. But I have small request how to sync formats and how to sync sheets and ranges of data

[Emil-srdw]

Great video, many thanks. I have bought a course from your website and its awesome.
Is there any way to make the cell sync when I copy and paste new cell instead of writing them in? Double clicking on each cell for large database would take forever. And when my AppSheet is updating the google sheets my excel is not updated with new value do you have any solution please ?

[isaacnyachae]

Randy you are a blessing! God bless you

[ekowanin]

You just aided me in my final project thanks!!

[jepschannel]

This is what I've been looking for.. Thank you for giving us such a great video..I had a question though. Will it work if I use Google drive or OneDrive instead of a dropbox?

[seychelles]

How rude of me, I was so wrapped up in trying to get it to work at 1am UK time I didn’t even thank you for all your efforts and well, GENIUS way of solving one of life’s issues.. Thank you 🙏🏽.

I copied the code from webhooks and pasted it as you mentiond but, when I go to save work on excel it wants to know what to save file as. What should it be saved as? Unicode Text?

[wasifabbas]

It's a great video & help alot. Kindly prepare video to have data from Google chrome into excel sheets with excel vba or to control Google chrome from Excel vba. I tried my best but am not a pro & you can do it with ease sir

[ronnyshubinsky]

Great tutorial thank so much for this!
I have Hebrew in my sheet and on the google sheet it shows up as gibberish, what can be done?

[abdelazizserrari]

Good Morning Randy, thank you for information, please i want change Dropbox by onedrive for transfer the database in google sheet to excel, thank you .🙏

[jawadkhan]

Its amazing as always...
Please make a brief video on syncing Microsoft excel sheets.

[alexdejavu]

thanks, it works when add data cell by cell to excell. . how is possible to add more data(copy/paste) in excell and work?

[chavelooo]

I love everything you. thanks for sharing