How to use this office tool
- Choose the required spreadsheet files.
- Select the sheet and review the header-row setting.
- Run the tool and inspect the bounded preview.
- Download the newly generated result file.
#091 · Merge Split & Organize Tool
Join Excel Files by Key Column
Join two Excel or delimited files on a shared key without sending either file to a server. Choose the key column, join type, and download a new workbook.
Office File Tool
Two local filesrow
rows
Ad space
What this tool does
This tool matches rows from two files by a selected key column, keeps duplicate matches visible, and writes the joined records to a new XLSX workbook.
Each normalized key from the second file is indexed, then matched against the first file according to the selected inner or left join mode.
Key matching is exact after optional whitespace trimming. Different capitalization and number formatting remain distinct.
Supported formats
Use XLSX, XLS, CSV, or TSV files. Select exactly two files. The first sheet of each workbook is used; formulas are read as their cached values.
| Format | Support |
|---|---|
| XLSX / XLS | Browser parsing; advanced Excel features may not be preserved |
| CSV / TSV | Delimited values with local parsing |
Tips for better results
- Use a stable ID rather than a person’s name as the key.
- Check for duplicate keys before joining; duplicates can create several output rows.
- Keep identifiers as text when leading zeros matter.
FAQ
Can I join two Excel files using an ID column?
Yes. Select two files and choose a column present in both files; every matching ID is combined into a new row.
What happens when the key appears more than once?
The tool returns every matching combination so duplicate keys remain visible instead of being silently discarded.
Can I keep rows that do not match the second file?
Yes. Choose a left join to retain every row from the first file and leave unmatched second-file fields blank.
Are formulas recalculated during the join?
No. Formula cells are read using available workbook values; this browser tool does not reproduce Excel’s calculation engine.
Does the join upload my workbooks?
No. Parsing, matching, and export happen locally in your browser.
Related office tools
Processing details
| Check | Behavior |
|---|---|
| Privacy | Local browser processing |
| Preview | Limited rows and columns |
| Output | New file generated |
Browse more office tools
Office tool hubsSpreadsheet ConversionConvert Excel, CSV, JSON, HTML, and other table formats.View all
Spreadsheet CleanupRemove duplicates, blanks, extra spaces, and inconsistent values.View all
Merge Split & OrganizeCombine, divide, extract, and arrange workbooks and sheets.View all
CSV & Delimited FilesView, edit, clean, validate, and convert delimited data files.View all