Clean CSV data and flag duplicate customer rows
Created by
Stas Persiianenko
Normalize CSV headers, types, dates, and email validation while flagging duplicate customer records.
CSV & Excel Data Quality Cleanerautomation-lab/csv-excel-data-quality-cleaner
Source row
Valid
Duplicate
Issues
+1 fieldTextNumberBooleanListObject
Input
Inline CSV:Customer ID, Full Name ,Email,Amount,Order Date
C-001, Alice Smith ,alice@acme.com,1250.50,2026-08-01
C-001,Alice Smith,alice@acme.com,1250.50,2026-08-01
C-002, Bob Jones ,not-an-email,-5,invalid-date
Column conversion and validation rules
Input column(required):email+2
Data type:string+2
Required:true+2
Regular expression:^[^@\s]+@[^@\s]+\.[^@\s]+$
Duplicate key columns:customer_id+1
Duplicate action:flag
Maximum rows:100
Output fields
Source row
Valid
Duplicate
Issues
Validation findings
Sign up on Apify01
Create your Apify account to access the CSV & Excel Data Quality Cleaner.
Start the run02
The Actor will start running based on the input automatically.
Receive the output03
Monitor the progress in real-time. You will be notified as soon as your dataset is complete and ready for review.
Integrate into your workflow04
The final output is delivered in JSON, CSV, or Excel format, ready to be plugged into your workflow.
