VLOOKUP two CSV files: add a column from another file

Created by

Michael Costa

Actor

Join Datasets: VLOOKUP & Merge Two Datasets or CSV Files

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.

Try for free

Join Datasets: VLOOKUP & Merge Two Datasets or CSV Fileshumble-echidna/dataset-join

Country

Currency

Units per USD (2025-12-31)

A year earlier

+2 fields

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

How it works

Sign up on Apify or log in

The Join Datasets: VLOOKUP & Merge Two Datasets or CSV Files Actor is ready to run with the inputs already set for "VLOOKUP two CSV files: add a column from another file". Sign up or log in and you'll land in Apify Console with a copy of this exact task.

Start the "VLOOKUP two CSV files: add a column from another file" task

The Join Datasets: VLOOKUP & Merge Two Datasets or CSV Files Actor will start running based on the input automatically. You can also change all the input fields, like or: main data file url (csv, json, jsonl or excel), or: lookup data file url, and more, to match your specific use case.

Receive the "VLOOKUP two CSV files: add a column from another file" output

Monitor the progress in real time. You will be notified as soon as your dataset is complete and ready for review. Each result includes data such as country, currency, units per usd (2025-12-31), and more.

Integrate into your workflow

The final output is delivered in JSON, CSV, or Excel format, ready to be plugged into your workflow. You can also run the "VLOOKUP two CSV files: add a column from another file" task via API.