Merge Excel and CSV files online, no VLOOKUP needed.
Match your product catalog with a supplier feed or an ERP export on a shared reference. Keep the columns you need, clean up, export a ready-to-import file.
No sign-up · Free up to 2 files and 15,000 rows · Files never stored
| SKU | Product | Barcode | Cost | Supplier stock |
|---|---|---|---|---|
| REF-1042 | LED desk lamp | 0376012345690 | €18.40 | 137 |
| REF-1099 | Ergonomic chair | 0376012347212 | €96.00 | 24 |
| REF-1104 | XL mouse pad | 0376012349414 | €6.90 | 512 |
| REF-1187 | Dual monitor arm | 0376012350021 | €42.15 | 8 |
The problem you know by heart.
Every week a supplier sends stock and prices in a file that looks nothing like yours. And the spreadsheet damages your data.
- VLOOKUP returning #N/AOne extra space, a different format, and the match fails.
- Barcodes in scientific notation3.76E+12 instead of 0376012345690, and the zeros are gone.
- References turned into dates“03-01” silently becomes “1 March”.
- Files too heavyTens of thousands of rows and the spreadsheet freezes.
How to merge two Excel files in three steps
- 01
Drop your files
.xlsx, .xls, .xlsm, .ods, .csv, .tsv or .json, straight from your ERP or supplier.
- 02
Pick the shared column
SKU, reference or barcode, even when the column names differ.
- 03
Clean up and export
Reorder columns, filter, sort, drop empty rows. Export to CSV, Excel or TSV.
For teams who live in product files
E-commerce
Update your store's stock and prices from supplier feeds.
Update a catalog →Purchasing
Compare prices from several suppliers on the same references.
Compare prices →Marketplaces
Prepare a clean import file, with columns in the expected order.
Prepare an import →Logistics
Reconcile warehouse inventory with your ERP export to spot gaps.
Reconcile inventory →Simple pricing
Start for free. Go Pro when your files grow.
Pro
€149 / year
That's €12.42/month, billed once a year
- Unlimited files and rows
- Several files in one merge
- Export to CSV, Excel, TSV
- Cancel anytime
Frequently asked questions
How do I merge two Excel files without VLOOKUP?
Drop both files into DataMerge, pick the column they share, then export. No formula to write.
Are my files stored?
No. They are read in memory for the merge, then discarded.
My columns have different names. Does it still work?
Yes. You pick the column in each file: “SKU” on one side, “Supplier_Ref” on the other. DataMerge even suggests the right pair from the content.
Can I merge more than two files?
Yes, with Pro: as many files as you need, on the same reference, in a single merge.
Can I cancel anytime?
Yes, from your settings. Pro stays active until the end of the paid period.