CSV Rescue Kit Help

Quick start

1. Open index.html in your browser.
2. Click Choose CSV file.
3. Turn options on or off depending on what mess you inherited.
4. Click Clean CSV.
5. Click Download cleaned CSV.

What the options do

• Trim whitespace — removes accidental spaces around values.
• Remove empty rows — drops blank lines that clutter exports.
• Dedupe rows — removes repeated records.
• Normalize line endings — smooths out Windows/Mac/Linux newline weirdness.
• Normalize headers — turns headers into cleaner machine-friendly names.
• Dedupe by selected columns — use this when full rows differ but the key identity fields are the same.
• Keep only selected columns — export a smaller file with only the fields you want.

Best first moves

• For contact lists: load the contacts sample and use the contacts preset.
• For product exports: load the products sample and use the product preset.
• If duplicates are not exact matches, use selected-column dedupe on IDs, SKUs, emails, or names.

Troubleshooting

• If the file looks strange after cleanup, reload the original and try fewer options.
• If dedupe removes too much, switch from full-row dedupe to selected-column dedupe.
• If columns disappear, check whether Keep only selected columns is enabled.
• If the CSV is extremely exotic, this tool may not handle every edge case yet. It is a lightweight rescue kit, not a NASA parser.

Privacy

Your file stays local in your browser. CSV Rescue Kit does not need a server to do the cleanup.