Free online data tools
Merge Data from Two Files on a Shared Column
This is a VLOOKUP that does not break on large files. Pick a key column in each file and the tool joins the two datasets on it, and you choose which rows to keep. Column names are read from your files, so there is nothing to type and nothing to misspell.
Load your data
Choose your files, then select Load Data to get started.
Your files are processed locally in this tab.
Select one or more files.
Choose your options
File 1
Match rows using this column
The column both files have in common, such as an order number or an email address.
Which rows to keep
Not sure? "Only rows found in both files" is the usual choice.
File 2
Match rows using this column
The matching column in this file. It can have a different name.
Setting up…
Your file is processed inside this browser tab and is never uploaded.
Frequently asked questions
Which option should I pick for rows?
Most people want "Only rows found in both files". Pick "Every row from file 1" when file 1 is your main list and file 2 only adds extra details.
Can the matching columns have different names?
Yes. Pick the column in file 1 and the column in file 2 separately. Only the values have to match, not the names.
Can I match on more than one column?
Yes. Tick the same number of columns in each file, in the order they should be paired.
Other free tools
- Combine Data — Combine data from multiple files or Excel sheets into a single file.
- Split Data — Split one file into separate files or Excel sheets based on a column value.
- Compare Data — Compare data from two different files and see exactly what changed.
- Change File Format — Convert data between csv, xlsx, xls, json and html.