Keep the leading zeros
- Inputs
- A SKU is entered as 000123 and Trim is enabled.
- Output
- The output identifier is 000123.
Text cells in the XLSX export preserve those zeros.
SKU data cleaner
Open CSV, TSV or the first sheet of an XLSX file. Trim identifier spaces, review duplicates and blanks, and export text-safe XLSX or CSV locally.
Free to useNo signupMade for daily work
SKU data cleaner
Keep source rows visible while you review spaces, blanks and duplicates.
Synthetic example. XLSX: first worksheet only. Up to 2,000 rows, 64 columns and 5 MB; data stays local.
Headers: Any headers; select the identifier column below.
Other columns stay unchanged. XLSX export uses text cells. CSV must be imported with identifier columns set to Text; numbers already rounded by Excel cannot be recovered.
Current results
Swipe the table sideways to see all columns.
Useful? Share this tool.
Share the tool address. Your entered values are not included.
How this tool works
Only selected identifier transformations are applied. Keep all is the default; blank identifiers remain visible. Explicit Keep first removes later matching identifiers but does not merge their other data.
Files and privacy
Where is my data processed?
On this device. The tool does not upload your data or synchronize inventory. Exports contain values only. Scan lists and results are not stored after you leave.
What if I edit an input?
Calculated outputs, printing and exports become unavailable until you rebuild the result, so a stale result is not exported.
Worked example
Illustrative inputs and outputs to help you check your own task.
Review collisions before removing
- Inputs
- Two rows normalize to SKU-A. Keep all is selected.
- Output
- Both rows remain and are marked Duplicate identifier.
Only the explicit Keep first option removes later duplicates.
Your work stays yours.
These tools run in your browser. They do not upload your entries or store them after you leave. Downloads are created on your device. Hosting providers may process standard access logs.