Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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'm trying to retrieve data from Google Spreadsheets with no success.

I've gone through this:


and this:

Simple example of retrieving JSON feeds from Spreadsheets Data AP

I already set my spreadsheet as public (even though it shouldn't) just to take authentication out of the equation.

I have no problem getting the data in Atom/XML. However when I pass the parameter alt=json, I get the following error message:

The spreadsheet at this URL could not be found. Make sure that you have the right URL and that the owner of the spreadsheet hasn't deleted it.

Any ideas why this is happening?

share|improve this question
searched their forums? google.com/support/forum/p/Google+Docs/… – NTulip Feb 1 '11 at 11:54
up vote 2 down vote accepted

After playing around with the API (and banging my head against the monitor), I found out that in order to retrieve data in JSON format from a public spreadsheet you actually have to go through a second process called "Publish to the web" in the Spreadsheets GUI.

What's the reason for this? I haven't found out yet, but judging by the error messages I was getting, I will call it "A BUG".

On a side note, thanks to the people that took the time to reply/edit my question

share|improve this answer
please consider posting this as a bug on their forum – NTulip Feb 2 '11 at 13:21

This thread looks like it might help you. Last comment states:

Well, I just realized I should be using the /feeds/cells/ instead of /feeds/list/

This provides the cells in separate JSON properties like I need. Sorry, I got so caught up trying to make sense of the list format that I completely forgot to look at the cells feed.

Forum Topic

share|improve this answer
Thanks for pointing my to the forums, they didn't address my particular issue but were helpful to understand the problem in a broader sense. – cesarsalazar Feb 1 '11 at 17:41
glad i could help some - i thought for sure it would of fixed it for you. – NTulip Feb 2 '11 at 13:21

You may try to use Power Tools Add-on where you can export selected range into XML or JSON. See the video.

enter image description here

share|improve this answer

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.