CSV · Remove duplicates

CSV · Remove duplicates. Remove duplicates by the chosen key columns. With no keys, compare complete rows exactly.

Processed locally · Files stay on your device

Text and transformation

Runs in this browser

Result

Set the inputs and run the tool to view the result.

How to use CSV · Remove duplicates

Review the populated example and the input units, then replace it with your data.
Remove duplicates by the chosen key columns. With no keys, compare complete rows exactly.
Run the tool, inspect the result, then copy or download what you need.

Method and scope

Remove duplicates by the chosen key columns. With no keys, compare complete rows exactly.

Preserves data, not Excel macros, formula evaluation or styling. The first row is a header; names must be nonempty and unique. CSV export guards text beginning with = + - @ against formula injection. Prefer files below 20 MB.

Input example

Table data: SKU,Name,Quantity,Price
A01,Glass cup,100,12.5
A02,"Cup,Blue",80,15
A01,Glass cup,100,12.5
Column names / key columns (comma-separated): SKU

Questions and result checks

How does CSV · Remove duplicates determine the result?

Remove duplicates by the chosen key columns. With no keys, compare complete rows exactly.

What should I check before processing?

How can I verify the output?

Use the supplied example as a check, then compare important results with the original source or business document.

Table data: SKU,Name,Quantity,Price
A01,Glass cup,100,12.5
A02,"Cup,Blue",80,15
A01,Glass cup,100,12.5
Column names / key columns (comma-separated): SKU

Related tools

Excel & Tables

CSV · Remove empty rows

Use CSV · Remove empty rows on your input. Configure Table data and inspect the result before copying it.

Excel & Tables

CSV · Count empty cells

Use CSV · Count empty cells on your input. Configure Table data and inspect the result before copying it.

Excel & Tables

CSV · Filter

Use CSV · Filter on your input. Configure Table data, Column names / key columns (comma-separated), Text to include and inspect the result before copying it.

Excel & Tables

CSV · Date formatting

Use CSV · Date formatting on your input. Configure Table data, Column names / key columns (comma-separated) and inspect the result before copying it.

Excel & Tables

CSV · Number formatting

Use CSV · Number formatting on your input. Configure Table data, Column names / key columns (comma-separated), Row count / decimal places and inspect the result before copying it.

Excel & Tables

CSV · Detect column types

Use CSV · Detect column types on your input. Configure Table data and inspect the result before copying it.