# Join two tables on a shared column

> Pick the key column in each table. The joined rows and the unmatched ones appear as you choose.

Merge two CSV or Excel tables on a key column, like VLOOKUP or XLOOKUP but without formulas. Keep matches, misses or both. Runs in your browser.

- Tool: [Join spreadsheets](https://fixmint.cc/join-spreadsheets)
- Category: [Spreadsheets & data](https://fixmint.cc/spreadsheets)
- Fixes: VLOOKUP keeps breaking
- Runs in the browser: files and text stay on the device, no sign-up, free.

## How to join two spreadsheets on a shared column

1. Drop or paste the left and the right table.
2. Pick the key column in each, and the join type you need.
3. Check the counts, then download the joined table as CSV or Excel.

## Questions

### What is the difference between the join types?

Keep all left rows keeps every row of the left table and adds the right columns where a match exists. Only matches keeps just the rows found in both. Everything keeps every row of both tables. Left rows with no match keeps only the left rows that found nothing on the right.

### What happens when a key appears twice on the right?

First match takes the first right row for that key. All matches adds one row for each right row, so a left row can appear more than once. The tool tells you how many keys repeat.

### Is my data uploaded?

No. Both tables are read and joined in your browser. Nothing is sent anywhere.

## Related tools

- [Compare spreadsheets](https://fixmint.cc/compare-spreadsheets): Spot what changed between files
- [Find table relationships](https://fixmint.cc/find-table-relationships): How do these tables connect?
- [Pivot table maker](https://fixmint.cc/pivot-table-maker): Totals by group, no Excel
- [Excel to CSV](https://fixmint.cc/excel-to-csv): Need CSV, have an Excel file