Import JSON data from any API and convert it into an easy-to-read table. All through a simple function!
Ultimo aggiornamento scheda:18 dicembre 2023
Compatibile con:
205.336+
Panoramica
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/ 
Informazioni aggiuntive
PrezziSenza costi con alcune funzionalitĂ  a pagamento
Norme sulla privacy
Termini di servizio
ImportJSON | Import JSON data into Google Sheets richiederĂ  le autorizzazioni mostrate di seguito. Scopri di piĂą
ImportJSON | Import JSON data into Google Sheets dovrĂ  poter accedere al tuo Account Google
Ciò consente all'app ImportJSON | Import JSON data into Google Sheets di
Visualizzare e gestire i fogli di lavoro in cui è stata installata questa applicazione
Visualizza e pubblica contenuti web di terze parti in messaggi e barre laterali all'interno delle applicazioni Google
Connettersi a un servizio esterno
Consentire l'esecuzione dell'applicazione in tua assenza
Visualizzare l'indirizzo email principale del tuo Account Google
Visualizzare le tue informazioni personali, incluse quelle che hai reso pubblicamente disponibili
Recensioni
Lingua:
Ordina per:
Google non verifica le recensioni né le valutazioni. Scopri di più sulle recensioni
Nessun commento
Ricerca
Cancella ricerca
Chiudi ricerca
App Google
Menu principale