Merge Two CSV Files Without VLOOKUP

Merging data from two files is the number one pain point for spreadsheet users. VLOOKUP is fragile, limited to exact left-column matches, and breaks when columns get rearranged. DataScrub lets you merge on any column with inner, left, right, or full outer join — like SQL, but visual and code-free.

How to Merge Two Files

1. Upload both files — drag and drop each file into its own drop zone.
2. Pick the matching column in each file — the columns that contain the same values to join on.
3. Choose a join type — inner, left, right, or full outer.
4. Preview the results — see a sample of merged rows before downloading.
5. Download — export the merged dataset as CSV, Excel, or JSON.

Join Types Explained

• Inner join — only rows where the join key matches in both files.
• Left join — all rows from the first file, plus matching rows from the second.
• Right join — all rows from the second file, plus matching rows from the first.
• Full outer join — all rows from both files, matched where possible.

When to Use Each Join Type

Use an inner join when you only want rows with exact matches in both files. A left join keeps every row from your main dataset and enriches it with data from the second file where available. A right join does the opposite — useful when the second file is your authoritative source. A full outer join combines everything, preserving all rows from both files.

Tips for Better Merges

• Make sure join columns have the same format — dates and numbers should match exactly.
• Watch out for leading and trailing spaces — they cause silent match failures.
• Use the Profiler first to check data quality in both files before merging.

Frequently Asked Questions