200K+ users on Google Marketplace

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.

Just type =IMPORTJSON() and unlock any API data

Smart features for more flexibility

Easily retrieve JSON

From any URL, Google Drive document, or advanced cURL requests.

Parse or analyze

Text directly from cells containing a JSON text.

Filter JSON

Using simple queries like (“parent/child”0”) whithin your spreadsheet.

Pivot data

That share similar properties

Set up

Hourly, daily or weekly automatic updates

Cross, manipulate and analyze JSON data with no coding skills

More than 200,000 users already use the ImportJSON add-on!

The best extension ever

Hats off to nodatanobusiness team, this has helped me be better at finding leads and improving research skills

Nighil M.

The client support answers within 24-hour period of time

As a relatively new client, I have to say that ImportFromWeb guys are amazing.

Timur M.

This is an awesome tool.

I used it to research hundreds of prospective customer companies. The people who made this tool are also great. They respond really well to support inquiries.

Jason G.

How it works


The JSON add-on from Google Workspace Marketplace


The JSON add-on from Google Workspace Marketplace

Import and filter

JSON from text in a cell, URL, Google Drive document, pivot data to a cell, classify content into columns within your spreadsheet.

ImportJSON Pricing




up to URLs / day

Select Plan

7 day money back guarantee

All ImportJSON features

Individual use

Self-serve knowledge base



up to URLs / day

Select Plan

7-day money back guarantee

All ImportJSON features

Collaboration features

Share drive compatible

Priority Email Support

30 minutes onboarding call


Request an enterprise-grade configuration

Contact us

All ImportJSON features

Multiple users

Shared drive compatible

Dedicated account Manager

Spreadsheets review & 1-on-1 training

Frequently Asked Questions

Can I try ImportJSON for free?

Absolutely! Actually, we offer a free plan with 5 requests / day. The function counts a request when it manages to fetch a JSON from the target url.

What is a request?

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.

That said, you can always choose to update the data by yourself by pushing “Update content” in the sidebar (Actions screen) or the menu.

Can I upgrade or downgrade my plan?

You can cancel, upgrade, or downgrade your plan anytime. All cancellations and downgrades will take place at the end of your plan cycle, while upgrades will take place immediately.

Contact us and just let us know the new plan you want to subscribe to. We’ll manage the switch for you.

How do I cancel my subscription?

You can decide to unsubscribe at any moment. At that point, your subscription will last until the end of the current billing cycle, which will depend on whether you chose yearly or monthly payments.

You can unsubscribe directly from your customer portal.

Alternatively, you can reach out to us here and we’ll manage it for you.