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
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.
More than 110,000 users already use this add-on!
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%
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
Parse in-cell JSONs
Filters are a powerful tool to navigate into the JSON and display only certain nodes.
Filtering
Automatic pivot
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
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
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
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
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
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
Parse in-cell JSONs
Filters are a powerful tool to navigate into the JSON and display only certain nodes.
Filtering
Automatic pivot
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
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
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
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
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