What is ImportJSON

ImportJSON is an add-on for Google Sheets that provides a new function to your toolbox: IMPORTJSON()

With IMPORTJSON, you will be able to import and parse JSON data into a Google Sheets table.
JSON data has never been so easy to manipulate!

JSON is a powerful file format based on Javascript object syntax that can store a wealth of complex and public information that’s waiting to be extracted. Luckily, our ImportJSON tool makes this intricate process much simpler, giving you access to an abundance of API data that may otherwise go untapped. 

One of the main difficulties of working with this kind of data is the complicated tree formatting of JSON that can be confusing to manipulate. This is exactly why ImportJSON converts JSON data into a table in GoogleSheets, making your approach to the information digestible.