---
title: "ImportJSON — Brad Jasper"
description: "Functions that pull JSON from any API into Google Sheets. I took over maintenance from its original author, Trevor Lohrbeer, in 2017."
url: https://bradjasper.com/projects/importjson/
---

[← Code](https://bradjasper.com/code/)

# ImportJSON

Archived · 2017–2022 · JavaScript · 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.

- [Source on GitHub](https://github.com/bradjasper/ImportJSON)

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.