JSON.Mom wordmark

JSON.Mom

Simplify JSON API Integration in Your Spreadsheets

What

Spreadsheets are the ultimate Swiss Army knife of data management tools. Every app is ultimately competing with a spreadsheet in terms of flexibility and user adoption.

— JSON.Mom, Clean Your Room

Spreadsheets are powerful tools used in nearly every business. However, getting JSON data from internet APIs into spreadsheets can be tough without extra tools like plugins or custom scripts.

JSON.Mom makes it easy to add JSON data to your spreadsheets. You don't need plugins—just use our tool for seamless data retrieval from JSON APIs. This makes your work simpler and more efficient, boosting your productivity!

How

JSON.Mom provides a simple API endpoint compatible with Google Sheets' IMPORTDATA function and Microsoft Excel's WEBSERVICE function. Just input the desired API URL and the JSONPath of the data you wish to extract. It's that straightforward!

https://json.mom/p ?jm_key=JM_KEY &api_url=API_URL &json_path=JSONPath

Try it now and experience the simplicity of JSON Mom!

Power Up Your Spreadsheets
How To Videos

Quickstart

Go from sign up to using JSON.Mom in under a minute!

Real World Example

Build a T-Bill Ladder with JSON.Mom and the US Treasury's API

Changelog

6/18/24 — Fill Multiple Cells (Google Sheets Only)

  1. Use a comma separated list of JSONPaths in one IMPORTDATA call to bring in multiple values.

    E.g. IMPORTDATA(… & "&json_path=" & ENCODEURL("$.firstname, $.lastname"))

    animation showing multiple columns being filled with one `IMPORTDATA` call

  2. Default direction is "column" as the data goes across columns. Specify &direction=row for data to go across rows

    animation showing multiple rows being filled with one `IMPORTDATA` call
Implementation Details

Privacy

JSON.Mom cares about your privacy just as much as she cares for your JSON. She operates over HTTPS, ensuring your data is encrypted between your spreadsheet and our servers. She doesn't store any details about your requests or responses, and only logs the hostname of the API URL, never the full URL.

Refresh

With JSON.Mom, your spreadsheet data stays up-to-date. Google Sheets refreshes data imported through the IMPORTDATA function approximately every hour, ensuring your information remains current without manual intervention. For more details, you can refer to Google's support page.

If you need to force a refresh, you can change the formula or simply delete the cell and undo it to update the data immediately.

Rate Limits

JSON.Mom has tons of energy but not everyone can keep up with her. Keep rate limits of the underlying API in mind and be aware that Google Sheets limits you to 50 IMPORTDATA calls per sheet. Coefficient's guide has more details on these limitations.