Clean a recurring invoice CSV before analytics
Created by
Stas Persiianenko
Coerce invoice totals and dates, enforce status rules, remove duplicate invoices, and export a validation report.
CSV & Excel Data Quality Cleanerautomation-lab/csv-excel-data-quality-cleaner
Source row
Valid
Duplicate
Issues
+1 fieldTextNumberBooleanListObject
Input
Inline CSV:Invoice ID,Customer,Total,Issued At,Status
INV-1001,Acme North,1499.95,2026-07-01,paid
INV-1001,Acme North,1499.95,2026-07-01,paid
INV-1002,Example Retail,-25,2026-07-04,pending
INV-1003,Sample Studio,850,bad-date,unknown
Column conversion and validation rules
Input column(required):invoice_id+3
Data type:string+3
Required:true+3
Duplicate key columns:invoice_id
Duplicate action:remove
Maximum rows:1000
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.
