Join Excel tables
Match product codes or member IDs to bring columns from a lookup table into your main table. Review matched and unmatched rows.
Output XLSXChoose filesProcessed on your device
Choose files to select sheets and columns.
Results contain values stored as text cells. Formatting and formula recalculation are not supported.
Example
Add prices and categories to an order table using a product code. Missing products leave the lookup columns blank.
Supported features and limits
- All rows from the main table are kept. Empty keys do not match.
- Rows found only in the lookup table are not added. Keys use exact text matching by default.
- Values are saved as text cells. Original formatting, macros, charts, and formula recalculation are not supported. Each sheet supports up to 50,000 rows, 200 columns, and 1 million cells; selected input files support up to 2 million cells in total.
Frequently asked questions
Will my original files change?
No. The tool creates new result files. Review the downloaded results before using them.
Are my files uploaded?
Selected files are processed in your browser. File contents and filenames are not sent to a server. Aggregate tool-use counts are collected as described in the privacy notice.