 # Convert Currency in Google Sheets (Easiest Way 2023)

4 Minutes In this article we will show you how to convert currency in Google Sheets in just a few clicks. Simply follow the steps below.

For the purpose of these demonstrations, an example data sheet was created. Click here to access the sheet and follow along at home.

## How to Convert Currency in Google Sheets

Click an empty cell in your sheet, this will be the cell where the conversion populates.

In our example below we have highlighted cell A6

### 2. Enter the formula =GOOGLEFINANCE("CURRENCY:<Currency Code 1><Currency Code 2>")

In the selected cell input the formula in the format of: =GOOGLEFINANCE("CURRENCY:<Currency Code 1><Currency Code 2>")

Formula Breakdown:

=GOOGLEFINANCE: This is the function that retrieves current as well as historical monetary information from Google Finance.

CURRENCY: Defines the following input data as currency

<Currency Code 1>: This will be the currency code of the currency to compare against.

<Currency Code 2>: This will be the currency code we are converting to. These must be input with no gaps.

See the list below for the codes for several popular currency:

Currency = Code

• US Dollar = USD
• Great British Pound = GBP
• Euro = EUR
• Hong Kong Dollar = HKD
• Japan Yen = JPY

In our example we will input the formula into cell and compare the US Dollar (USD) to the Great British Pound (GBP), therefore our example formula is:

### 3. Press Enter to populate the results

With the formula inputted, simply press the Enter key.

The formula will run and the currency result will populate.

In our example the currency conversion has been completed and the value of the US dollar (USD) to Great British Pound (GBP). The result is 0.83277 USD to GBP.

To convert a specific amount, click on a new cell.

In our example we have clicked B6 and input the same formula with the addition of *Value at the end after the bracket ‘)’. We will enter the number 100 as the example value.

Therefore our formula for this demonstration will be:    