explaingit

dbohdan/structured-text-tools

7,135Audience · developerComplexity · 1/5Setup · easy

TLDR

A curated directory of command-line tools for reading, filtering, converting, and querying structured text files in formats like CSV, JSON, YAML, XML, and TOML, a map to help you find the right tool without writing code.

Mindmap

mindmap
  root((repo))
    What it does
      Curated tool list
      Command-line tools
      Structured text formats
    Formats covered
      CSV and JSON
      YAML and XML
      TOML and Markdown
    Tool categories
      Query and filter
      Convert formats
      Interactive browsers
    Use Cases
      Find right CLI tool
      Process data files
      No-code wrangling
Click or tap to explore — scroll the page freely

Code map

Detail Auto

An interactive map of this repo's files and how they connect — its source is parsed live in your browser. Click Visualize to build it.

filefunction / class

Things people build with this

USE CASE 1

Find a command-line tool to run SQL queries against a CSV file without importing it into a database

USE CASE 2

Convert a JSON API response into a readable table in the terminal

USE CASE 3

Filter and transform a YAML config file from a shell script

USE CASE 4

Discover a multi-format converter to translate between JSON, YAML, and TOML in one step

Getting it running

Difficulty · easy Time to first run · 5min

In plain English

This repository is a curated directory of command-line tools for reading and transforming structured text files. If you work with data stored in formats like CSV, JSON, YAML, XML, Markdown, TOML, or plain tab-separated files, this list helps you find a tool that can slice, filter, convert, or query that data without writing a full program. The list is organized by format. Each section covers a category of text, starting with general awk-like tools that operate on any line-based data, then moving into format-specific entries. For CSV, for example, you will find tools that clean columns, join files on shared fields, generate fake test data, run SQL queries against spreadsheets, or convert a CSV into an HTML table. The JSON section covers formatters, query languages, and converters to other formats. Beyond the major formats, the list includes tools for .env files, /etc/hosts, INI files, log files, and several multi-format converters that can translate between a dozen formats in one step. There is also a section on templating tools that let you fill in structured data templates from the command line, and sections on interactive terminal UIs for browsing structured data and command-line interfaces for single-file databases like SQLite. Each entry is a brief description with a link to the project. The list does not go deep on any single tool, it is a starting point for discovery. If you need to process structured text on the command line and are not sure what tool exists for the job, this repository is a map of the options available across many formats and use cases. The full README is longer than what was shown.

Copy-paste prompts

Prompt 1
I have a CSV file with sales data and I want to filter rows where the amount is over 1000 and output a new CSV. What command-line tool from structured-text-tools should I use and show me the command.
Prompt 2
Using a tool from the structured-text-tools list, how do I query a JSON file to extract just the name field from every object in an array?
Prompt 3
I need to convert a YAML config file to TOML. What tool from the structured-text-tools list handles that and how do I run it?
Prompt 4
I want to join two CSV files on a shared ID column from the command line. What tool from structured-text-tools lets me do that and what is the basic command?
Prompt 5
I have a messy log file and want to extract structured fields from each line using an awk-like tool. Point me to the right section of structured-text-tools and show an example.
Open on GitHub → Explain another repo

← dbohdan on gitmyhub — every repo by this author, as a profile.

Verify against the repo before relying on details.