How to import JSON data into Google Spreadsheets?
- Create a new Google Spreadsheet.
- Click on Tools -> Script Editor.
- Click Create script for Spreadsheet.
- Delete the placeholder content and paste the code from this script.
- Rename the script to ImportJSON.gs and click the save button.
- Back in the spreadsheet, in a cell, you can type “=ImportJSON()” and begin filling out it’s parameters.
Example:
=ImportJSON(“http://date.jsontest.com", “/date”,
“noInherit, noTruncate”)
with the following raw JSON from date.jsontest.com:
{
“time”: “05:27:57 AM”,
“milliseconds_since_epoch”: 1394774877499,
“date”: “03-14-2014"
0 Comments