Skip to content
AldeaCode Logo
For data work 13 curated tools 100% local

The data toolbox.
Tabular friendly.

Thirteen utilities for shaping, cleaning and inspecting data. CSV, JSON, SQL, PDF page counts, Base64 assets, columns, dedupe, sorts. All local, all built for batches, no upload.

Spreadsheet exports never leave your tab.

Most data wrangling tasks are small: extract one column, dedupe, sort, convert to JSON. The thirteen tools below cover most of those quick jobs, no notebook or CLI required. Paste, transform, copy. Done.

The data essentials

13 tools
01
Format

CSV ↔ JSON Converter

Bidirectional CSV to JSON with quoted-field support. Inspect a spreadsheet export as a JSON array, or build a CSV from API output.

02
Format

JSON Formatter and Validator

Pretty-print or minify JSON with custom indent. Validates as you type and surfaces the parser error position.

03
Basic text

Delimited Column Extractor

Pull a single column out of CSV / TSV / pipe-delimited text. Configurable delimiter, optional trim, missing cells become empty strings.

04
Basic text

Merge Text Lines

Zip 2 or 3 parallel lists into one delimited table. Useful when columns were exported separately.

05
Basic text

Sort Text Lines

Alphabetical or numeric sort with optional dedupe. Numeric mode handles "item-2" vs "item-10" the way you want.

06
Basic text

Remove Duplicate Lines

Strip duplicate rows while preserving order. Optional case-insensitive and trim before compare for messy data.

07
Numeration

Sequential Number List Generator

Generate sequential IDs with prefix, suffix and zero-padding. Build TST-001 through TST-1000 in one click.

08
Combinations

Combination Generator

Cartesian product of up to 4 lists with size guard. Useful for keyword expansion, attribute combinations, mock data.

09
Basic text

Remove Empty Lines

Strip blank lines from a CSV or TXT export, with optional treatment of whitespace-only lines as empty.

10
Basic text

Remove Extra Spaces

Normalise whitespace before joining or comparing rows. Four modes: leading, trailing, collapse runs, strip all.

11
Format

PDF Page Counter

Drop one or many PDFs and get the page count of each plus the total. Reads the PDF in your browser, never uploads anything.

12
Format

Image to Base64 Converter

Convert any image to a Base64 data URI, raw string, CSS or <img> tag. Useful for embedding assets in email templates or test data.

13
Format

SQL Formatter

Format SQL across 12 dialects (PostgreSQL, MySQL, BigQuery, Snowflake, ...). Picks keyword case, indent and lines between queries.

Pipeline workflows

Spreadsheet to API payload

Export your sheet as CSV, paste into CSV to JSON, copy the JSON array, paste into JSON Formatter to verify, ready to POST.

csv-json-converter json-formatter

Email column extraction

Paste a contact dump, run Column Extractor pointing at the email column, then Remove Duplicates. Clean list ready for import.

column-extractor remove-duplicates

Test data builder

Combine attribute lists with Combination Generator (size, color, region), feed to JSON via CSV to JSON, prepend Sequential Number IDs in JSON.

combination-generator sequential-number-list csv-json-converter
See all 45 tools →