CSV cleaner data profiler

Count empty cells, distinct values and duplicate rows in a CSV, then remove the repeated rows.

Privacy: runs in your browser

This tool processes your input in this browser. Inputs and results are excluded from analytics. Draft saving is optional and stays on this device; delete saved text with the draft controls. Loading text from a URL is optional and contacts that server; its URL and your IP address are visible to the server. When a button sends your result to another tool, it waits in this tab until that tool opens it, for up to a minute, and is then deleted.

Copy link includes the inputs you choose to share in the address. Anyone with that link can reopen them. Files and generated results are excluded. Password and key tools share settings only.

Options and local file

Optional settings apply only to this tab.

Your result

More
Keyboard shortcuts

Sharing and starting over

A copied link includes what you entered and your settings, so anyone with it can see them. Leave private text out. Files and results are not included; random draws are made again.

Start over puts the tool back to its starting values and closes any open file or device. Drafts you saved stay on this device until you delete them.

CSV cleaner data profiler explained

Profile a CSV before changing it: count empty cells, distinct text values and exact duplicate rows. The cleaning mode removes repeated rows in their original order, with an explicit option to trim surrounding whitespace.

Next: Spreadsheet compare

Next: CSV JSON converter

Worked example

Two rows containing 1 and an empty cell produce a duplicate-row count of 1. Clean mode retains the first row and keeps the empty cell.

Before you rely on the result

Quoted fields, embedded newlines and doubled quote characters are supported. Headers must be unique and every row must have the same number of fields. Cell values stay text, including leading zeros. Spreadsheet formulas are not evaluated. Distinct values are case-sensitive. This tool does not infer types, fill missing values or decide which conflicting business record is correct.

Cite this page

ToolOctopus. “CSV cleaner data profiler.” Updated . https://tooloctopus.com/csv-cleaner-data-profiler.

Add an access date if your instructions require one.

Citation formatting uses citeproc-js by Frank Bennett and Citation Style Language styles. License and source code.

Find a tool

Type a task, a unit pair, a sum or a time zone. ↓ to choose, Enter to open.