Currency Converter in Excel

For you to create a currency converter, you first needs data like this:


conversion usd1. Layout the data you want to convertlayout data

2. Mark the data you want to convert, add one empty column, and then press CTRL + T, just press ok.

add empty column

3. Click inside the table (1), and type

=(click on the cell with a currency you want to convert)*VLOOKUP([@currencies],$A$2:$B$3,2,False) (2), and press enter.

click nside column

Note: It is crucial that you add the $ before and after the column before righting the cell numbers in the range. This step will automatically calculate the rest.

4. Write Euro between total and 53293.

write euro

5. Change column2 to Euro

change column to euro

6. Choose all the cells in Euro column (1), right click on it, and choose Format Cells (2).

format cells

7. Choose Currency (1), choose Euro (2), and press ok (3).

currency format cell

Note: Repeat this step on the USD column, but choose the dollar sign this time In conclusion, the best way to create currency converter is to first get the rate for all the currencies you want to convert. These steps laid above will then help you use those rate to convert.

We have created a currency converter that look like this:

currency converter ready



You can download the Template here – Download