Back to News
datajsontoolscsv

Data Tools: JSONPath Tester, JSON to CSV, Markdown Tables and Line Sorter

Four tools for transforming and querying structured data — query JSON with expressions, export to CSV, build markdown tables visually and process text line by line.

Friday, June 12, 20262 min read4 views

Data Transformation Tools

JSONPath Tester

The JSONPath Tester evaluates JSONPath expressions against any JSON in real time. Type $.store.books[?(@.price>40)] and see every matching value highlighted with its exact path. Supports dot notation, bracket notation, wildcards, array slices, recursive descent (..) and filter expressions. Ten example expressions are built in — click any to test against the sample immediately.

JSON to CSV Converter

The JSON to CSV Converter accepts any JSON array and produces a downloadable CSV file. It auto-detects column headers from object keys, handles nested objects by flattening them (a.b.c becomes a.b.c column), and supports comma, tab, semicolon and pipe delimiters. A table preview shows the first 20 rows before you download.

Markdown Table Generator

The Markdown Table Generator is a visual spreadsheet editor that outputs GitHub Flavored Markdown table syntax. Click headers to rename them, click cells to edit values, set per-column alignment (left, center, right) and add or remove rows and columns. A live preview renders the final table exactly as it will appear on GitHub or in your documentation.

Line Sorter and Deduplicator

The Line Sorter handles bulk text line operations: A-Z sort, Z-A sort, sort by length, reverse order, random shuffle, remove duplicate lines (case-sensitive or insensitive), trim whitespace, remove empty lines and add line numbers. Essential for processing CSV exports, log files, configuration lists and anything line-based.