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:


  • How does it 'not work'? Any error message? Commented Jan 14, 2013 at 9:23
  • it just says invalid, i'm still trying it
    – Noor
    Commented Jan 14, 2013 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
    Commented Jan 15, 2013 at 17:55

1 Answer 1

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.

  • You need to add the script though....
    – Jacob Jan
    Commented Oct 1, 2013 at 11:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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