App Icon
Import JSON data from any API and convert it into an easy-to-read table. All through a simple function!
Listing updated:May 18, 2022
Works with:
78,025
Overview
APIs are goldmine! With ImportJSON, anyone can unlock and take advantage of the huge quantity of data they provide without writing any code. 

IMPORTJSON is a simple function that : 
- Extracts and converts JSON data from any API directly into Google Sheets
- Parses JSON data no matter whether it is imported or directly accessible from a range of your spreadsheet 

📌 HOW DOES IT WORK ?

Just type =IMPORTJSON(your_json_source) and your JSON is displayed in a 2 dimensional array.
Then, you can filter the resulting table to extract the information you need using simple queries like (“parent/child/0”).

Yes, as simply as that !


ImportJSON accepts many sources to load data:
- Any URL
- cURL requests
- A Drive file with "view" rights for all
- Any JSON data directly accessible in your spreadsheet   

📌 MAIN FEATURES

✓ Easily retrieves JSONS from any URL, Google Drive document with public “view” rights or using a  cURL request
✓ Filters JSON objects using simple queries like (“parent/child/0”) within your spreadsheet
✓ Pivots data that share similar properties
✓ Parses or analyzes text directly from cells containing a JSON text 
✓ Transforms multi level JSON objects into a 2 dimensions table
✓ High volume - loads thousands of JSONs in one spreadsheet
✓ Customizable - updates your JSON data automatically even when you’re offline
✓ Smart caching - caches results to avoid repeated requests to the API
✓ and much more to come ! 


Just give a try to ImportJSON with these free REST APIs :  
- NASA: https://api.nasa.gov/
- Weather: https://openweathermap.org/api
- Countries meta: https://restcountries.eu/
- All Wikipedia: https://www.mediawiki.org/wiki/API:Main_page

📌 PRIVACY

ImportJSON is a Google Workspace add-on that has successfully passed Google’s security review. The add-on requires minimal permissions. Your data remains at all times your own property and ImportFromWeb will never transfer nor sell them to 3d parties. 
The add-on will never read or save any of your Google Sheets content that is not involved in the process.

📌 PRICING

Start for free with 5 external requests per day and unlimited conversion of JSONs pasted in cells.
Then, choose between our different plans according to your needs. 

📌 SUPPORT

✓ Have a look at our repository of resources and demos at https://nodatanobusiness.com/resources/importjson/ 
✓ Check out our ready-to-use templates for the most popular platforms
✓ Browse our tutorials on our Youtube channel
✓ Contact us and we’ll help you to get the most of our add-on ! support@nodatanobusiness.com 



--------------

Many users of ImportFromWeb, Supermetrics, Mixed Analytics, KPI bees, DataConnector, SheetGo, Google Analytics, Autocrat and Power Tools already love our scraper.

ImportJSON, among the best add-ons for Google Sheets !

Read more at https://nodatanobusiness.com/importjson/ 
Additional information
PricingPaid with free features
Developer
Trader status unspecified
Privacy policy
Terms of service
ImportJSON | Import JSON data into Google Sheets will ask for the permissions shown below. Learn more
ImportJSON | Import JSON data into Google Sheets will need access to your Google account
This will allow ImportJSON | Import JSON data into Google Sheets to :
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Martin Le Cué
June 23, 2022
Une solution vraiment bien ! un outil vraiment efficace pour traduire des données JSON depuis n'importe quel API en tableur. je ne comprend pas pourquoi il n'y a pas plus d'outils de ce type et pourquoi celui-ci est si méconnu. bref, je recommande vivement !!
Is this review helpful?
Yes
No
Profile Picture
Jean-Philippe Cunniet
July 19, 2020
Loving it
Is this review helpful?
Yes
No
Profile Picture
Robert Riggs
January 30, 2022
Works very well. Very helpful with pulling stats from sports websites.
Is this review helpful?
Yes
No
Profile Picture
Jesse Kirkpatrick
October 12, 2020
Fantastic tool. Customer service top-notch as well.
Is this review helpful?
Yes
No
Profile Picture
Samson Assefa
December 7, 2020
Samson Assefa Gebrehiwot
Is this review helpful?
Yes
No
Profile Picture
A User of ImportJSON | Import JSON data into Google Sheets
April 22, 2020
I love the product. Is there a way to automate the update and reconnect function? I'm looking to record changes in data in a json.
Is this review helpful?
Yes
No
Profile Picture
A User of ImportJSON | Import JSON data into Google Sheets
April 24, 2020
This app works super well for grabbing API data in real time and tossing it on a Google Sheet. 5/5 for that. The level of support though... 10/5. This is a FREE product (currently), and the team behind it went to the ends of the earth to help diagnose an issue I was having with the function, which included looking at the individual api I was calling. Managing a digital agency, I've come across tons of levels of support for free and paid products on all price levels, and this has been one of the best. Thank you to Matt and his team!
Is this review helpful?
Yes
No
Profile Picture
A User of ImportJSON | Import JSON data into Google Sheets
March 29, 2020
The Addon does nor work :( It requires Activation, while the Activation option is not available - neither in the menu (as guided), not in the developer's website.
Is this review helpful?
Yes
No
Profile Picture
Braden Smeaton
October 10, 2021
This add-on is extremely useful and the developer's support is amazing. I am not very tech-savvy, but I was able to do exactly what I needed with this app after support from the owner. I highly recommend it.
Is this review helpful?
Yes
No
Profile Picture
A User of ImportJSON | Import JSON data into Google Sheets
April 14, 2020
Nice product and easy to use. Super fast responses to support requests.
Is this review helpful?
Yes
No
1-10 of 17
Search
Clear search
Close search
Google apps
Main menu