How to view currency exchange rates in Excel

Excel 365
When working with different currencies in an Excel spreadsheet, it is often necessary to use or compare exchange rates. Excel for Microsoft 365 offers a new Currencies Data Type. Like the Stock Data Type, the Currencies Data Type lets you get up-to-date exchange rates worldwide. It returns various exchange details that can be included in a spreadsheet.
Currency exchange rates in Excel 365

If you need to add only the actual or historical currency data (open, high, low, close prices, and volume) to your spreadsheet, you can use a formula instead of the Data Types. See below how to use the function STOCKHYSTORY ().

To add the actual and updatable information about currency pairs into the Excel spreadsheet, do the following:

Select the Currency Data Type

   1.   Type currency pairs in the format <from currency>/<to currency> using the ISO currency codes.

   2.   Select these cells.

For example:

Currency pairs in Excel 365

Note: The GBS code doesn't exist, it is added just to show the possibilities of the functionality, see below.

   3.   On the Data tab, in the Data Types group, click Currencies:

Currencies Data Type in Excel 365

Excel will try to convert the selected text to the Currencies data type. If the transformation was successful (Excel found in the Microsoft online source a matching currency data for the value in the cell), the cell data have the currencies icon Stock icon in Excel 365:

Currency pairs data in Excel 365

Note: For some data (in this example, for USD/GBS), Excel can't find the appropriate currency record in Microsoft online sources. It can happen due to spelling mistakes, and Excel needs your help interpreting the currency pair correctly. In this case, click on the question icon Question icon in Excel 365 to open the Data Selector pane:

Data Selector pane in Excel 365
  • Modify the name in the field on the top if there is a spelling error, and click the find icon Data Type find icon in Excel 365.

    For this example: USD/GBP

  • Select the currencies data:
    Select in Data Selector pane Excel 365

Excel displays the selected currencies data:

Currencies Data Type in Excel 365

Add the currencies information

   4.   Select one or more cells with the Currencies data type (with the icon Stock icon in Excel 365) and click the Insert Data button Insert Data button in Excel 365:

Currencies Data Type columns in Excel 365

From the drop-down list, select the data that you want to add to the spreadsheet.

   5.   Click the Insert Data button again and add more data columns.

For example:

Currencies information in Excel 365


  1. To see all of the fields available for a currency pair, click the icon Stock icon in Excel 365 or select the cell and press Ctrl+Shift+F5:
    Available currency pair information in Excel 365
  2. To refresh data type, do one of the following:
    • On the Data tab, in the group Queries & Connections, click the Refresh All button:
      Refresh All in Excel 365
    • Right-click the currencies data (cells with icon Stock icon in Excel 365) and choose Data Type -> Refresh in the popup menu:
      Refresh Data Type in popup menu Excel 365

    This command refreshes all data types in the workbook (stock, currencies, geography, etc.), not just the current spreadsheet!

  3. To change the Currencies data, right-click on the cell with this data type you want to change (cells with icon Stock icon in Excel 365) and choose Data Type -> Change... in the popup menu.

    This command opens the Data Selector pane to type or select another data (see how to work in this pane above).

    The Change... command in the popup menu is available if you select only one Currencies data element.

  4. To fix or change the Currencies data type to the regular text, right-click on the the data that you want to fix (cells with icon Stock icon in Excel 365), then choose Data Type -> Convert to Text in the popup menu.

    This command converts the Currencies data type to the regular text, and all dependent data won't be shown anymore:

    Not Currencies data type in Excel 365

    To save all dependent data, before converting the Currencies data type, do the following:

    1. Select all dependent data that you want to save and copy it to the Clipboard (by clicking the Copy button on the Home tab, in the Clipboard group, or by pressing Ctrl+C).
    2. On the Home tab, in the Clipboard group, click Paste, and then select one of the Paste Values buttons:
      Paste Values in Excel 365
      • Paste Values in Excel 365  Values (V) pastes the results of formulas. The destination for the copy can be a new or the original range. In the latter case, Excel replaces the original formulas with their current values
      • Paste Values and Number Formatting in Excel 365  Values & Number Formatting (A) pastes the results of formulas, plus the number formatting
      • Paste Values and Source Formatting in Excel 365  Values & Source Formatting (E) pastes the results of formulas, plus all formatting.
  5. Currencies information is provided "as-is" and may be delayed. So, this data can't be used for trading purposes or advice:
    Excel 365 Message
  6. To work with currency information, you need online Internet access and an appropriate Excel version of Microsoft 365.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.