DoItAl

Data utility

CSV Merge & Join

Combine CSV files or match datasets by a shared column—privately in your browser.

Files are processed in your browser and are not uploaded to DoItAl.

1. Add files

Add up to 10 CSV, TSV, semicolon, or pipe-delimited files. Each file must have a header row.

Drop CSV or TSV files here

or choose files from this device

2. Choose how to merge

3. Review and preview

Nothing is silently discarded or overwritten.

Files

0

Input rows

0

Output rows

0

Output columns

0

Matching columns

0

Add data to see a bounded preview.

Need to clean duplicates, whitespace, or broken headers first? Open CSV Cleaner.

Continue with

Merge versus join

Merge puts rows from multiple similar files into one dataset. Join combines columns from two datasets using an identifier such as customer ID, email, or SKU.

Stack versus union

Stack follows the first file’s column list and maps later rows by header name. Union keeps the superset of every header and leaves values blank where a file does not contain that column. Union is the safer choice when schemas differ.

Left versus inner join

A left join keeps every row from Dataset A, even without a match. An inner join keeps only rows whose key exists in both datasets. Swap the datasets when you need the other file to define the retained rows.

Why duplicate keys add rows

When one key appears several times in both datasets, preserving every match creates every valid pair. Two rows matched to three rows produce six output rows. This tool estimates the output first, reports duplicate keys, and blocks joins above its browser safety limit.

Private, bounded processing

Files remain in this browser tab. V1 accepts up to 5 MB per file, 20 MB combined, and renders only the first 50 preview rows. Downloaded output includes every processed row.

What this tool does

Stacks or unions rows from similar files, or joins two datasets by a key to combine their columns.

How to use it

  1. Choose merge or join, then load the required CSV/TSV files.
  2. Select schema handling or the matching key and join type.
  3. Review duplicate-key warnings and output estimates before exporting.

Worked example

Joining two rows with key A to three rows with key A produces six matches when every pair is retained. A left join retains unmatched rows from Dataset A; an inner join excludes them.

Processing and explanation

Stack follows the first header list; union retains the superset of headers and fills missing cells with blanks. Join matches key values rather than relying on row positions.

Limits and common mistakes

5 MB per file, 20 MB combined, and 50 preview rows. Duplicate keys can multiply output size; the engine estimates expansion and blocks unsafe joins. Swap datasets when the other file should define retained rows.

Privacy and your input

Matching, merging and serialization run locally. Key values, headers, and file contents are not sent in analytics.

Frequently asked questions

Should I merge or join?
Merge adds records with similar fields. Join adds fields matched by an identifier.
Why did row count grow?
One-to-many or many-to-many keys can create several valid matches per source row.

Material content update: