Fulfillment CSV
Comma-separated source file
| order_no | customer | ship_by |
|---|---|---|
| 000184 | Arden Labs | 2026-08-14 |
| 000185 | Kite Works | 2026-08-14 |
| 000186 | North & Co | 2026-08-15 |
CSV matching
Match two CSV exports without importing them into Excel first.
CSV files from different systems rarely arrive in the same column order. RowPair connects them using the field they share, keeps the main file’s row order, and adds the information you select.
- Match byOrder number
- AddPayment state and paid date
- GetThe fulfillment export enriched with payment information
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.
- Connecting exports from ecommerce, payment, CRM, or support tools
- Adding fields without changing the source CSV files
- Finding orders that are missing from another system
- Preserving text identifiers such as 000184
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.
Payments CSV
Different headings and order
| reference | paid_at | state |
|---|---|---|
| 000186 | 2026-08-11 | Paid |
| 000184 | 2026-08-10 | Paid |
| 000185 | Pending |
Matched CSV
Fulfillment order retained
| order_no | customer | state | paid_at |
|---|---|---|---|
| 000184 | Arden Labs | Paid | 2026-08-10 |
| 000185 | Kite Works | Pending | |
| 000186 | North & Co | Paid | 2026-08-11 |
Step by step
How to do it in RowPair.
- 01
Choose the main CSV
Start with the export whose rows and order should appear in the result.
- 02
Add the lookup CSV
The second file can use a different column order and a different heading for the shared identifier.
- 03
Connect the identifiers
For this example, connect order_no to reference and choose state and paid_at as the columns to add.
- 04
Check exceptions
Review blank identifiers, missing orders, and duplicate references before downloading the matched CSV.
Before you export
Checks that prevent a misleading merge.
Whitespace and letter case
RowPair can ignore surrounding spaces and capitalization so ORD-19 and ord-19 can match when that is appropriate.
Commas inside values
Properly quoted CSV values remain intact, including company names and addresses that contain commas.
CSV encoding
If accented characters look wrong in the preview, re-export the source as UTF-8 CSV before matching.
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