Excel lookup data from google docs spread sheet

Question

Can excel lookup values from a spreadsheet in google docs? I would like my current excel forms to be able to lookup data from a spread sheet that used to be held on our server but now is a google docs spreadsheet. I have office 07. Thanks for any help.

score 1 · Answer 1 · answered Mar 29 '12 at 14:21

The referenced method on ramblings.mcpher.com/Home/excelquirks/get-data-from-google-docs will work on any google spreadsheet you have access to. The decoding of the returned Google Wire formatted response is all taken care of by the Excel-jSon deserializer.

score 1 · Answer 2 · edited Oct 18 '16 at 20:09

1

You should be able to do this using Excel's web queries.

edited Oct 18 '16 at 20:09

user3618431

143

answered Mar 30 '12 at 08:53

Lèse majesté

3,301

score 0 · Answer 3 · edited May 21 '14 at 15:26

You don't need to share with the web, If you have google drive then it can be private and still accessed.

Save your file to the google drive (this means a link is available on your local hard drive)
When you click on the file in the local drive it will open using a browser with a link like https://docs.google.com/spreadsheet/blah blah blah
In excel use [data]-[from the web] and the link above

There are limitations:

it brings in some guff around it but if you import to one sheet and have the second with only the data it should be ok
It doesn't seem to work with more than 100 records, it gives a response basically saying the record is too big for the browser

Excel lookup data from google docs spread sheet

3 Answers3