Brad Jasper

← Code

ImportJSON

Archived2017–2022JavaScript · Google Sheets

Archived in 2022 and looking for a new maintainer.

Functions that pull JSON from any API into Google Sheets. I took over maintenance from its original author, Trevor Lohrbeer, in 2017.

Trevor Lohrbeer wrote ImportJSON in 2012. It adds =ImportJSON() and related functions to Google Sheets, so anyone can pull data from a JSON API into a spreadsheet without writing code.

He transferred the project to me in July 2017. I maintained it until 2022: releases 1.4 to 1.6, community fixes, and new functions such as ImportJSONFromSheet and ImportJSONBasicAuth. It has more than 2,000 stars and 1,000 forks on GitHub.