Main workbook
The rows you want to keep
| Customer ID | Customer | Region |
|---|---|---|
| AC-104 | Maya Chen | West |
| AC-105 | Sam Wright | North |
| AC-106 | Nora Singh | East |
Excel file merge
Merge two Excel files without copying rows or writing formulas.
Use one workbook as your main list, match it to a second workbook by a shared identifier, and bring across only the columns you need. RowPair shows uncertain matches before anything is downloaded.
- Match byCustomer ID
- AddAccount owner and renewal date
- GetOne customer list containing the selected account details
Ready-to-use example
Try this job with a small workbook first.
The workbook contains a Main file sheet, a Lookup file sheet, and the expected result. Upload it in both file slots and select the two source sheets when RowPair asks.
When this helps
A focused tool for a common spreadsheet job.
- Combining exports from two business systems
- Adding current details to an older workbook
- Replacing a one-off VLOOKUP or XLOOKUP task
- Checking missing and duplicate identifiers before delivery
Worked example
Two source files become one reviewable result.
The examples below show the fields that matter; your files can contain additional columns and use different column orders.
Lookup workbook
The details you want to add
| Customer ID | Account owner | Renewal |
|---|---|---|
| AC-104 | J. Ellis | 2026-10-01 |
| AC-105 | R. Lopez | 2026-11-14 |
| AC-106 | J. Ellis | 2027-01-20 |
Merged workbook
Original rows plus selected columns
| Customer ID | Customer | Owner | Renewal |
|---|---|---|---|
| AC-104 | Maya Chen | J. Ellis | 2026-10-01 |
| AC-105 | Sam Wright | R. Lopez | 2026-11-14 |
| AC-106 | Nora Singh | J. Ellis | 2027-01-20 |
Step by step
How to do it in RowPair.
- 01
Add both workbooks
Choose the workbook whose rows should remain first, then add the workbook containing the extra information.
- 02
Choose the shared column
Match Customer ID to Customer ID, even if the columns appear in different positions or use different headings.
- 03
Select columns to add
Bring across only the fields needed in the finished workbook instead of importing the entire lookup file.
- 04
Review and download
Check no-match and duplicate rows, resolve anything ambiguous, then export the clean result as Excel or CSV.
Before you export
Checks that prevent a misleading merge.
IDs with leading zeros
Store identifiers such as 00123 as text in both files. RowPair preserves text values and avoids silently turning them into 123.
Repeated lookup IDs
If one ID appears more than once in the lookup workbook, RowPair asks you to choose the intended row rather than guessing.
Different column names
The headings do not need to match. You can explicitly connect Customer No. in one file to Customer ID in the other.
Free · no account · local processing
Use the spreadsheets you already have.
Nothing is uploaded. Review the result in your browser, then download Excel or CSV.
Open the spreadsheet matcher