Excel — Learn how to convert currency

Navigating international transactions or planning overseas travel often requires currency conversions. This Excel technique provides an easy solution to swiftly access current exchange rates and convert directly within your spreadsheet.

How to use Excel to convert currency

Enter the list of the currencies you want to convert.

• First row should be heading of your choice “Currency”
• The rows below the header should be formatted as follows:
• Abbreviation for Currency you wish the resulting conversion to be in (USD)
• The next text should be “/” without spaces
• Finally, add the Abbreviation for the Currency you wish to convert to (EURO)

List of Currency

Select any cell in the list and convert it to a table. (CTRL+T)

• Check the box “My table has headers.” And click OK

Insert Table

Select all the currency pairs listed in the table

• Go to the Data TAB
• Select Currencies. This converts the pair of abbreviations into Currency Pairs

Currency Conversion

Select any cell in the table and left click on the top right symbol (Add Column)

Table add Column

From the dropdown menu select “Price” from the dropdown menu. This adds a column to the right with the conversion for first currency listed.

Price Column

The result should look like below:

Currency Converted

The “Price” result is the conversion of $1 USD (or currency listed first) to the foreign currency. For example, on the day this table was generated $1.00 US Dollar would equal $18.08 Mexican Pesos (MXN).