Get your spreadsheet as JSON

Paste your google spreadsheet key below and get back a copy in JSON format:

You can also use this URL to get your data:
https://spreadsheet.glitch.me/?key=YOURSPREADSHEETKEY


How to get your spreadsheet key

In Google Sheets (Spreadsheets) create a new spreadsheet. Click File then Publish to the Web. In the new window that opens, click Publish for the entire document. Now your spreadsheet will be reachable (not editable) and a URL is provided. In that URL there is a set of uppercase letters and numbers between two forward slashes. That is your spreadsheet key. Copy it to use here!

Example

In this spreadsheet url:
https://docs.google.com/spreadsheets/d/10vr-bMOH_16Jk6yPyqB7WJTLF3EfKhXh1njP46M9AAc/pubhtml, the spreadsheet key is: 10vr-bMOH_16Jk6yPyqB7WJTLF3EfKhXh1njP46M9AAc.