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.