In our selected cell (for example, C3), we can then type the GOOGLEFINANCE Function and complete the following formula. We can set up a table in Google Sheets similar to the table we set up in Excel.Ģ. Google Sheets has a built-in currency converter that makes use of existing up-to-date conversion rates on the internet.ġ. To create an exchange rate converter for the inverse rates, we would need to create a lookup for the inverse rates in our data.Īutomatic Currency Conversion in Google Sheets
![live currency converter excel live currency converter excel](https://cdn.extendoffice.com/images/stories/doc-excel/live-exchange-rate/doc-live-exchange-rate-3.png)
We can then copy this down to populate our exchange rate converter.ġ0. To get the value of 2 USD to 1 GBP or 1 EUR, we can copy the formula down to the next row, and then multiply it by the value in Column B.ĩ. We can repeat the procedure to look up the EUR from the data table. Press ENTER to enter the formula into Excel.ħ. We now complete our VLOOKUP formula by typing in the column name and the word FALSE as the final argument for the formula. This is because the table data in Excel was linked into Excel with a range name of usd.ĥ. As soon as we select the entire data list, Excel will automatically put the columns of the database as references in the formula rather than using the cell addresses. We then need to highlight the relevant lookup data by going to the data sheet and selecting the information we require.Ĥ. TIP: Use an absolute reference ($) so we can copy the formula down.ģ. In the relevant cell (for example C5), we can type in the following: =VLOOKUP($C$4, We can now use the VLOOKUP Function to look up the currency rate for the British Pound against the US Dollar. We can now create a new worksheet in the same workbook as the linked XML database and set up a table as shown below.Ģ. Uncheck the columns that are not required, and then click OK.ĩ. In the Ribbon, select Home > Manage Columns > Choose Columns.Ĩ. The Power Query will now change to show the exchange rate columns as well as the initial columns.ħ. Click on the double-headed arrow to show the fields of this table, and then click OK.Ħ. The exchange rates will be populated in a table below the initial line of data.ĥ. Scroll across to the last item on the list, and then click on the word Table. In the File name box type the URL for the floatrates file – – and then click Open.Ĥ. In a blank Excel worksheet, in the Ribbon, select Data > Get Data > From File > From XML.Ģ.
![live currency converter excel live currency converter excel](https://i.ytimg.com/vi/f8KQBWkR9fw/maxresdefault.jpg)
#Live currency converter excel free
The most user-friendly source file is one called Floatrates, a free XML feed that is updated daily.ġ. Excel does not have a built-in currency conversion tool, but with a link to an external XML database, we can build our own conversion tool into Excel using Power Query.
#Live currency converter excel how to
This tutorial will demonstrate how to create and automatic currency converter in Excel and Google Sheets.Įxcel is a powerful tool for calculations, often involving international currencies.