Supplier File Converter

Make the
columns match.

Turn your supplier CSV into Margin Guard’s cost format. Map the fields, inspect the problems, and download only the rows you approve.

This workspace is preparing its controls. If they remain unavailable, reload this page or Send a private message .

Fictional data. No file needed.

01 / Choose a file

Start with the source.

UTF-8 CSV, up to 500 data rows and 1 MiB. Choose the delimiter used by your file. Excel workbooks, PDFs, and currency conversion are not supported.

No file selected.

Future-dated rows need review.

Sample files contain fictional parts, including deliberate problems.
Download source CSV Companion prices CSV

Try a second fictional file with your saved mapping
  1. Finish the first sample with check date 2026-11-10. Review the ready and blocked rows, then download the approved cost CSV and any review record you want to keep. Give the mapping template a useful name, review it and download it separately.
  2. Download the second fictional supplier CSV. Choose it with Supplier CSV. Review and explicitly choose to reuse compatible current mapping, then apply; or apply the file without reuse, load your saved template, review its columns and constants, then apply the template. Keep the first task’s downloaded files: applying a replacement clears this tab’s old results and download links.
  3. Set Check dates as of to 2026-12-10 and validate again. Inspect 00123 with its new 110.00 cost and UNKNOWN-F with freight still unknown. Do not turn the blank into zero. Review the new result and approve only the ready row if appropriate before preparing a fresh cost CSV.

Both files are fictional. Only column choices and explicit constants can be reused; new amounts, dates, results and approvals must be checked. Nothing is uploaded or applied to an inventory system.

Choose a file or try the sample to see how the mapping works.

One defined destination

Built for a clear
cost record.

This converter prepares Margin Guard supplier-cost CSVs. It does not claim compatibility with other inventory or accounting importers.

Output format & validation rules
sku,unit,quantity,currency,cost,freight,fees,handling,tax_treatment,effective_date
  • SKU strings retain leading zeros. Duplicate SKUs are blocked.
  • Unit must be each or case; quantity is the positive whole-number pack size.
  • Currency must be USD and tax treatment excluded. Neither is inferred.
  • Cost, freight, fees, and handling use nonnegative decimal amounts with at most two decimal places.
  • Dates must be real YYYY-MM-DD dates, no later than the selected check date.
  • Ambiguous values and formula-like SKU prefixes are blocked.

Confirm pack sizes and allocations with your supplier before relying on a file. Changing column names does not establish the meaning of the amounts.