The data toolbox.
Tabular friendly.
Ten utilities for shaping, cleaning and inspecting tabular text. CSV, JSON, columns, dedupe, sorts. All local, all bulk-friendly, no upload.
Spreadsheet exports never leave your tab.Most data plumbing problems are tiny: extract one column, dedupe, sort, convert to JSON. The ten tools below cover the bulk of those small ops without firing up a notebook or a CLI. Paste, transform, copy. Done.
The data essentials
10 toolsCSV ↔ JSON Converter
Bidirectional CSV ↔ JSON with quoted-field support. Inspect a spreadsheet export as a JSON array, or build a CSV from API output.
JSON Formatter and Validator
Pretty-print or minify JSON with custom indent. Validates as you type and surfaces the parser error position.
Delimited Column Extractor
Pull a single column out of CSV / TSV / pipe-delimited text. Configurable delimiter, optional trim, missing cells become empty strings.
Merge Text Lines
Zip 2 or 3 parallel lists into one delimited table. Useful when columns were exported separately.
Sort Text Lines
Alphabetical or numeric sort with optional dedupe. Numeric mode handles "item-2" vs "item-10" the way you want.
Remove Duplicate Lines
Strip duplicate rows while preserving order. Optional case-insensitive and trim before compare for messy data.
Sequential Number List Generator
Generate sequential IDs with prefix, suffix and zero-padding. Build TST-001 through TST-1000 in one click.
Combination Generator
Cartesian product of up to 4 lists with size guard. Useful for keyword expansion, attribute combinations, mock data.
Remove Empty Lines
Strip blank lines from a CSV or TXT export, with optional treatment of whitespace-only lines as empty.
Remove Extra Spaces
Normalise whitespace before joining or comparing rows. Four modes: leading, trailing, collapse runs, strip all.
Pipeline workflows
Spreadsheet to API payload
Export your sheet as CSV, paste into CSV ↔ JSON, copy the JSON array, paste into JSON Formatter to verify, ready to POST.
Email column extraction
Paste a contact dump, run Column Extractor pointing at the email column, then Remove Duplicates. Clean list ready for import.
Test fixture builder
Combine attribute lists with Combination Generator (size, color, region), feed to JSON via CSV ↔ JSON, prepend Sequential Number IDs in JSON.