CSV Cleaner

Exports from spreadsheets and CRMs often contain stray spaces, blank rows, duplicates and the wrong separator. Fix them without opening a spreadsheet, and keep the data on your device.

Open a CSV file

Or paste CSV

Input delimiter

Output delimiter

Trim cells Remove empty rows Remove duplicate rows Add UTF-8 BOM (for Excel)

Runs entirely in your browser. Your input and files are not uploaded to any server.

How to use

Open a CSV file or paste CSV text. The delimiter is detected automatically.
Choose the clean-ups you need.
Check the preview table and the summary.
Download the cleaned CSV with the delimiter you choose.

Examples

Semicolon CSV from Excel (Europe)

Detected “;” → output with “,” for tools that expect commas.

Common problems this tool fixes

CSV files exported from spreadsheets, CRMs and online shops often arrive with trailing spaces, empty rows, repeated records or a semicolon where your software expects a comma. Cleaning them first prevents failed imports and duplicate contacts.

Work on a copy of your data and read the summary and preview before you download. Then open the result in your spreadsheet program to confirm that names, dates and leading zeros look right, because spreadsheet programs can reformat values when they open a CSV.

Privacy

Your files and text stay in your browser while you use this tool, and ads or anonymous visit statistics do not receive them. Only your favorites and recent tools are saved on your device. Privacy policy

Want proof? Check it with your browser’s Network tab: How to check that a tool does not upload your files

Frequently asked questions

Are quoted fields with commas handled?

Yes. The parser follows RFC 4180: quoted fields can contain delimiters, quotes ("") and line breaks.

Is there a size limit?

Files up to 50 MB can be processed, but the preview shows only the first 100 rows.

Related tools

All Developer Tools

CSV ↔ JSON ConverterConvert CSV to JSON (array of objects or arrays) and JSON back to CSV.

Remove Duplicate LinesRemove duplicate lines from lists while keeping the original order.

Text CleanerClean messy text: remove extra spaces, line breaks, HTML tags, emoji, Arabic diacritics, invisible characters and smart quotes in one pass.

Line Counter & Line ToolsCount total, empty and unique lines, then add line numbers, sort alphabetically, reverse or shuffle lines.

SVG Preview & OptimizerPreview SVG files safely and shrink them by removing comments, editor metadata and whitespace, with optional number rounding.

Color Picker & ConverterPick a colour, convert between HEX, RGB and HSL, sample colours from an image or your screen, and check contrast against white and black text.