# CSV Duplicate Checker

> Identify duplicate records in CSV files and visualize them in an interactive dashboard.

Automatically check CSV files for duplicate entries using n8n. This no-code workflow parses uploaded CSV data, detects duplicates based on a chosen key (like `serialNumber`) and displays structured results - including a full duplicate list and summary dashboard - directly in n8n.

- Area: n8n Automation
- Type: Free
- Category: Data Processing
- Source: https://www.sus-tech.com/en/solutions/csv-duplicate-checker

## n8n CSV Duplicate Checker with Dashboard

Easily detect duplicate records in your CSV files with this **n8n automation template**. It validates data integrity by scanning uploaded CSV data, marking duplicate entries and generating a clean dashboard view to review grouped duplicates and summary statistics.

### How it works
* The workflow receives a CSV file via an HTML form upload.  
* It converts the file into structured JSON records for analysis.  
* A custom **CSV Duplicate Finder** function checks for repeated values in a selected key column (e.g. `serialNumber`, `email` or `id`).  
* The output includes both a detailed duplicate list and a summarized count overview.  
* Results are visualized in the built-in **Duplicate Entries Dashboard** for quick inspection.

### Use cases
* Validate imported datasets before database entry.  
* Detect duplicate **serial numbers** in hardware or asset inventories.  
* Maintain clean datasets in reporting or automation pipelines.  

### How to use
1. Upload your CSV file using the input form.  
2. Select the **key column** to check for duplicates (e.g. `serialNumber`).  
3. Run the workflow - the **Dashboard** will display grouped duplicates and summary statistics automatically.  

### Requirements
* No external credentials required - runs entirely within **n8n**.  

### Screenshots
![n8n form of the CSV Duplicate Finder: upload a CSV file to check it for duplicate entries](https://www.sus-tech.com/media/1280/csv-duplicate-checker-1.png.webp)

![Second form step: choose the column to check for duplicates, here serialNumber](https://www.sus-tech.com/media/1280/csv-duplicate-checker-2.png.webp)

![Dashboard with the result: 100 records checked, 9 duplicate groups, 23 duplicate rows](https://www.sus-tech.com/media/1280/csv-duplicate-checker-3.png.webp)

## Contact

Consulting and implementation: https://www.sus-tech.com/en/contact