Import JSON into Google Sheets, this library adds various ImportJSON functions to your spreadsheet
Switch branches/tags
Nothing to show
Clone or download
Latest commit a1a71c6 Sep 19, 2018
Permalink
Failed to load latest commit information.
archive Added archive link Jul 24, 2017
AUTHORS Added authors file Jul 24, 2017
ImportJSON.gs Updated README Jul 24, 2017
LICENSE Created LICENSE Jul 24, 2017
README.md Update README.md Sep 19, 2018

README.md

ImportJSON

Looking for help? For $50/hr I'll help with your ImportJSON problem, integrating it into your project. Email bjasper@gmail.com to get started!

Import JSON from any URL directly into your Google Sheets. ImportJSON.gs adds an =ImportJSON() function to your spreadsheet, allowing quick and easy JSON importing. To use go to Tools > Script Editor and add the ImportJSON.gs file. Now in your spreadsheet you can access the ImportJSON() function. Use it like this:

=ImportJSON("https://mysafeinfo.com/api/data?list=bestnovels&format=json&rows=20&alias=cnt=count,avg=average_rank,tt=title,au=author,yr=year", "/title")

Here are all the functions available:

Function Description
ImportJSON For use by end users to import a JSON feed from a URL
ImportJSONFromSheet For use by end users to import JSON from one of the Sheets
ImportJSONViaPost For use by end users to import a JSON feed from a URL using POST parameters
ImportJSONBasicAuth For use by end users to import a JSON feed from a URL with HTTP Basic Auth
ImportJSONAdvanced For use by script developers to easily extend the functionality of this library

Review ImportJSON.gs for more info on how to use these in detail.

Version

  • v1.4.0 (July 23, 2017) - Project transferred to Brad Jasper. Fixed off-by-one array bug. Fixed previous value bug. Added custom annotations. Added ImportJSONFromSheet and ImportJSONBasicAuth.
  • v1.3.0 - Adds ability to import the text from a set of rows containing the text to parse. All cells are concatenated
  • v1.2.1 - Fixed a bug with how nested arrays are handled. The rowIndex counter wasn't incrementing properly when parsing.
  • v1.2.0 - Added ImportJSONViaPost and support for fetchOptions to ImportJSONAdvanced
  • v1.1.1 - Added a version number using Google Scripts Versioning so other developers can use the library
  • v1.1.0 - Added support for the noHeaders option
  • v1.0.0 - Initial release

How can you help?

Website archive

This code base used to be hosted at http://blog.fastfedora.com/projects/import-json and contained a lot of useful information. It has been archived at https://rawgit.com/bradjasper/ImportJSON/master/archive/blog.fastfedora.com/projects/import-json.html

Alternatives

Some of this if possible internally with Google App Scripts External APIs, like UrlFetch: https://developers.google.com/apps-script/guides/services/external

These require a Google account and an explicit permission, but in some cases may be a good fit.