Spreadsheet guide

Currency converter spreadsheet — the full pattern

A converter spreadsheet is two cells away in Excel and Sheets. Scaling it to many currencies and many rows, with totals that don't drift, is the part nobody documents.

The minimum viable spreadsheet converter

Excel: =STOCKHISTORY("USDEUR", TODAY()) · Google Sheets: =GOOGLEFINANCE("CURRENCY:USDEUR"). Multiply by the amount cell. Done.

The scalable version

  1. One reference table: currency code, live rate, last refresh timestamp.
  2. Rows reference the table via VLOOKUP / XLOOKUP.
  3. A second column stores a snapshot rate at entry — paste-special-values, not a formula — so historical rows don't revalue.
  4. Reporting reads the snapshot column, not the live one.

Where spreadsheets stop working

  • Many currencies × many rows in a single view, all totaled in one home currency.
  • Five-plus people editing the same grid at once.
  • Copy-paste between sheets without breaking formulas.

At that point you either build a Power Query monster or move to a focused tool like Currency Grid — keeps the spreadsheet ergonomics, adds live ECB rates and a single home-currency total out of the box.

Quick reference

NeedTool
One-off conversionNative spreadsheet function
Daily dashboardPower Query / IMPORTDATA + Frankfurter
Many currencies in a grid with one home-currency totalCurrency Grid
Snapshot rate per rowPaste-special-values column

Frequently asked questions

Is there a free currency converter spreadsheet?
Yes — both Excel and Google Sheets ship native functions (STOCKHISTORY and GOOGLEFINANCE) that turn a blank sheet into a currency converter in one cell. The catch is refresh behavior: rates update only while the file is open.
How accurate are spreadsheet currency converters?
Native spreadsheet feeds (Google Finance, Microsoft Stocks) are mid-market quotes from public exchanges — close to interbank but not what your bank quotes. For accounting-grade rates use ECB reference rates via Frankfurter, which finance teams across the EU treat as the standard.
Why does my converter spreadsheet show different values every refresh?
Live rate functions overwrite historical cells every recalc. The fix is to snapshot the rate into a static column when the row is entered — paste-special-values in spreadsheets.
Spreadsheet vs dedicated currency tool — which should I use?
Spreadsheet for ad-hoc conversions and small lists. A dedicated grid like Currency Grid when you want many currencies across many rows with one home-currency total — without maintaining formulas.

Try the live grid

Currency Grid is a spreadsheet-style multi-currency converter. Type amounts in any currency and see live conversions across rows and columns, totaled in your home currency using daily ECB reference rates.

Open Currency Grid

Related