Get a currency exchange rate

With the Currency data type you can easily get and compare exchange rates from around the world. In this article, you'll learn how to enter currency pairs, convert them into a data type, and extract more information for robust data. 

Image showing a converted Currency table with exchange rates.

Note: Currency pairs are only available to Microsoft 365 accounts (Worldwide Multi-Tenant clients.)

Use the Currency data type to calculate exchange rates

  1. Enter the currency pair in a cell using this format: From Currency / To Currency with the ISO currency codes.

    For example, enter "USD/EUR" to get the exchange rate from one United States Dollar to Euros.

  2. Select the cells and then select Insert > Table. Although creating a table isn't required, it'll make inserting data from the data type much easier later.

  3. With the cells still selected, go to the Data tab and select the Currency data type.

    If Excel finds a match between the currency pair and our data provider, your text will convert to a data type and you'll see the Currency icon Linked record icon for Stock  in the cell.

    Note: If you see   Question mark icon  in the cell instead of the Currency icon, then Excel is having difficulty matching the text with data. Correct any mistakes and press Enter to try again. Or, select the icon to open the Data Selector where you can search for a currency pair or specify the data you need. 

  4. To extract more information from the Currency data type, select one or more converted cells and select the Insert Data button  Add Column button that appears or press Ctrl/Cmd+Shift+F5.

  5. You'll see a list of all the fields available to choose from. Select the fields to add a new column of data.

    For example, Price represents the exchange rate for the currency pair, Last Trade Time represents the time the exchange rate was quoted.

  6. Once you have all the currency data that you want, you can use it in formulas or calculations. To ensure your data is up to date, you can go to Data > Refresh All to get an updated quote.

    Caution: Currency information is provided "as-is" and may be delayed. Therefore, this data should not be used for trading purposes or advice. See About our data sources for more information. 

See also

Stocks and geography data types 

How to write formulas that reference data types

FIELDVALUE function 

#FIELD! error 

Need more help?

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×