Go to example tasks
VLOOKUP two CSV files: add a column from another file
Join two tables by a key column like VLOOKUP: each row of the main file gets the matching row's fields from the lookup file, renamed as you like. Works on CSV, JSON, Excel and Apify datasets. Here: exchange rates with last year's rate added.
Join Datasets: VLOOKUP & Merge Two Datasets or CSV Fileshumble-echidna/dataset-join
Country
Currency
Units per USD (2025-12-31)
A year earlier
+2 fieldsTextNumberBooleanListObject
Input
Or: main data file URL (CSV, JSON, JSONL or Excel):https://api.fiscaldata.treasury.gov/services/api/fiscal_service/v1/accounting/od/rates_of_exchange?format=csv&filter=record_date:eq:2025-12-31&page[size]=300
Or: lookup data file URL:https://api.fiscaldata.treasury.gov/services/api/fiscal_service/v1/accounting/od/rates_of_exchange?format=csv&filter=record_date:eq:2024-12-31&page[size]=300
Join on (the field that links them)(required):country_currency_desc
Lookup fields to add (and rename):exchange_rate -> rateAYearEarlier+1
Output fields
Country
Currency
Units per USD (2025-12-31)
A year earlier
Earlier rate's date
Matched
Sign up on Apify01
Create your Apify account to access the Join Datasets: VLOOKUP & Merge Two Datasets or CSV Files.
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.
