Import JSON data from any API and convert it into an easy-to-read table. All through a simple function!
Informações atualizadas:18 de dezembro de 2023
Compatível com:
131 mil+
Visão geral
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 


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   


✓ 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 :  
- Weather:
- Countries meta:
- All Wikipedia:


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.


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 !


✓ Have a look at our repository of resources and demos at 
✓ 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 ! 


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 
Informações adicionais
PreçosSem custo financeiro com recursos pagos
Política de Privacidade
Termos de Serviço
O ImportJSON | Import JSON data into Google Sheets pedirá as permissões abaixo. Saiba mais
O ImportJSON | Import JSON data into Google Sheets precisará de acesso à sua Conta do Google
Isso permite que o ImportJSON | Import JSON data into Google Sheets faça o seguinte:
Ver e gerenciar planilhas nas quais este aplicativo foi instalado
Exiba e execute conteúdo da Web de terceiros em prompts e barras laterais dentro dos aplicativos do Google
Conectar a um serviço externo
Permitir que este aplicativo seja executado quando você não estiver presente
Ver o endereço de e-mail principal da sua Conta do Google
Ver suas informações pessoais, inclusive aquelas que você disponibilizou publicamente
Ordenar por:
O Google não verifica avaliações nem classificações. Saiba mais sobre as avaliações
Nenhum comentário
Limpar pesquisa
Fechar pesquisa
Google Apps
Menu principal