---
title: Convert currency
description: Convert monetary values from one currency to another using ISO currency codes.
category: Data Transformation
tags: [currency, conversion, iso, exchange rate, financial]
---

# Convert currency

## Description

The **Convert Currency** activity transforms amount values from one currency to another using up-to-date exchange rates. Input values must follow the ISO 4217 format (e.g., `100.00 USD`). You can convert to a target currency and store the result in a separate column.

Use this activity to:

- Normalize all transaction values to a single currency (e.g., INR, USD).
- Prepare financial reports by standardizing currency across global datasets.
- Retain or discard original columns based on your analysis needs.

> **Use case**: Convert international salaries (in USD, EUR, GBP, etc.) to INR before budgeting or taxation processing.

## Input

| Input Type | Required | Description                                                                                                        |
| ---------- | -------- | ------------------------------------------------------------------------------------------------------------------ |
| **Data**   | Required | Input data must contain at least one column with values in `amount + currency code` format (e.g., `12000.00 USD`). |

## Output

| Output Type | Format | Description                                     |
| ----------- | ------ | ----------------------------------------------- |
| **Data**    | JSON   | Transformed data with converted currency values |

## Configuration Fields

| Field Name           | Description                                                                          |
| -------------------- | ------------------------------------------------------------------------------------ |
| **Column Name**      | Select the column containing values like `12000.00 USD`.                             |
| **Output Column**    | Name of the column where the converted values will be stored.                        |
| **Convert To**       | The ISO currency code to convert all values into (e.g., `INR`, `USD`, etc.).         |
| **Include Original** | If true, retains all original columns. If false, only includes the converted output. |

## Sample Input

| employee_id | name          | amount_in_iso |
| ----------- | ------------- | ------------- |
| E001        | John Doe      | 20000.00 USD  |
| E002        | Marie Dupont  | 35000.00 EUR  |
| E003        | Carlos Gómez  | 30000.00 GBP  |
| E004        | Ravi Patel    | 120000.00 INR |
| E005        | Sophie Müller | 50000.00 JPY  |

## Sample Configuration

| Field              | Value           |
| ------------------ | --------------- |
| `Column Name`      | `amount_in_iso` |
| `Output Column`    | `INR`           |
| `Convert To`       | `INR`           |
| `Include Original` | `true`          |

<!-- ![Convert Currency](convert-currency-img.png) -->

## Sample Output

| employee_id | name          | amount_in_iso | INR            |
| ----------- | ------------- | ------------- | -------------- |
| E001        | John Doe      | 20000.00 USD  | 1727369.00 INR |
| E002        | Marie Dupont  | 35000.00 EUR  | 3167388.86 INR |
| E003        | Carlos Gómez  | 30000.00 GBP  | 3226744.82 INR |
| E004        | Ravi Patel    | 120000.00 INR | 120000.00 INR  |
| E005        | Sophie Müller | 50000.00 JPY  | 27718.43 INR   |