CSV Tools CSV Tools

Remove Duplicates

Find and eliminate duplicate rows

CSV Input

Options

Compare by

CSV Output

Deduplicated CSV will appear here...

More Options

CSV Format

Input

Output

Keep

How to Use This Tool

This tool finds and removes duplicate rows from your CSV. You can compare entire rows or choose specific columns to check for duplicates. It runs directly in your browser, so your data is never uploaded anywhere.

The Options panel shows a summary of how many duplicates were found and how many unique rows remain, similar to Excel’s remove duplicates feature.

  1. Provide your CSV — Paste CSV text into the input area, drop a CSV file onto the File tab, or enter a URL on the URL tab.
  2. Choose how to compare — Use “Entire Row” to match rows that are completely identical, or “Select Columns” to match based on specific columns only.
  3. Get your output — Copy the deduplicated CSV to your clipboard or save it as a .csv file.

FAQ

4 questions
Does this tool upload my data?
No. It runs entirely in your browser using JavaScript. Your CSV data is never sent to a server.
Can I compare specific columns instead of the whole row?
Yes. Switch to 'Select Columns' mode and choose which columns to use for finding duplicates. For example, you might want to find rows with the same email address even if other fields differ.
Which duplicate gets kept?
By default, the first occurrence is kept and later duplicates are removed. You can change this to keep the last occurrence instead in the More Options panel.
How do I know how many duplicates were found?
The Options panel shows a summary below the compare settings, telling you exactly how many duplicate rows were found and how many unique rows remain.

More Row Operations Tools

9 tools

Sample Rows

Pick a random sample of rows from your CSV

First N Rows

Extract the first N rows from your CSV

Last N Rows

Extract the last N rows from your CSV

Slice Rows

Extract a range of rows by start and end position

Add Row Numbers

Add a sequential row number column to your CSV

Reverse Rows

Reverse the order of rows in your CSV

Shuffle Rows

Randomly reorder all rows in your CSV

Filter Rows

Soon

Keep only rows that match your criteria

Sort CSV

Soon

Sort rows by any column, ascending or descending

More CSV Tools

47 tools

CSV to JSON

Convert CSV files to clean, structured JSON

Sample Rows

Pick a random sample of rows from your CSV

CSV to SQL

Generate SQL INSERT statements from CSV data

First N Rows

Extract the first N rows from your CSV

CSV to XML

Transform CSV into well-formed XML documents

Last N Rows

Extract the last N rows from your CSV

Slice Rows

Extract a range of rows by start and end position

Add Row Numbers

Add a sequential row number column to your CSV

CSV to JSON Lines

Convert CSV rows into newline-delimited JSON (JSONL/NDJSON)

CSV to YAML

Transform CSV data into clean, readable YAML documents

Reverse Rows

Reverse the order of rows in your CSV

CSV to TSV

Convert comma-separated values to tab-separated format

Shuffle Rows

Randomly reorder all rows in your CSV

CSV to HTML

Generate HTML tables from CSV data for easy web embedding

CSV to Markdown

Convert CSV data into GitHub-flavored Markdown tables

CSV to YNAB

Convert CSV bank statements into YNAB-compatible import format

CSV to Fixed Width

Convert CSV data into fixed-width column format

CSV Viewer

Soon

View and explore CSV files in a sortable table

Filter Rows

Soon

Keep only rows that match your criteria

Merge CSVs

Soon

Combine multiple CSV files into one

Column Stats

Soon

Get min, max, mean, and distribution per column

JSON to CSV

Soon

Convert JSON arrays to downloadable CSV

Sort CSV

Soon

Sort rows by any column, ascending or descending

Split CSV

Soon

Break large CSVs into smaller chunks

CSV Editor

Soon

Edit cells, add rows, and fix data inline

CSV to Excel

Soon

Export CSV data to .xlsx spreadsheets

Data Profiler

Soon

Automatic data type detection and quality report

Excel to CSV

Soon

Import .xlsx files and convert to CSV

Row Counter

Soon

Quick count of rows, columns, and empty cells

TSV to JSON

Soon

Convert tab-separated data into structured JSON output

CSV to QBO

Soon

Convert CSV bank transactions into QuickBooks Online format

CSV to vCard

Soon

Transform CSV contact lists into vCard (.vcf) files

CSV to QIF

Soon

Convert CSV financial data into Quicken Interchange Format

CSV to VCF

Soon

Export CSV contacts as VCF files for email and phone import

CSV to TXT

Soon

Convert CSV data into plain text with customizable formatting

CSV to IIF

Soon

Convert CSV transactions into Intuit Interchange Format for QuickBooks

CSV to KML

Soon

Generate KML geographic data files from CSV coordinates

CSV to Base64

Soon

Encode CSV data as a Base64 string for safe transport

CSV to SPSS

Soon

Convert CSV datasets into SPSS-compatible format for statistical analysis

CSV to SAS

Soon

Transform CSV data into SAS dataset format

CSV to Stata

Soon

Convert CSV data into Stata .dta format for econometric analysis

CSV to ORC

Soon

Convert CSV into Optimized Row Columnar format for big data

CSV to Feather

Soon

Convert CSV into Apache Arrow Feather format for fast analytics

CSV to Parquet

Soon

Convert CSV into columnar Parquet format for efficient storage

CSV to LaTeX

Soon

Generate LaTeX table markup from CSV data

CSV to Xero

Soon

Convert CSV bank statements into Xero-compatible import format

CSV to OFX

Soon

Convert CSV financial data into Open Financial Exchange format