Go to example tasks
Ft Filter Csv Or Google Sheet By Url
Created by
Adam Pearce
Load a public CSV, Excel or Google Sheet by link, keep and rename the columns you need, map country codes to continent names, filter to two continents, sort and dedupe, then download the result as CSV and Excel. Uses the open country-codes dataset as a live example; swap in your own file link.
Dataset Filter & Transformnerolabs/dataset-filter-transform
Name
Email
Country
Revenue
+3 fieldsTextNumberBooleanListObject
Input
File URL (CSV, Excel, JSON or JSON Lines):https://raw.githubusercontent.com/datasets/country-codes/main/data/country-codes.csv
Transform steps (applied in order, before filtering)
op:keep+3
fields
Filter conditions (applied after transforms)
field:Continent
operator:in
value
Sort by:country
Keep one row per distinct value of:country
Export file formats:csv+1
Output fields
Name
Email
Country
Revenue
Active
Signup date
Summary
Sign up on Apify01
Create your Apify account to access the Dataset Filter & Transform.
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.
