Match Excel rows and add columns
Preparing the tool…
What this tool supports
- Choose a main sheet and a reference sheet. They can come from different files or different worksheets in the same file.
- Map 1–3 match columns, choose 1–8 reference columns to return, and name the new columns.
- Review matched, unmatched, ambiguous, and invalid records. Download the main rows with new columns or the check report.
Data results contain every main-table row, the new columns, and match statuses. The main-table row count stays unchanged. The check report includes duplicate reference candidates, unmatched records, and issue sources.
Use regular .xlsx tables with headers in the first row. Hidden rows are included; entirely blank rows are skipped. Saved formula results are used without recalculation. Output files are new workbooks and do not preserve source formulas or formatting.
.xlsx only, with headers in the first row. Up to 10 MiB per file and 30 MiB in total. Up to 10,000 rows and 50 columns per sheet, with 1 million input cells in total. Exports have a separate 1 million cell limit, including source references and issue sheets. Processing time depends on your device.
Text “001”, text “1”, and numeric 1 are different values. Date text is not automatically converted to a date. Integers with an absolute value of at least 10¹⁵ in match columns are flagged for possible precision loss; lost digits cannot be recovered.
Some output cells contain errors or missing formula results. Review the issues and fix the input before downloading data results. The check report is available.
What happens if there are several candidates or no match?
Every main-table row is kept. New fields are left blank for unmatched or ambiguous records, with a distinct status; the tool does not silently choose the first candidate. Invalid returned values show their reference source. Existing main-table fields stay unchanged.
Are my files uploaded or saved between visits?
Duplicate checking, combining sheets, and adding columns also run locally. Downloads are new files; source files are unchanged. These tools do not save cloud files or task history. Leaving will clear the current files and results. Make sure you have downloaded what you need.
Page visits and fixed tool actions may be collected when analytics is enabled. Spreadsheet contents and results are not attached. A download action means the browser generated the file and triggered a download; it does not confirm that the file was saved to disk.
Read the privacy details