json-table ☆

« Back to VersTracker

Description:
Transform nested JSON data into tabular data in the shell

Type: Formula | Tracked Since: Dec 28, 2025

Links: Homepage | formulae.brew.sh

Category: Developer tools

Tags: json csv cli data-processing shell

Install: brew install json-table

About:
JsonTable is a command-line utility that transforms deeply nested JSON data into flat, CSV-like tabular formats. It uses a simple, SQL-like syntax to extract and reshape data, making it ideal for shell scripting and data processing pipelines. This tool simplifies the task of querying and manipulating JSON directly from the terminal.

Key Features:

Simple, SQL-like query syntax for data extraction
Handles nested JSON structures efficiently
Outputs data in clean, tabular formats (CSV, TSV)
Lightweight and fast, designed for command-line use

Use Cases:

Parsing API responses in shell scripts
Converting JSON logs to CSV for analysis in spreadsheets
Extracting specific values from configuration files for automation

Alternatives:

jq – jq is a more powerful and feature-rich tool for complex JSON manipulation, but has a steeper learning curve and a more verbose syntax.
dasel – Dasel is a modern alternative that supports multiple data formats (JSON, YAML, XML) and offers a similar goal of data selection and conversion.

Version History

Detected	Version	Rev	Change	Commit
Sep 14, 2024 10:26am		0	VERSION_BUMP	e0ab2ec0