miku miku - 2 years ago 228
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 :

Thank you in advance :)

Answer Source

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


Just insert your spreadsheet ID from your spreadsheet:


EDIT: Tried it with yours as well - works!

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download