How to view currency exchange rates in Excel

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.

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

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 :

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 to open the Data Selector pane:

• Modify the name in the field on the top if there is a spelling error, and click the find icon .

  For this example: USD/GBP

• Select the currencies data:
  

Add the currencies information

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

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:

Notes:

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

   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 ) 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 ), 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:

   

   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:
      
      •   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
      •   Values & Number Formatting (A) pastes the results of formulas, plus the number formatting
      •   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:
   
6. To work with currency information, you need online Internet access and an appropriate Excel version of Microsoft 365.