Nutter Tools
Nutter Tools

A free toolbox that runs in your browser. A tool for every job.

Your files never leave your device

Images

  • Convert images
  • Compress images
  • Resize images
  • Crop
  • Watermark

PDF & files

  • Merge PDFs
  • Split a PDF
  • Images to PDF
  • PDF to images
  • Remove photo location

Video & audio

  • Compress video
  • Convert video
  • Video to GIF
  • Convert audio
  • Trim audio

Everyday

  • QR codes
  • Passwords
  • Time zones
  • Unit converter
  • Word count
  • Webcam test

Developer

  • JSON formatter
  • Base64
  • Regex tester
  • Hashes
  • JWT decoder

Site

  • About
  • Contact
  • Settings
  • Privacy
  • Terms
  • Site map
  • llms.txt

Everyday

  • Images
  • Video
  • Audio
  • PDF & files
  • Text
  • QR codes
  • Units & math
  • Time & dates
  • Color
  • Passwords & IDs
  • Device tests
  • Sun & moon

For developers

  • JSON
  • Encoding
  • Regex & cron
  • Web & auth
  • Hashing & encryption
  • Config files
  • Network
  • Browser
  • AI
  • Fake data
© Nutter Toolsnutter.tools
  1. Home
  2. Fake data
  3. CSV join and merge planner
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.

This tool is in beta

Still being tested. If a result looks wrong, tell us.

Report a problem

File A

0 characters

File B

0 characters

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.

Join setup

Join type
DelimiterApplies to both files; detect reads each one
More settings▾
optional
optional

A second key makes the join composite: both parts must match. Set both fields or clear both.

Off compares keys exactly as pasted
Off treats Ann and ann as different keys

Up to 2,000,000 characters and 100,000 data rows per file,500,000 rows in the merged output, 1,000 in the unmatched preview.

Runs on this device. Nothing is uploaded.

More fake data tools

  • CSV studio
  • CSV → SQL
  • Cohort retention analyzer
All fake data tools

Was this tool useful?