The add-on will never read or save any of your Google Sheets content that is not involved in the process.įorever free up to 5 external requests per day (1 request = 1 JSON successfully fetched) and unlimited conversions of JSONs pasted in cells. Your data remains at all times your own property and ImportFromWeb will never transfer nor sell them to 3d parties. ImportJSON is a Google Workspace add-on that has successfully passed Google’s security review. Just give a try to ImportJSON with these free REST APIs : ✓ Smart caching - caches results to avoid repeated requests to the API ✓ Customizable - updates your JSON data automatically even when you’re offline ✓ High volume - loads thousands of JSONs in one spreadsheet

✓ Transforms multi level JSON objects into a 2 dimensions table ✓ Parses or analyzes text directly from cells containing a JSON text ✓ Pivots data that share similar properties ✓ Filters JSON objects using simple queries like (“parent/child/0”) within your spreadsheet ✓ Easily retrieves JSONS from any URL, Google Drive document with public “view” rights or using a cURL request Any JSON data directly accessible in your spreadsheet A Drive file with 'view' rights for all

ImportJSON accepts many sources to load data:

Then, you can filter the resulting table to extract the information you need using simple queries like (“parent/child/0”). Just type =IMPORTJSON(your_json_source) and your JSON is displayed in a 2 dimensional array. Parses JSON data no matter whether it is imported or directly accessible from a range of your spreadsheet Extracts and converts JSON data from any API directly into Google Sheets APIs are goldmine! With ImportJSON, anyone can unlock and take advantage of the huge quantity of data they provide without writing any code.

Load json into excel