Data preparation
CSV Column Mapper
Match supplier columns to a destination template. Reorder and rename fields, preview the result, and download the mapped CSV.
Source and destination
Enter both headers to begin.
Reuse a saved mapping
Open or paste the current CSV first, then load your saved mapping to restore the destination headings, column choices, required-field choices, duplicate-check settings and numeric rules. Review the choices before building the export.
Mapping files are read locally (up to 64 KiB). Reordered columns are matched by exact header name. Added, missing or renamed headers require a new mapping; case and spaces must match.
Choose source columns
Each destination column needs a selection. Select “Use empty values” only when your importer accepts a blank column. Source columns you leave unused are excluded.
Tick Required value for each destination column that must contain a value, then build the CSV. Empty and whitespace-only values are flagged; 0 and 0.00 count as present. These checks do not change the CSV. Required choices start off for a new setup, source CSV, destination header or sample. Save mapping includes these choices; Load mapping restores them for each destination column, even when source columns have moved. Older version 1 files load with all required choices off. Review them before building.
Price and stock formats
Choose a Numeric rule only for columns you want to validate. Price accepts non-negative digits and an optional dot decimal, with digits on both sides (for example 0, 0.00 or 12.50). Stock accepts non-negative whole-number digits, including 0; 2.0 and 2.5 are both flagged. Signs (including -0 and +1), currency symbols, grouping separators, decimal commas and exponent notation are not accepted. Outer whitespace is ignored only for validation; internal spaces are not allowed.
Blank and whitespace-only cells are skipped by numeric rules; tick Required value if the column must be populated. No values are rounded, filled or rewritten. These checks do not verify currency, maximum amounts, decimal precision or actual stock availability. Rules save with mappings and restore by destination column. Older mappings start with numeric rules off; a new setup, source CSV, destination header or sample resets them.
Duplicate comparison options
Tick Check duplicates for SKU or another destination column. Each selected column is checked separately. Both options start off: comparisons are exact and case-sensitive. Ignoring whitespace trims only the ends for comparison; internal spaces stay significant. Values remain text, so 0012 and 12 are different. Blank and whitespace-only cells are skipped; use Required value to flag them. No rows or values are edited or removed.
Save mapping includes duplicate selections and both options. Load mapping restores them for destination columns even if source columns move. Older mappings start with duplicate checks off. A new setup, source CSV, destination header or sample resets these settings.
Choose every destination column to save a mapping. Reusable mappings require distinct, nonblank source headers. The downloaded JSON contains headers, column choices, required-field, duplicate and numeric rules, not data rows. Keep it on your device and review its headings before sharing.
Mapped CSV
Problem rows
One entry per failed check, ordered by data row then destination column. All rows are checked; the first 100 issues are shown. Values below are JSON-quoted so blanks, spaces and line breaks are distinguishable; previews longer than 200 characters are shortened. Values stay in your browser and are omitted from the mapping report. This view does not edit, remove or filter rows from the downloaded CSV.
| Row and lines | Column mapping | Value preview | Reason |
|---|
Required-field checks
Review flagged values before importing. Downloads stay available so you can save and correct the mapped file. Data rows exclude the header; CSV records include it. Source and mapped CSV line numbers mark the start of each record, allowing for multiline fields. All rows are checked; up to 100 findings are listed here and in the report. Presence checks do not validate prices or your importer's other rules; use Duplicate checks below for selected-column uniqueness.
Duplicate checks
Findings include every occurrence, including the first, with data-row, CSV-record and source/mapped line locations. Each group is identified by its first data row within that destination column. Up to 100 occurrences appear here and in the report; totals cover all rows. Downloads remain available for review and correction.
Price and stock checks
Findings identify data rows, CSV records, destination columns and source/mapped start lines without copying cell contents. All rows are checked; up to 100 numeric findings are listed here and in the report. Downloads stay available so you can review and correct a copy.
Mapping summary
| Destination | Source | Change |
|---|
Omitted source columns
Review omissions and empty-value choices against your import template. Counts exclude the header. Inserted blank cells count only columns set to Use empty values, not existing blanks in your source.
The report records column choices, row counts, selected required-field results, duplicate findings and numeric-rule results for this export. It includes headings and issue locations but no product-row contents; review headings before sharing. It does not certify formula safety or importer acceptance. Changing the source, destination, mapping or check settings clears the report and export until you build again.
Try a supplier feed
The example sends Stock code to SKU, Supplier title to Title and Unit cost to Price. The supplier’s internal note drops out. A code such as 0012 retains its leading zeros in the file; choose a text column when opening it in a spreadsheet.
Paste the exact headings from your destination’s own template. The tool checks field counts, quoting and the presence of values in the destination columns you mark required. Importer-specific rules still need review. Formula-like input values are preserved. Check formula prefixes before sharing an export.
Next: check the mapped file
Download the full mapped CSV above. Open that downloaded file in CSV Formula Checker to review formula-like values, then run CSV Import Checker on the same export before importing it.
If the source has duplicate headers or uneven rows, check the original CSV first. Each tool reads the file you choose; files do not move between tools automatically.