Tool 08

CSV Product Cleaner

Upload a supplier product export. This tool trims whitespace, removes empty columns, formats prices to two decimals, and gives you a clean CSV to download and import.

Upload your CSV

Your file is processed entirely in your browser using PapaParse — it is never uploaded to any server.

What "cleaning" a supplier CSV actually fixes

Exports from supplier platforms often carry inconsistent whitespace, empty tracking columns, and prices stored as text with currency symbols attached — all of which cause failed or garbled imports into Shopify. This tool trims every text field, strips fully empty columns, and normalizes any column that looks like a price into a plain two-decimal number.

Step-by-step usage guide

  1. Export your product list from your supplier as a CSV file.
  2. Upload it above — the tool reads it locally and shows a quick summary of rows and columns.
  3. Click Download cleaned CSV to save the processed file, then import it into Shopify via Products → Import.

Frequently asked questions

Does this map columns to Shopify's exact import format?

No — it cleans formatting issues (whitespace, empty columns, price formatting) but doesn't rename columns to Shopify's schema. You may still need to rename headers like "Title" or "Variant Price" to match Shopify's import template.

Is my file uploaded anywhere?

No — parsing happens with a client-side JavaScript library in your browser tab. The file never leaves your device.

Always review the cleaned file before importing — this tool does not guarantee compatibility with every platform's import format. See our disclaimer.

Related tools