Guides to merge and clean your Excel and CSV files
Practical methods to match two files, replace VLOOKUP and keep your product codes intact.
Method
MethodHow to merge two Excel files without VLOOKUPMatch two Excel files on a shared column in 3 steps, without formulas. Worked example, screenshots and pitfalls to avoid. Free up to 15,000 rows.Read the guide →MethodA VLOOKUP alternative to match your tablesVLOOKUP returns #N/A, breaks your barcodes and slows your files down? With concrete examples, here is how to match tables without formulas.Read the guide →
Spreadsheet problem
Use case
E-commerceUpdate your store's stock and prices from a supplier feedMatch your e-commerce catalog with your supplier's stock file on the barcode or SKU, without VLOOKUP. Free up to 15,000 rows.Read the guide →PurchasingCompare prices from several suppliers on the same referencesPut two or more suppliers' prices side by side on the same references, without VLOOKUP. Concrete example and a 3-step method.Read the guide →MarketplacesPrepare a marketplace import file from your exportsBring product data, prices and stock into a single file, with columns in the order the marketplace expects and barcodes intact.Read the guide →LogisticsReconcile warehouse inventory with ERP stockCompare your warehouse's physical count with your ERP export to spot gaps, uncounted items and items the ERP does not know.Read the guide →
Your next catalog update takes two minutes.
Try it with my files