Automatic currency converter in Google Spreadsheets

For those who need to convert currencies on spreadsheets, Google Docs offers a very handy feature that will prevent you to copy-and-paste updated conversion rates moving forward.

The process is very simple, and all you need to do is:

  1. Paste the following formula on the desired cell: =GoogleFinance("CURRENCY:EURUSD")
  2. Replace EUR and USD with the currencies you want to convert. Check here for a list with all currency symbols.

Done. The next time you open your spreadsheet, it will automatically pull the latest rate from Google Finance.

;