Microsoft Excel logo on a green background

If you use Microsoft Excel for financial data where exchange rates are part of what you need, check out the Currencies data type. This gives you various exchange details that you can include in your spreadsheet.

You can obtain the last trade time, high and low, change percent, and more by entering a pair of ISO currency codes. Then, simply select the details you want to include and refresh the data as needed.

Note: As of May 2022, the feature is only available to Microsoft 365 subscribers. You can use the feature in Excel for Microsoft 365 on Windows and Mac as well as Excel for the web.

Enter the Currency Pairs

You’ll enter a pair of currencies using the ISO codes as: From Currency / To Currency. You can use a colon instead of a slash if you prefer, but Excel will convert it to a slash when you apply the data type.

RELATED: How to Convert Currency in Microsoft Excel

So, to obtain the exchange rate and details from U.S. dollars to Euros, you would enter: USD/EUR. Or, for Australian dollars to U.S. dollars you would enter: AUD/USD.

Currency pairs in Excel

Once you add the pair(s) you want to use, you’ll apply the data type and select the details to display.

Apply the Currencies Data Type

Select the cell where you entered the currency pair. Go to the Data tab and choose “Currencies” in the Data Types box.

Currencies data type in Excel

You’ll see your cell update to display the data type icon on the left, indicating you’ve applied the Currencies type.

Currencies data type applied

Note: If you see a question mark instead of the Currencies data type icon, that means Excel is having trouble matching the data you entered. Double-check the ISO codes for the currency types or click the question mark for more help.

Select the Exchange Data

With the currency pair cell selected, click the Insert Data icon that appears on the right. You’ll see a list of information that you can select from and insert into your sheet.

Data available for the Currencies data type

By default, the data you pick appears in the cell immediately to the right of the cell containing the currency pair. As you select more details to add, each one displays to the right as well.

Exchange rate data added to sheet

Note this caution from Microsoft when obtaining currency exchange rates using this Excel feature:

Currency information is provided “as-is” and may be delayed. Therefore, this data should not be used for trading purposes or advice.

Refresh the Exchange Data

To have the most current details in your sheet, you can refresh the data as needed. For all items, go to the Data tab and click “Refresh All” in the Queries & Connections section of the ribbon.

Refresh All data

For a particular item, select it and use the Refresh All drop-down arrow to pick “Refresh.”

Refresh particular data

If you like using the Currencies data type feature, take a look at how to use the Geography and Stocks options or even create your own data type!

Profile Photo for Sandy Writtenhouse Sandy Writtenhouse
With her B.S. in Information Technology, Sandy worked for many years in the IT industry as a Project Manager, Department Manager, and PMO Lead. She learned how technology can enrich both professional and personal lives by using the right tools. And, she has shared those suggestions and how-tos on many websites over time. With thousands of articles under her belt, Sandy strives to help others use technology to their advantage.
Read Full Bio »