Go to example tasks
Clean a CSV or Google Sheet by URL and Export to Excel
Created by
Adam Pearce
Load a public CSV, Excel, JSON file or Google Sheet by link (here the open ISO country-codes CSV on GitHub), keep only the columns you want, trim and normalise every field, deduplicate on a key, and download the result as CSV and Excel. Capped at 50 records so a test click costs about 12 cents; remove the cap for the full file. Swap in your own file or sheet link.
Dataset Cleaner & Exporternerolabs/dataset-cleaner-exporter
Company Name
Email
Phone
Website
+7 fieldsTextNumberBooleanListObject
Input
File URL (CSV, Excel, JSON or Google Sheet):https://raw.githubusercontent.com/datasets/country-codes/main/data/country-codes.csv
Deduplication mode:normalized
Deduplication keys:ISO3166-1-Alpha-2
Columns to keep:ISO3166-1-Alpha-2+6
Rename columns:ISO3166-1-Alpha-2:iso2+2
Export file formats:csv+1
Max output records:50
Output fields
Company Name
Email
Phone
Website
Bio
Founded
Active
HQ City
HQ State
Tags
Offers
Sign up on Apify01
Create your Apify account to access the Dataset Cleaner & Exporter.
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.
