Empower Your Spreadsheets
JSON for Sheets brings the power of structural data parsing directly into your spreadsheet cells. Work with API data, config files, and complex JSON logs without leaving your workflow.
Check on Marketplace (Coming Soon)Key Features
PARSE_JSON
Convert JSON strings into readable, flattened 2D tables or key-value maps instantly.
JSON_GET
Extract specific values using intuitive dot and bracket notation
(e.g., user.address.city).
JSON_TO_TABLE
Transform arrays of objects into structured tables with headers automatically.
JSON_FILTER
Filter JSON arrays using simple expressions like
age > 21 directly in your formula.
JSON_VALIDATE
Validate your JSON data against a schema to ensure data integrity.
Secure Processing
All data processing happens locally within your Google Sheets execution environment.