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:
- Paste the following formula on the desired cell: =GoogleFinance("CURRENCY:EURUSD")
- 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.
;