Technology

Simple and Fast Guide to Convert Currency on Google Sheets

With Google Sheets' currency conversion function, you can easily manage and convert currencies, saving you a lot of time. The data is continuously updated to stay in sync with the financial market.

Administrator

26 December, 2023

141

In the past, when working with different currencies, you had to spend time looking up exchange rates and making complex calculations to get the figures you needed. However, nowadays, with the support of the currency conversion feature on Google Sheets, your currency conversions have become easier, more convenient, and more accurate than ever before.

Real-time currency conversion on Google Sheets

Real-time currency conversion on Google Sheets means converting currencies based on the current exchange rates in the financial market. Specifically, Google Sheets will utilize the available financial data on Google. Every 20 minutes, the exchange rates will be updated and adjusted. From there, you will obtain calculation results referring to the time.

Currency conversion on Google Sheets with default units

In Google Sheets, the default currency unit is “USD”. If you only want to see the exchange rate differences between currencies, you just need to use the formula: =GOOGLEFINANCE(“Currency:Two currency codes to be converted“). After entering it, press Enter on the keyboard to know how many times one currency is equal to or less than the other.

For example: When you want to convert from VND to USD, you enter =GOOGLEFINANCE(“Currency:VNDUSD”).

Note, in the GOOGLEFINACE formula, you need to use the currency codes according to the regulations in the ISO 4217:2008 currency code set.

Converting multiple currencies on Google Sheets at once

In case you want to convert multiple currencies at once, you still use the GOOGLEFINANCE formula, but the data used in the formula will have some changes. Specifically, the conversion steps are as follows:

Step 1: Enter the 2 currency codes to be converted into 2 columns in Google Sheets.

Step 2: In the column where the exchange rates need to be converted, enter the formula: =GOOGLEFINANCE(“Currency:”Coordinate of the first cell:Coordinate of the second cell). In which, the coordinate of the first cell is the currency unit to be converted, the coordinate of the second cell is the currency unit to convert to.

Step 3: Then, drag the right corner of the cell where the formula was entered down to all the remaining rows to apply the conversion function between 2 columns.

Converting currencies on Google Sheets with any unit

If you want to convert currencies with any unit, such as converting from 100 US dollars to VND, you can follow these steps:

Step 1: First, create a column for exchange rates> Enter the GOOGLEFINANCE formula to convert the exchange rate between the 2 currencies> Press Enter.

Step 2: The second column, enter the desired quantity of units to convert. The third column, enter the multiplication command between the exchange rate cell and the quantity of units to convert to convert the currency, then press Enter to get the desired result.

Currency conversion on Google Sheets within a specific time range

In addition to real-time currency conversion, you can also perform conversions within a specific time range using the formula: =GOOGLEFINANCE(“Currency:Two currency codes to be converted“;”price”;DATE(YYYY;MM;DD);DATE(YYYY;MM;DD)). In which, the first DATE function is the start date, the second DATE function is the end date.

Example: Convert between USD and VND within the time range from 27/10/2023 to 03/11/2023, you enter the formula:

=GOOGLEFINANCE(“Currency:USDVND”;”price”;DATE(2023;10;27);DATE(2023;11;03))

The result is shown as follows:

Currency conversion on Google Sheets at a different point in time

If you want to see the exchange rate at a specific point in the past, use the formula: =GOOGLEFINANCE(“Currency:Two currency codes to be converted“;”price”;DATE(YYYY;MM;DD)). In which, the DATE function is the desired currency conversion time.

Example: Convert between USD and JPY on 01/11/2023, you enter:

=GOOGLEFINANCE(“Currency:USDJPY”;”price”;DATE(2023;11;01))

Conclusion

So, the above article has shared with you how to convert currencies on Google Sheets. Hopefully, this trick will make your work easier.