How Do I Change Currency in Google Sheets from Pounds to Dollars?

You can also change the currency format that you are using gin Google Sheets.Here’s how to change currency in Google Sheets: Highlight the cells you wish to change Tap the Format > Number Click Custom currencies. Select the desired currency. In this case, we’ll choose dollars. Click Apply. This works for Euros or any other world currency and certain crypto coins.

Is There Any Delay When GOOGLEFINANCE Fetches Values?

The Google Sheets exchange rate delay can be up to 20 minutes for the current exchange values.

Google Sheets Currency Conversion: The Easy Method

In this tutorial, I will show you how to perform Google Sheets currency conversion. My process uses the GOOGLEFINANCE function.

Below, I’ll cover each aspect of Google Sheets currency conversion. I include detailed examples with practical tips. Please follow along below.

Table of Contents

What is the GOOGLEFINANCE Function

Working with finances can get really tricky, especially with exchange rates which are constantly changing. Luckily, Google Sheets has a convenient function called GOOGLEFINANCE, meant specifically for doing financial calculations.

This is what I use for currency conversion.

The GOOGLEFINANCE function fetches real-time or historical currency information and exchange rates from the Google finance website. This saves you both the time and energy it would take to import the exchange rates from another source.

Using GOOGLEFINANCE to Convert Currency in Google Sheets

The GOOGLEFINANCE function is the perfect currency converter Google Sheets tool that fetches currency conversion rates in real-time (well almost in real-time).

You don’t need to search endless databases for the current exchange rates. All you need is the correct formula for this powerful currency converter for Google Sheets. The formula uses currency symbols to track which currency you are changing from and to.

Syntax of the GOOGLEFINANCE Function

So what makes up the currency converter function in Google Sheets? I’ll share the basic syntax of the GOOGLEFINANCE function for currency conversion here:

=GOOGLEFINANCE(“CURRENCY:<source_currency_symbol><target_currency_symbol>”)

Note that this is different than the other common syntax for GOOGLEFINANCE. This function also commonly pulls stock information. The syntax for that looks like this:

=GOOGLEFINANCE(ticker, [attribute])

So, let’s break down that currency converter function a little further.

If you’re familiar with functions in Google Sheets, you’ll understand that this contains two important aspects. You’ll need to enter these to get the currency converter to work. Fortunately, it’s pretty easy to enter the information you’ll want to pull from Google Finance. Here’s what you’ll need to input:

source_currency_symbol is a three-letter code for the currency you want to convert from.
target_currency_symbol is a three-letter code for the currency you want to convert to.

As promised, I’ll provide a real-world example. Say we want to convert US Dollars to Rupees. In that case, I would write the function:

=GOOGLEFINANCE("CURRENCY:USDINR")

Notice that there is no space between the two currency codes. That’s a common mistake, and it’s easily avoided.

Three-Letter Currency Codes in Google Finance

If you want to convert to other currencies, you’ll need to know the codes. Just like I used in the above example, I would swap out the three-letter code for the currencies I want to convert.

Here are some other most common GOOGLEFINANCE currency codes:

Currency	Code
US Dollar	USD
Japan Yen	JPY
Canada Dollar	CAD
Indian Rupee	INR
Iran Rial	IRR
Russia Ruble	RUB
Euro	EUR
Singapore Dollar	SGD
Hong Kong Dollar	HKD
United Kingdom Pound	GBP

How to Use GOOGLEFINANCE for Real-Time Currency Conversion

Ready for another practical example? I have screenshots below to show how to convert dollars into three other currencies. I included the currencies in column B. Note that I’m using this format to convert currencies in column A to those in column B:

Here’s how to convert currency in Google Sheets to get the exchange rate of dollars to the three currencies in column B:

Select the first cell of the column where you want the results to appear (C2).
Type the formula:
```
=GOOGLEFINANCE(“CURRENCY:USDINR”)
```
Press the return key.

You should see the current exchange rate for the conversion of USD to INR in cell C2.

Alternately, you could even include references to cells in the function, by combining them with the ampersand operator, as follows: =GOOGLEFINANCE(“CURRENCY:”&A2&B2)
Press the return key.
Double-click on the fill handle of cell C2 to copy the formula to the rest of the cells of column C.

You should now see conversion rates for USD to all three currencies shown in the sheet.

Note: The Google finance currency codes are the same as the shorthand codes on the international currency exchanges.

How to Convert USD to INR Using GOOGLEFINANCE

The above steps only get you the conversion rates between two currencies in Google Sheets, but they don’t actually convert money from one currency to another. Let us assume we have the following list of prices in dollars and we want to convert them to INR.

To convert the money in the table above from USD to INR, follow these steps:

Select the first cell of the column where you want the results to appear (B2).
Type the formula:
```
=GOOGLEFINANCE("CURRENCY:USDINR")*A2
```
Press the return key.
Double-click on the fill handle of cell B2 to copy the formula to the rest of the cells of column C.
You should now see column B populated with prices in INR.

Notice we simply multiplied the result of the GOOGLEFINANCE function with the cell value in column A, in order to convert the price to INR.

Entering your parameters along with just the general GOOGLEFINANCE function is enough to give you an accurate conversion rate.

However, there are other optional parameters that the GOOGLEFINANCE function lets you enter in order to get specifically what you need. For example, you can use it to display historical exchange rates too.

Related Reading: How to Remove a Dollar Sign in Google Sheets

How to Use GOOGLE FINANCE to Fetch Historical Exchange Rates

You can make some alterations to the GOOGLEFINANCE function to fetch Google Sheet exchange rates (or stock prices) over a period of time, instead of just one day. That’s helpful when you want to create more advanced sheets.

Note that the syntax of the GOOGLEFINANCE function gets a little more complex here. You’ll need to add additional variables. To fetch historical exchange rates, the GOOGLEFINANCE function can be customized to the following syntax:

GOOGLEFINANCE("CURRENCY:<source_currency_symbol><target_currency_symbol>", [attribute], [start_date], [number_of_days|end_date], [interval])

Here’s an example of the formula in action. We’ll explain it further in the next section:

In the above syntax, all parameters shown in square brackets are optional. Here’s what they mean:

The attribute parameter specifies the type of data you want to be retrieved. This is a string value and its default value is “price”. This means we want real-time price quotes fetched from Google Finance. We have provided a list of attribute values and what they mean at the end of this tutorial.
The start_date parameter specifies the date from when we want the historical data to start
In the fourth parameter, you can either specify the end_date for the historical data or the number of days from start_date for which you want the historical data.
The interval parameter specifies the frequency of the returned data. It can be either “DAILY” or “WEEKLY”, depending on your requirements.

How to use GOOGLEFINANCE to Fetch Currency Exchange Rates Over a Time Period

Let us take an example to understand how the GOOGLEFINANCE function can be used to fetch currency rates (USD to INR) from 10th October 2020 to 20th October 2020.

Select a cell from where you want to start displaying the exchange rates. You don’t need to add a header for the columns, since the function adds the column headers automatically.
Type the formula:=GOOGLEFINANCE(“CURRENCY:USDEUR”, “price”, DATE(2020,10,10), DATE(2020,10,20), “DAILY”)
Press the Return key

You should now see two new columns automatically inserted starting from the cell in which you entered the formula.

GOOGLEFINANCE to Fetch Currency Exchange Rates over a Time Period

The first column contains the date for each day between 10th Oct 2020 and 20th Oct 2020. The second column contains the closing google finance exchange rate for each day.

If you want to display weekly rates instead of daily rates, you can simply replace the interval parameter in the currency conversion function from DAILY to WEEKLY.

How to Use GOOGLEFINANCE to Fetch Currency Exchange Rates Over the Past Week

If you want to dynamically display exchange rates over the past, say one week depending on the day the sheet is opened, you can use the TODAY function, instead of the DATE.

Let us see an example where we want to dynamically display exchange rates of the previous 10 days, irrespective of which day the sheet is opened.

Follow these steps:

Select a cell from where you want to start displaying the exchange rates.

Type the formula:

=GOOGLEFINANCE("CURRENCY:USDEUR", "price", TODAY()-10, TODAY(), "DAILY")

Press the Return key

You should now see two new columns automatically inserted starting from the cell in which you entered the formula.

GOOGLEFINANCE to Fetch Currency Exchange Rates over the Past Week

The first column contains the date for each day, from 10 days before to the current date. The second column contains the closing exchange rate for each day.

Here, the TODAY() function returns the current date on which the file is opened. So each time it is opened, this function will refresh and return a new value.

A Few Points to Remember About Google Sheet Currency Conversion

Here are a few important things you need to know to understand the GOOGLEFINANCE function:

When we say real-time exchange rates, you can expect a delay of up to 20 minutes.
For real-time rates, the function returns a single value. However, for historical rates, the function returns an array along with column headers.
If you do not provide any date parameters, GOOGLEFINANCE assumes that you only want real-time results. If you provide any date parameter, the request is considered as a request for historical data.

Google Sheets Currency Conversion Attribute Values

Here are some of the commonly used values for the attribute parameter of GOOGLEFINANCE:

For real-time data:

“priceopen” – We want the price at the time of the market open.
“high” – We want the current day’s high price.
“low” – We want the current day’s low price.
“volume” – We want the current day’s trading volume.
“marketcap” – We want the market capitalization of the stock.

For historical data:

“open” – We want the opening price for the specified date(s).
“close” – We want the closing price for the specified date(s).
“high” – We want the high price for the specified date(s).
“low” – We want the low price for the specified date(s).
“volume” – We want the volume for the specified date(s).
“all” – We want all the above information.

There are a number of other attributes that you can use too. You can refer to the official documentation of Google Sheets to find out more.

Google Spreadsheet Currency Conversion FAQ

Here are a few of the most common questions I hear about currency conversion (and the GOOGLEFINANCE function) in Google Sheets. If you have a question I have not covered, please leave a comment below (or on my YouTube channel).

Can Google Sheets convert currency?

Yes. You can use GOOGLEFINANCE with a currency pair to pull the current exchange rate. For example, this returns the GBP to AUD exchange rate:

=GOOGLEFINANCE("CURRENCY:GBPAUD")

To convert money (not just return the rate), multiply the rate by your amount, for example =A2*GOOGLEFINANCE("CURRENCY:GBPAUD").

How do I convert USD to EUR in Google Sheets?