Importing Data From Google Sheet To Excel

[JohnDoh]

Hi all,

I'm sorry as I'm sure this has been asked a few times but I cannot find an answer.

Is it possible to import live, or with predetermined frequency, data from a private google sheet with a macro or other automated method?

I have done the basic "Get Data From Web", just wondered if there was something better, that allows more than 100 entries and I only really need the latest entries.

I use several google forms to collect data onto corresponding Google sheets, I was hoping to import all that data onto one Excel sheet as a central reference point for several other excel sheets used by other individuals who are fearful of google

[JohnDoh]

Bump to top