UtilityShelf tools

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.

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.

Follow the supplier CSV walkthrough.