Different products collapse into one SKU
Aggressive compacting can remove separators that your catalog uses to distinguish variants.
Use compact mode only when your SKU convention allows it, and review a sample before copying the cleaned list.
Use this tool
Prepare the input and run the tool
Paste one SKU per line. Result: Copy or download the cleaned SKU list.
Ready.
Cleaned SKUs appear here.
Data handling: Files and pasted data are processed in this browser session.
Tool guide
How to use SKU List Cleaner
Use this when SKUs come from emails, supplier sheets, or copied tables with inconsistent formatting. Compact mode helps catch the same SKU written in different ways.
What this tool does
Paste SKUs, normalize spacing and case, remove duplicates, and copy the cleaned list.
- Input
- Paste one SKU per line
- Output
- Copy or download the cleaned SKU list
Tool advantages
- Runs in this page; the file or pasted data is not sent to a new app.
- Keeps the preview, report, and download in the same screen.
- Leaves you with an output you can copy, download, or check before using.
Step-by-step usage guide
- 1Paste the SKU list.
- 2Choose case and compact settings.
- 3Copy or download the cleaned list.
Common errors and fixes
Duplicate SKUs remain after cleaning
Some duplicates differ by hidden characters or supplier prefixes that need a business rule.
Trim and normalize first, then run the duplicate finder for a dedicated repeated-value report.
Leading zeros are lost later
Spreadsheet apps can treat cleaned SKUs as numbers after you paste or import them.
Import SKU columns as text in the destination app when leading zeros are meaningful.
When to use SKU List Cleaner
- You are checking files before an upload, import, share, or delivery.
- You want to confirm the result before sending it to another system.
- You need a copied result, downloaded file, or report that can be reviewed outside the page.
FAQ
What does compact mode do?
It removes spaces and hyphens before deduping, useful when the same SKU appears in different formats.
Can I preserve lowercase SKUs?
Yes. Choose Preserve case before cleaning.