App Icon
Import JSON data from any API and convert it into an easy-to-read table. All through a simple function!
Listing updated:November 4, 2022
Works with:
99,535
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

Forever free up to 5 external requests per day (1 request = 1 JSON successfully fetched) and unlimited conversions of JSONs pasted in cells.
Then, choose between our plans according to the number of requests you need. No risk, we offer a 7-day money back guarantee !
https://nodatanobusiness.com/importjson/#pricing


📌 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
PricingFree of charge with paid features
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
Chris Lowe
January 19, 2023
Simple to use and really handy when trying to load data in from restful apis. Highly recommended
Is this review helpful?
Yes
No
Profile Picture
Peter Holowka
January 12, 2023
We use ImportJSON extensively in my institution's Computer Science courses. We use it to create predictive algorithms using NHL player and game data (the data is in JSON format). The tool works well and is easy enough for students to use with minimal guidance. It's clean and super intuitive. Also, the pricing model is well-structured so we only pay for what we need. I wholeheartedly recommend this, especially for educational institutions introducing learners to data science and computer science. Outstanding tool. Thank you.
Is this review helpful?
Yes
No
Profile Picture
mark mcewan
November 2, 2022
This is one of two add-ons i use in Google sheets and is the only one I pay for. Excellent Add-on to Google sheets. Been using ImportJSON for over a year and the support has been incredible. I can curate and organise data within minutes which would take me days without the add-on.
Is this review helpful?
Yes
No
Profile Picture
Jeff Bird
October 20, 2022
I use this to parse Google maps api data in Google sheets. It is very intuitive and easy to use. The toolbar on the right that pops up is very helpful. This is the best json parsing tool I've used.
Is this review helpful?
Yes
No
Profile Picture
Ella Ricker
January 1, 2023
keep getting error message. instructions not clear.
Is this review helpful?
Yes
No
Profile Picture
rono toga
November 4, 2022
Combining JSON with spreadsheet is genius. It saves us alot of time. So far I still use this plugin to analyze Instagram, and it saves plenty of time. But sometime it responses slower then usual, but overall, it's amazing
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
Dmytro Barbashov
December 15, 2021
Too slow - says "Working" and nothing happens
Is this review helpful?
Yes
No
Profile Picture
Erik Nilsson
September 3, 2020
Really cool add-on. Make us non-technical people able to utilize JSON and APIs directly in Google Sheets. Really quick support from Matt as well, where he actually sent me a fully functional Google Sheet with my required query in. 5 stars from here!
Is this review helpful?
Yes
No
Profile Picture
Bryce Christensen
November 18, 2020
Got it working, then it informed me that I had already reached my daily limit (5 uses). That info needs to be in the description so those of us trying it out know to skip if it isn't going to meet our needs. Instead, I have to go undo the last 10 minutes of changes to my sheet, and am therefore worse off than before I tried it.
Is this review helpful?
Yes
No
1-10 of 22
Search
Clear search
Close search
Google apps
Main menu