Your files stay on your device

CSV join and merge planner

Join two CSV files on a key like a SQL join, previewing key quality, relation and exact row counts for all four join types before running the merge.

Paste or drop two CSVs, pick the key columns, and press Plan and merge.

This tool is a planner and a merge, not a database. Both files are read in this tab and compared key to key after your trim and case options. The forecast numbers are exact row counts, not estimates: a shared key with three rows in A and two in B contributes six rows, empty key cells match nothing the way SQL treats NULL, and the merged CSV can be larger than both inputs when keys repeat. The output keeps every column of file A, appends the non-key columns of file B with a (B) suffix on name clashes, backfills B's key into A's key column for B-only rows, and emits matched rows first in A order. It does no fuzzy matching, no deduplication, and no type casting: cells move over as text, exactly as pasted. Both files need a header row. Nothing is uploaded.
OptionsPlan and merge

More fake data tools

- CSV studio (/config/csv)
- CSV → SQL (/config/csv-to-sql)
- Cohort retention analyzer (/data/cohort-retention-analyzer)
All fake data tools (/data)

Was this tool useful?
YesNo

Canonical HTML: https://nutter.tools/data/csv-join-merge-planner
Markdown version: https://nutter.tools/data/csv-join-merge-planner.md
Plain-text version: https://nutter.tools/data/csv-join-merge-planner.txt
Agent index: https://nutter.tools/llms.txt