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.

Privacy

Runs entirely in your browser. Your input and files are not uploaded to any server. See the privacy policy for what is stored in your browser (favorites and history only). Privacy policy

Check it yourself: open your browser’s developer tools, select the Network tab and use the tool. Your file never appears in an upload request. Once this page is saved for offline use, you can also disconnect from the internet and keep working. Ads and anonymous visit statistics, when enabled, make their own requests, but they never receive your files or text.

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.