App Icon
Import any JSON data and convert it into an easy-to-read table. All through a simple function
Works with:
68,787
Overview
connect any JSON to your spreadsheet in seconds.
Just type =IMPORTJSON(your_json_source) and the JSON will be displayed in a 2 dimensions array.

Filter the resulting table to extract the information you need
=IMPORTJSON(your_json_source, "london/weather/monday")

As simple as it looks!

Try it out:
=IMPORTJSON(
        "https://api.chucknorris.io/jokes/random",
        "//value"
) 


ImportJSON accepts many sources to load the data:
- A range of the active spreadsheet
- A Drive file with "view" rights
- Any URL
- complex cUrl requests 

ImportJSON is smart enough to pivot data that shares similar properties:
It transforms multi level JSON objects into a 2 dimensions table when possible.

APIs are gold! There are APIs about anything.
With ImportJSON, anyone with NO-CODING SKILLS can unlock the huge quantity of data they provide

Examples (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

▶︎ Start for free with 5 requests per day ◀

Many users of importFromWeb, Supermetrics, SheetGo, Google Analytics, Autocrat and Power Tools already love our JSON importer!

Read more about it here https://nodatanobusiness.com/importjson/
Additional information
Privacy policy
Terms of service
ImportJSON | JSON to table from any sources will ask for the permissions shown below. Learn more
ImportJSON | JSON to table from any sources will need access to your Google account
This will allow ImportJSON | JSON to table from any sources 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:
Profile Picture
Jean-Philippe Cunniet
July 19, 2020
Loving it
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 | JSON to table from any sources
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 | JSON to table from any sources
May 25, 2020
Quick and easy to use, and the support is very reactive on inquiries or issues you may have. Thanks Guys Luca
Is this review helpful?
Yes
No
Profile Picture
A User of ImportJSON | JSON to table from any sources
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 | JSON to table from any sources
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
A User of ImportJSON | JSON to table from any sources
April 14, 2020
Nice product and easy to use. Super fast responses to support requests.
Is this review helpful?
Yes
No
Profile Picture
Luke Marut
November 25, 2020
This is a great product. Saved a lot of time. Quick support.
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 14
Search
Clear search
Close search
Google apps
Main menu