Guides

Make JSON useful in Google Sheets.

Step-by-step walkthroughs built from the working add-on, with real endpoints, real screenshots, and the exact choices that produce a clean table.

A JSON response imported into five Google Sheets columns
Complete walkthrough · 8 min

How to import JSON into Google Sheets

Import a public URL, upload a local .json file, choose nested fields, and keep remote data fresh.

Read the guide →
A local JSON file imported into seven Google Sheets columns
Local file walkthrough · 6 min

How to upload a JSON file to Google Sheets

Download a sample .json file, preview nested data, choose useful columns, and write a clean local-file table.

Read the guide →
A JSON products API imported into six Google Sheets columns
API integration walkthrough · 8 min

How to connect a JSON API to Google Sheets

Configure a GET request, query parameters, authentication, root paths, pagination, and refresh behavior.

Read the guide →
A daily JSON API refresh enabled in the JSON for Sheets sidebar
Automation walkthrough · 9 min

How to automatically refresh JSON data in Google Sheets

Save a working API import, test it on demand, and schedule fresh hourly, daily, or weekly updates.

Read the guide →
A JSON API imported into a structured Google Sheets table
Comparison guide · 10 min

5 best IMPORTJSON alternatives for Google Sheets

Compare a visual add-on, open-source scripts, custom Apps Script, built-in import functions, and general API connectors.

Read the comparison →
An API key being saved as an encrypted connection in JSON for Sheets
Authentication walkthrough · 8 min

How to import JSON with an API key into Google Sheets

Save an encrypted API key, attach it to a request, preview the protected response, and write a safe table.

Read the guide →
JSON generated from a selected Google Sheets range
Export walkthrough · 7 min

How to export Google Sheets to JSON

Convert a selected range into objects, keyed records, or row arrays, then copy clean JSON for another system.

Read the guide →
Datos JSON importados como una tabla en Google Sheets
Guía en español · 8 min

Cómo importar JSON a Google Sheets

Importa una URL, una API o un archivo .json, selecciona campos anidados y escribe una tabla limpia.

Leer la guía →
Nested customer and shipping fields detected as dotted Google Sheets columns
Nested data tutorial · 8 min

How to flatten nested JSON in Google Sheets

Turn objects into dotted columns and choose whether arrays stay intact, join into one cell, or expand into rows.

Read the guide →
JSON parsed into detected fields and output rows in Google Sheets
Formula and parser guide · 9 min

How to parse JSON in Google Sheets

Extract values, query objects, inspect schemas, validate payloads, and spill JSON arrays into rows and columns.

Read the guide →