Google sheet currency conversion, automatic by GOOGLEFINANCE

· in 27-05-2019 · view: 283

Do you know just how much you need to type 100 euros to us dollars on the google search bar immediately get the exchange rate of 100 euros to the dollar.

Google sheet currency conversion, automatic by GOOGLEFINANCE

Currency converter:

Currency converter automatically uses updated google sheets at the latest exchange rates

Convert EUR to USD by Google

And of course, this exchange rate is updated exactly by Google to the minute like gold, so it is very useful.

So if we have more than 2 types of exchange rates to convert. For example, what about Euro to Usd and want Usd to switch to Japanese Yen? Or as you need to convert a lot of different denominations, do it.

GOOGLEFINANCE function on Google Sheets uses Google data itself and is the most useful answer for this case.

Google sheet currency conversion:


In the formula, A3 is the cell value you use to convert, EUR is the currency you want to convert, USD is the currency you want to convert to.

Google sheet currency conversion

For example, in cell A3 you enter 100 Euro. In cell B3, enter the formula above and press Enter. Google Sheets will automatically calculate and convert from 100 Euro how many dollars will be generated at the latest exchange rate.

Do the same in cell C3 you enter = A3 * GOOGLEFINANCE ("CURRENCY: USDJPY")

Will convert from USD to YEN Japanese

And if you have a lot of exchange rates, just dragging the mouse from top to bottom is done very quickly right.
If you do not know the currency code of each country, please click here: link

"This table lists the ISO 4217 codes you can use to specify the currency of monetary values."

A little trick if you don't know how to display the currency symbol equivalent to each currency of the respective countries, do the following:

Select cell A3, then select Format> Number> More Formats menu> More Currency:

how to display the currency symbol equivalent to each currency

Popup Custom Currencies appear you enter the currency you want into the search box, here I need to find the form of EURO so I will enter the Euro. Click Apply to finish the other currencies.

Custom Currencies

Very beautiful, isn't it?

In case you want to present the old exchange rate and the new exchange rate, you can try adding a dash between the old exchange rate and still see the old and very coherent exchange rate. If you do not know how to add Strikethrough on google sheets, this is a guide for you: Strikethrough google docs

Rating 9 star
  • Dalton Allen
    Dalton Allen
    20 minute
    Definitively Helpful that trick :) Helped me out a lot. Thanks.
    • Keir Thomas
      Keir Thomas
      20 minute
      How do I change currency in Google Sheets?
      • Son Nguyen
        Son Nguyen
        20 minute
        On your computer, open a spreadsheet in Google Sheets. Select the range of cells you'd like to format or modify. Click Format Number. Select the format to apply to the range of cells.
      • AJ Ryan
        AJ Ryan
        20 minute
        How to Remove the Dollar Sign in Google Sheets
        • Son Nguyen
          Son Nguyen
          20 minute
          Select the cells containing the dollar symbol formatting that you want to remove. Click the More formats button in the gray toolbar above the spreadsheet. Select the Number option.