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? Jan 14, 2013 at 9:23
  • it just says invalid, i'm still trying it
    – Noor
    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
    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.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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