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:

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!


In this spreadsheet url:, the spreadsheet key is: 10vr-bMOH_16Jk6yPyqB7WJTLF3EfKhXh1njP46M9AAc.