Donghao · Product tools

Get your product CSV into shape.

Merge exact duplicates. Flag missing fields and conflicting SKUs. Your data stays in this browser.

1. Paste your CSV

Save your spreadsheet as UTF-8 CSV, then paste its contents here. The sample contains 10 made-up product records.

2. Match the columns

Choose your SKU column. Select the other fields you want checked.

What gets cleaned?

Leading and trailing spaces are removed. Common units are standardized: pcs / each → piece, kilograms → kg, grams → g and boxes → box.

Rows that match after cleanup are merged. Different records with the same SKU stay separate and are flagged for review.

Selected price fields are checked for a nonnegative number, and stock for a whole number of zero or more. Missing values appear in the review report.

Try the sample to see one exact duplicate merged and five records flagged for review.

3. Review and download

In Excel, use Data → From Text/CSV and set the SKU column to Text to preserve leading zeros. CSV downloads mark formula-like values as text; the JSON download retains original source values.

Your cleaned records will appear here.

Want the finished file delivered?

$5 product-data cleanup · One Excel or CSV file, up to 500 rows, 10 columns and three agreed cleanup rules.

You get a cleaned file, an exception report and a rules summary. Two-day delivery and one revision.

View the Upwork package

Start with a 10-row sample with private details removed and your desired output format.