How To Automatically Sync Excel With Google Sheets

In this tutorial we would learn.
1. Automatic Synchronization between MS Excel and Google sheets
2. Auto populate Google forms from Excel VBA

[apidetdamrongsuntisuk]

can you please share me the link I cant find your blog

[SumitMishra-fphk]

Thank You @Automation Made Easy
Really helpful tutorial! and thank you for solving the issue for which I tried from morning.

[TomChang-ih]

I want to sync over Mon & Wed from my excel doc but when I do it, it doesn’t seem to recognize “&” and only syncs Mon. Can you help me?

[prado]

I'm facing trouble populating the data from google form to the Google Sheet. Any changes to be made in the App script?

[davidrivera]

You are the real deal! thank you for all your step by step videos!

[WirelessBrainO]

Hi
In the VBA Scrip the line- intTotalRows = ThisWoekbook.Sheets("data").Cells(Rows.Count, 1).End(xlUp).Row
It say run time error 424 object required
And after I fixed it (dont know how) it shows me error on my first line strFname

[ayanadummett]

this line of code: intTotalRows = ThisWorkbook.Sheets("Data").Cells(Rows.Count, 2).End(xlUp).Row is causing a run-time erro'9': subscript out of range message. how do I fix this?

[AhmedHassan-so]

When I enter the script into Google Sheet, I get an error message
The data does not appear completely in the data sheet
Just one row

[josegalinato]

Thank you so much mate. This is really brilliant!!!!

[kerriesass]

Is there a way to not synch the entire Excel sheet, but only synch the rows that have a date in Column A

[rajb]

Hi - this is excellent, just what I was searching for. Please can you send a link to the Blog of paste the link here. Thanks

[eshantbhoyar]

I am getting unauthorized message box instead of ok message box Reference VB for app., ME16.0 Obj. Liab., Microsoft xml v3.0

[burhangangapur]

only last entry in response sheet is coming can u plz help me in dat at 36:16 what is value of Z1 at line no. 50

[stafadriaensen]

Is there a way to synchronize an total excel form instead of a table?

[xmbond]

Been following all the way through Step 6 and learned that this is for Windows, not Mac

[nuwansamarasinghe]

Can you write a appscript for to sync a excell sheet with google spreadsheet

[collinschabuka]

Hi am getting an error Unauthorized kindly assist

[gmimbukitmoriatikalabaru]

sorry sir want to ask why the UniqueID between Excel and Spredsheet is different for the first input

[elija_ed_vann]

SO SO BRILLIANT..THNAKS THANKS SO MUCH, SIR....BTW ENTERING DATA WHILE OFFLINE, WILL THE DATA BE UPDATED WHEN BACK IN ONLINE LATER.

[chandrashekharprajapati]

I need few help regarding the same,
If I have 60 team members and they all work on their own workbook just need to update all the data on the separate workbook just like in this video.