Anleitungen zum Zusammenführen und Bereinigen Ihrer Excel- und CSV-Dateien
Konkrete Methoden, um zwei Dateien abzugleichen, SVERWEIS zu ersetzen und Ihre Produktcodes unverändert zu lassen.
Methode
MethodeHow 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.Anleitung lesen →MethodeA 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.Anleitung lesen →
Tabellenproblem
Anwendungsfall
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.Anleitung lesen →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.Anleitung lesen →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.Anleitung lesen →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.Anleitung lesen →
Ihre nächste Katalogaktualisierung dauert zwei Minuten.
Mit meinen Dateien testen