Instant Currency: Google Sheets Add-on
A Google Sheets add-on for converting currencies with historical exchange rates
What it is
Instant Currency is a Google Sheets add-on that converts currencies. Select a range of cells, pick a source and target currency, and it converts everything with proper formatting. It also supports historical exchange rates going back decades.
What I did
I built and published it on the Google Workspace Marketplace, where it has about 146 installs. The add-on handles formatting differences between currencies (symbols, decimal separators, placement) and lets users pick a specific date for the exchange rate.
How it works
You highlight cells with currency values, open the sidebar, choose your currencies, and click convert. The add-on parses the values, fetches the exchange rate (current or historical), converts, and reformats the cells. It handles the annoying details like whether the symbol goes before or after the number, and whether to use commas or periods for decimals.