Standardize CSV column names from a public file URL
Created by
Stas Persiianenko
Fetch a public country code CSV file, normalize its schema, and validate required name and code fields.
CSV & Excel Data Quality Cleanerautomation-lab/csv-excel-data-quality-cleaner
Source row
Valid
Duplicate
Issues
+1 fieldTextNumberBooleanListObject
Input
CSV or XLSX file URL:https://datahub.io/core/country-list/_r/-/data.csv
File format:csv
Column conversion and validation rules
Input column(required):name+1
Data type:string+1
Required:true+1
Duplicate key columns:code
Duplicate action:remove
Maximum rows:250
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.
