miku miku - 6 months ago 34
JSON Question

google spreadsheet json format (How to open)

I have a publicly shared excel sheet which i want to retrieve in JSON format. I tried following instruction here but it didn't work.
Can somebody please guide me on this.
My sheet: https://docs.google.com/spreadsheets/d/1PDKO3PK-ZvRmZddpqMlEdjsOhXAJngw7ajU3opY-J1M/pubhtml

any tutorial on the latest way of doing something like :
https://developers.google.com/gdata/samples/spreadsheet_sample

Thank you in advance :)

Answer

I just tried it with my own spreadsheet, and this seems to work:

https://spreadsheets.google.com/feeds/list/<SpreadsheetKey>/default/public/values?alt=json-in-script&callback=importGSS

Just insert your spreadsheet ID from your spreadsheet:

https://docs.google.com/spreadsheets/d/<SpreadsheetKey>/edit#gid=0

EDIT: Tried it with yours as well - works!