Seamlessly import JSON data in Google Sheets that you can easily manipulate

Build complex, yet easy-to-analyze tables  from JSON data in Google Sheets, without coding experience
Add to Google Sheets for FREE

How it works

Download

the JSON add-on from the Google Workspace Marketplace.

Activate

this add-on in a new Google sheet.

Import and Filter

Import JSONs by selecting your source from text in a cell, a URL or a Google Drive document, then pivot the data to call and classify content into columns within your spreadsheet.

Add to Google Sheets for FREE

More than 85,000 users already use this add-on!

Top-notch customer service

matt November 16, 2021

Fantastic tool. Customer service top-notch as well.

Quick and easy to use

matt November 16, 2021

Quick and easy to use, and the support is very reactive on inquiries or issues you may have.

Function is smooth and flawless.

matt November 16, 2021

(…) Now I am able to import and process data directly from API’s. Function is smooth and flawless. Your prompt reply to my query is also worth to mention.

Excellent, you made scraping simple!

matt November 16, 2021

Excellent…struggle from months to import the data and you made it simple. Thank you.

Makes able to use JSON and APIs directly in Google Sheets.

matt November 16, 2021

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 (…)

I wish everyone provided this kind of customer service!

matt November 16, 2021

(…) I found ImportFromWeb is exactly what I needed (…) The developer is also very helpful, even with someone just using the basic account. I wish everyone provided this kind of service.

More reviews on Google Workspace

Discover ImportJSON
Features

  • Easily retrieve JSONS from any URL, Google Drive document with “view” rights or using a cURL request; it’s perfect for non-technical users.
  • Filter JSON objects using simple queries like (“parent/child/0”) within your spreadsheet.
  • Parse or analyze text directly from cells containing a JSON text, so that your formatted document can be easily made into a table with rows and columns.
  • Automatically pivot array elements in your table into columns without the need for coding
  • Set up ImportJSON to update automatically, so your table data refreshes even when you are offline
  • ImportJSON caches results to avoid repeated requests to APIs so your data is always updated correctly.
  • Expect nothing less than stellar customer service, we will ensure you get the best out of this add-on.

ImportJSON Pricing

Start for free with up to 5 requests per day. Then, if you need more volume, choose between our paid plans depending on your needs.

Purchase our annual plan and save 30%

Monthly

The function counts a request when it manages to fetch a JSON from the target url. For instance, if fetching the content fails or if there is no element in the JSON that matches the filters, no request will be counted.
The JSON is cached by default for 24 hours. Therefore, until the cache expires, using the same url in other IMPORTJSON functions will retrieve the cached JSON and these operations will not be counted as new requests.
Premium and High Volume plans offer the cacheLifespan option to customize the period during which the data is kept into the cache.That said, you can always choose to update the data by yourself by pushing “Update content” in the sidebar (Actions screen) or the menu.
Pages requests

As long as you call IMPORTJSON on a JSON that has been pasted in the spreadsheet, it does not consume any request.
Parse in-cell JSONs
Filters are added as the second parameter of the function.
Filters are a powerful tool to navigate into the JSON and display only certain nodes.
Filtering
Automatic pivot
Load up to 100 endpoints in the same function and compare key/values pairs on the same row
Compare several endpoints in once

Fetching the same content constantly is not efficient. That is why importjson caches the source code once loaded with the expected data.
By default, cache has a lifetime of 24 hours. Some plans allow to customize this value with the cacheLifespan option.

Caching occurs only when the content has been fetched successfully or after the function tried too many times and failed.

Smart caching

Your data is updated when the cache expires or when you manually choose to update it (for all the formulas in the selected cells, or for the entire spreadsheet)

Manual updates
Updates scheduling
Early access to new features
Support

FREE

5 / day

–

$ 0

/ month

FREE

5 / day

$ 0

/ month

START NOW

Includes: Rotating proxies, Array Formulas, Use of XPaths or CSS Selectors, Rendering JS Content, Stack Pages, 24h Cache lifespan, Manual Updates, Early access to new features.

Support answers can take up to 3 business days.

Standard
24h

Answering can take up
to 3 business days

BASIC

150 / day

1500 / month

$ 11

/ month

BASIC

150 Page requests / day

1500 Page requests / month

$ 11

/ month

SELECT PLAN

7-day money-back guarantee

Includes: Rotating proxies, Array Formulas, Use of XPaths or CSS Selectors, Rendering JS Content, Stack Pages, 24h Cache lifespan, Manual Updates, Early access to new features.

Support answers can take up to 3 business days.

Standard
24h

Answering can take up
to 3 business days

PREMIUM

1000 / day

10000 / month

$ 22

/ month

PREMIUM

1000 Page requests / day

10000 Page requests / month

$ 22

/ month

SELECT PLAN

7-day money-back guarantee

Includes: all Basic features + Custom Smart Caching up to 2 weeks, Update Scheduling by hour, day and week, Choice of locations for US, CA, DE, FR, ES, BR, MX, IN, JP, CN, AU.

Support answers can take up to 3 business days.

Custom
Up to 2 weeks

By hour, day, week

Answering can take up
to 3 business days

HIGH-VOLUME

4000 / day

40000 / month

$ 67

/ month

HIGH-VOLUME

4000 Page requests / day

40000 Page requests / month

$ 67

/ month

SELECT PLAN

7-day money-back guarantee

Includes: all Basic features + Custom Smart Caching up to 2 weeks, Update Scheduling by hour, day and week, Choice of locations for US, CA, DE, FR, ES, BR, MX, IN, JP, CN, AU.

Support answers in 24 hours on business days.

Custom
Up to 1 month

By hour, day, week

Answering can take up
to 24h on business days

Yearly

The function counts a request when it manages to fetch a JSON from the target url. For instance, if fetching the content fails or if there is no element in the JSON that matches the filters, no request will be counted.
The JSON is cached by default for 24 hours. Therefore, until the cache expires, using the same url in other IMPORTJSON functions will retrieve the cached JSON and these operations will not be counted as new requests.
Premium and High Volume plans offer the cacheLifespan option to customize the period during which the data is kept into the cache.That said, you can always choose to update the data by yourself by pushing “Update content” in the sidebar (Actions screen) or the menu.
Pages requests

As long as you call IMPORTJSON on a JSON that has been pasted in the spreadsheet, it does not consume any request.
Parse in-cell JSONs
Filters are added as the second parameter of the function.
Filters are a powerful tool to navigate into the JSON and display only certain nodes.
Filtering
Automatic pivot
Load up to 100 endpoints in the same function and compare key/values pairs on the same row
Compare several endpoints in once

Fetching the same content constantly is not efficient. That is why importjson caches the source code once loaded with the expected data.
By default, cache has a lifetime of 24 hours. Some plans allow to customize this value with the cacheLifespan option.

Caching occurs only when the content has been fetched successfully or after the function tried too many times and failed.

Smart caching

Your data is updated when the cache expires or when you manually choose to update it (for all the formulas in the selected cells, or for the entire spreadsheet)

Manual updates
Updates scheduling
Early access to new features
Support

FREE

5 / day

–

$ 0

/ year

FREE

5 / day

$ 0

/ month

START NOW

Includes: Rotating proxies, Array Formulas, Use of XPaths or CSS Selectors, Rendering JS Content, Stack Pages, 24h Cache lifespan, Manual Updates, Early access to new features.

Support answers can take up to 3 business days.

Standard
24h

Answering can take up
to 3 business days

BASIC

150 / day

1500 / month

$ 99

/ year

BASIC

150 Page requests / day

1500 Page requests / month

$ 99

/ year

SELECT PLAN

7-day money-back guarantee

Includes: Rotating proxies, Array Formulas, Use of XPaths or CSS Selectors, Rendering JS Content, Stack Pages, 24h Cache lifespan, Manual Updates, Early access to new features.

Support answers can take up to 3 business days.

Standard
24h

By hour, day, week

Answering can take up
to 3 business days

PREMIUM

1000 / day

10000 / month

$ 199

/ year

PREMIUM

1000 Page requests / day

10000 Page requests / month

$ 199

/ year

SELECT PLAN

7-day money-back guarantee

Includes: all Basic features + Custom Smart Caching up to 2 weeks, Update Scheduling by hour, day and week, Choice of locations for US, CA, DE, FR, ES, BR, MX, IN, JP, CN, AU.

Support answers can take up to 3 business days.

Custom
Up to 2 weeks

By hour, day, week

Answering can take up
to 3 business days

HIGH-VOLUME

4000 / day

40000 / month

$ 569

/ year

HIGH-VOLUME

4000 Page requests / day

40000 Page requests / month

$ 569

/ year

SELECT PLAN

7-day money-back guarantee

Includes: all Basic features + Custom Smart Caching up to 2 weeks, Update Scheduling by hour, day and week, Choice of locations for US, CA, DE, FR, ES, BR, MX, IN, JP, CN, AU.

Support answers in 24 hours on business days.

Custom
Up to 1 month

By hour, day, week

Answering can take up
to 24h on business days