Automatic Currency Conversion in Google Sheets

currency

Click image to enlarge

If you need to convert currencies, for instance to keep track of overseas income or investments, it’s always a nuisance to update the latest exchange rates to keep your calculations up-to-date. With Google Drive, you no longer need to.

In any cell of your Google Docs spreadsheet you can use the GoogleFinance() function to pull in an exchange rate from real time internet data, so calculations can always be up to date without having to look up an exchange rate.

For example, to get the exchange rate from British pounds sterling to Euros you would use:

=GoogleFinance("CURRENCY:GBPEUR")

If you need to convert other currencies, use the format:

=GoogleFinance("CURRENCY:<from currency symbol><to currency symbol>)

(There’s a list of the currency symbols here)