Google Sheets Currency Converter: Rates and Formulas

To convert currencies in Google Sheets, use GOOGLEFINANCE to get a rate, then multiply the amount by that rate. With no input table needed, put this formula in an empty cell such as B2 to get the number of euros for one US dollar: =GOOGLEFINANCE("CURRENCY:USDEUR").

What the currency formula returns

The formula asks Google Sheets for the exchange rate for the currency pair named after CURRENCY:. In USDEUR, USD is the first, or base, currency and EUR is the second, or quote, currency. The returned number means how many euros correspond to one US dollar. If the result were 0.92, for example, one dollar would convert to 0.92 euros at that rate. That number is an illustration, not a statement of the current rate.

Use standard three-letter currency codes, such as USD for US dollars, EUR for euros, GBP for pounds sterling, CAD for Canadian dollars, and JPY for Japanese yen. The order matters: USDEUR and EURUSD are different pairs. If a pair is unavailable, Sheets may return an error rather than a usable rate.

GOOGLEFINANCE retrieves a quote; it does not itself convert a payment, apply a bank’s rate, or account for fees. For a practical conversion, multiply the amount in the source currency by the rate expressed in units of the destination currency per source unit.

Build a reusable converter table

A small input table makes the sheet easier to reuse than editing the currency pair inside a formula each time. Set up row 1 with headings: A1 Source currency, B1 Destination currency, C1 Amount, D1 Rate, and E1 Converted amount. In row 2, enter values such as USD, EUR, and 100 in A2, B2, and C2. With those currency codes in A2 and B2, put this formula in D2:

=GOOGLEFINANCE("CURRENCY:"&A2&B2)

With the amount in C2 and the rate returned in D2, put this formula in E2:

=C2*D2

If D2 returns 0.92, E2 returns 92, meaning a hypothetical 100 USD converts to 92 EUR before any fees or other adjustments. The calculation works the same way for other pairs as long as the source and destination codes are entered in the correct order.

Keep currency codes as plain text in the input cells. A typo or an unsupported pair can prevent the rate from loading.
Copy the formulas down to make additional rows. Each row will use its own source code, destination code, and amount.
For a converter used by other people, add input labels and example values so it is clear which currency the amount represents.

Format the result and make inputs easier

By default, the converted result may display as a plain number. To give it a currency appearance, select the result cell or column and choose Format > Number > Currency in Google Sheets in a web browser. The displayed symbol and formatting can depend on the spreadsheet’s locale, so a currency format is not always a reliable label for which currency the cell contains. Keep the destination code visible in its own column, particularly when a sheet handles several currencies.

You can also format the rate separately. A rate may need more decimal places than a converted amount; rounding the display does not change the underlying value used in multiplication. For an amount intended for ordinary display, two decimal places are common, but currencies and business requirements vary. Avoid rounding the rate in the formula unless you deliberately want the conversion calculation itself to use a rounded rate.

To reduce typing errors, create dropdowns for the source and destination cells using Data > Data validation. A short list of codes is useful for a limited set of currencies. If the sheet will be shared, include a note stating that the displayed result is an indicative conversion and may not match a provider’s settlement amount.

Read the direction and arithmetic correctly

The most common conversion mistake is reversing the pair. A USD-to-EUR rate answers “how many euros for one dollar?” A EUR-to-USD rate answers the opposite question. If the amount is in the first currency named in the pair, multiply it by the returned rate. For instance, if a hypothetical USD-to-EUR rate is 0.92, then 250 USD multiplied by 0.92 gives 230 EUR. Do not divide in that example.

Division is appropriate when you have a rate stated in the reverse direction. If a source gives 1.09 USD per EUR, an amount in USD can be divided by 1.09 to estimate euros. These are reciprocal ways to express a relationship, but published rates can differ slightly because of timing, rounding, spreads, and the provider’s methodology. Do not assume a displayed rate and its reciprocal will reproduce a financial institution’s quoted transaction rate exactly.

For a conversion between currencies that do not have a usable direct pair, a cross-rate may sometimes be calculated through a common currency such as USD. That approach requires obtaining both rates and combining them in the correct direction. Check the units carefully: the intermediate currency should cancel out, leaving the desired destination currency per source currency.

Refresh timing and what the rate represents

Google describes GOOGLEFINANCE data as potentially delayed, and currency data should not be treated as a guaranteed live trading or payment quote. A value visible in a cell may not reflect the rate available at the moment a card, bank, exchange service, or payment platform processes a transaction. Those providers may use their own rates, add a spread, charge a separate fee, or apply the rate at a different time.

Google Sheets can recalculate formulas according to spreadsheet settings. In the web interface, check File > Settings > Calculation for the available recalculation options. Changing a recalculation setting does not guarantee that the underlying currency data provider will supply a new quote immediately. For a report that needs an auditable historical value, record the rate and the time you observed it rather than assuming the live formula will preserve yesterday’s result.

A live formula is convenient for planning, travel estimates, or a dashboard that needs a rough current reference. It is a poor substitute for a confirmed quote when the exact amount matters, such as reconciling a settled payment or preparing a time-sensitive transaction. Save a dated record or consult the actual provider for those cases.

Common errors and practical fixes

If the cell shows an error such as #N/A, first check the three-letter codes and their order. Confirm that the pair is supported, remove accidental spaces, and make sure the formula uses the expected CURRENCY: prefix. Some currencies or pairs may not be available through the function at a particular time. An error does not necessarily mean that the currency itself is invalid.

Blank or loading result: Give the data request time to load, then check the connection and try again. Google Finance data may be delayed or temporarily unavailable.
Unexpectedly large or small result: Verify whether the amount is in the first currency of the pair and whether the pair was entered in the intended direction.
Formula shown as text: Check whether the cell is formatted as plain text or whether an apostrophe was typed before the equals sign. Change the cell format if needed, then re-enter the formula.
Wrong symbol on the result: Check the destination code and the spreadsheet locale. A number format changes display, not the currency calculation.
Rate does not appear to update: Check the calculation settings, but remember that recalculation cannot force the external data source to publish a fresh quote.

For a shared spreadsheet, consider showing a clear error message beside the affected row or leaving the error visible for troubleshooting. Hiding every error can make an unsupported pair look like a valid conversion, which is more misleading than an obvious failure.

Costs, privacy, and alternatives

Using the built-in GOOGLEFINANCE function in Google Sheets does not require a separate paid currency-converter add-on. Google Sheets requires access to a Google account, and features or account arrangements can change, but a basic formula-based converter is a straightforward sheet function. Be cautious about third-party add-ons that request access to spreadsheet data: review the permissions and the provider before installing one.

The function sends a request for market data based on the pair in the formula. Do not place confidential customer, payroll, or payment details into an add-on or shared sheet without considering who can access it and what permissions are granted. For a simple personal estimate, the currency codes and amount are usually all the sheet needs; avoid adding unnecessary sensitive information.

Other options may be better depending on the task. A bank or payment service is the relevant source for the rate and fees it will actually apply. A reputable financial-data service may offer documented timestamps, historical records, or service guarantees that a spreadsheet function does not provide. In Microsoft Excel, GOOGLEFINANCE is not a built-in worksheet function; Excel users need another supported data source or a provider-specific add-in. Choose a source based on freshness, currency coverage, audit needs, and the consequences of an inaccurate estimate.

Frequently Asked Questions

Is Google Sheets currency conversion automatic?
It can retrieve a rate with GOOGLEFINANCE and recalculate the formula, but the external quote may be delayed and is not guaranteed to update instantly. It also does not automatically include a bank’s fees or exchange-rate spread.

What is the Google Sheets formula for USD to EUR?
With no input table required, enter =GOOGLEFINANCE("CURRENCY:USDEUR") in an empty cell. The result is the rate in euros per US dollar when the pair is available.

How do I convert an amount rather than just get the rate?
Get the rate for the source-to-destination pair, then multiply the source amount by that rate. For example, a hypothetical rate of 0.92 gives 92 EUR for 100 USD, before fees.

Can Google Sheets show historical currency rates?
GOOGLEFINANCE supports historical data for some financial data requests, but do not assume that every currency pair or historical period is available in the way you need. For an auditable past transaction, use a suitable dated source and keep a record of the rate used.

Why does GOOGLEFINANCE return an error for a currency pair?
The pair may be unsupported or temporarily unavailable, or one of the codes may be mistyped or reversed. Check the code order and try again later; for a transaction, verify the rate directly with the provider that will process it.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.