Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question
2  
It can be done provided the Google spreadsheet is shared to the web, see this website for the method, ramblings.mcpher.com/Home/excelquirks/get-data-from-google-docs. The author describes how to get the Google spreadsheet to return a text string containing cell contents by using an Excel macro. Parsing the returned string would get the cell contents and looks to be the hard part. I don't know if this could be made to work on a private Google docs spreadsheet. –  W_Whalley Mar 23 '12 at 17:09

4 Answers 4

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.

share|improve this answer

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

share|improve this answer

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

  1. Save your file to the google drive (this means a link is available on your local hard drive)
  2. 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
  3. 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
share|improve this answer

Data Everywhere makes add-ins for Google Sheets and Excel that allows you to sync data between Google Sheets and Excel. You just highlight the data you want to synchronize, and both your Excel spreadsheets and your Google Sheets spreadsheets will always be in sync.

Give it a shot at Data Everywhere, or from the Google Sheets Add-in store at https://chrome.google.com/webstore/detail/data-everywhere/foenaaepondggfpfonagpmdaggmpdeel?hl=en-US

share|improve this answer
    
Hello Andy. Note that per superuser.com/help/behavior you must disclose affiliation in your answers and you should also make sure that the purpose of creating your account is not for promoting your product. You can buy ad space on Super User if you want, but excessive promotion may result in your posts being deleted. Try and contribute like everyone else. –  slhck Nov 12 at 21:24

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.