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.
Review sample mapping01 / 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
Choose a file or try the sample to see how the mapping works.
Apply this replacement?
Mapping choices
02 / Match the fields
One explicit choice per column.
Choose a source column or enter a constant you know applies to every row. Missing information stays missing. Enter 0 for an allocation only when it is known to be zero.
Inspect the source file
First 8 data rows, with original physical line numbers. No values have been changed.
On your next visit, load the new supplier CSV first, then this template. Review its constants and check date before validating again.
Use 1–60 letters, numbers, spaces, hyphens or underscores. Start with a letter or number; leave out the extension. We add .json.
Keep column choices and constants in your own file. Templates do not save source rows, the check date, results or approvals. Renaming this download does not rename files you already saved.
What this template keeps
Column names and constants may contain business information. Review every value before downloading or sharing. No source rows or approvals are included.
Inspect the exact template file
03 / Inspect the result
Every row has a reason.
Correct a problem without starting over
Inspect the row’s original values and its mapping. For a wrong column or constant, change that mapping and validate again. For a wrong source value, correct a copy of your original CSV and select it above. When all mapped columns still exist, you can explicitly reuse the current choices before applying the corrected file. Review constants and the check date again; matching headers alone do not establish meaning.
Applying a correction clears previous results and approvals. Unknown costs stay blocked until you have the missing information. You can keep the row-review CSV while following up with your supplier.
Ask for help in a separate private message. Choose what to describe in the form; this tool attaches no files or results. Submission is confirmed only when the form receives a stored receipt. A request does not authorize paid work, publication or a deadline.
No rows match this filter.
Conversion record & file checksum
04 / Approve & download
Keep the decision yours.
The optional conversion review includes the entire original CSV, mapping, row evidence, and prepared cost CSV. Keep it private. It is a review record, not a file for restoring this workspace or importing into Margin Guard.
CSV preserves SKU text. In spreadsheets, import the SKU column as Text to retain leading zeros. The row-review CSV is for human review; spreadsheet behavior can vary.
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.