Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a published Google Doc at https://docs.google.com/spreadsheet/pub?key=0AtjON-ccqVTgdDhKeGx0UlZpUWUyLTFZV2szQlJyNnc&output=html that I want to retrieve in JSON. I've been trying this but it’s not working:


share|improve this question
How does it 'not work'? Any error message? – Vidar S. Ramdal Jan 14 '13 at 9:23
it just says invalid, i'm still trying it – Noor Jan 14 '13 at 9:25
It would be nice to have a full working example from Google (I'm a newbie with JSON, jQuery, Javascript, etc). – Oneide Jan 15 '13 at 17:55
https://spreadsheets.google.com/feeds/list/[[your key here]]/od6/public/values?alt=json

Source: http://blog.pamelafox.org/2013/06/exporting-google-spreadsheet-as-json.html

The author doesn't explain it super well, but if you just swap out your key for hers in the example provided in the comments, that works.

share|improve this answer
You need to add the script though.... – Jacob Jan Tuinstra Oct 1 '13 at 11:16

Your Answer


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.