Currency Exchange in Google Sheets: Rates and Formulas

To get a currency exchange rate in Google Sheets, enter a formula such as =GOOGLEFINANCE("CURRENCY:USDEUR"), which requests the USD-to-EUR rate. To convert an amount, multiply the amount in the first currency by that rate; the result is an estimate, not necessarily the rate a bank or card provider will give you.

What the Google Sheets exchange-rate formula does

GOOGLEFINANCE is a Google Sheets function that can retrieve financial information, including currency exchange rates. In a currency ticker, the first three-letter currency code is the currency being converted from and the second is the currency being converted to. For example, USDEUR means U.S. dollars to euros: a rate of 0.92 means one U.S. dollar is equivalent to 0.92 euros in the returned quote.

The formula above asks for the current quoted rate for that pair. Google Sheets may take a moment to return it, and the result can change over time. It is not a fixed rate embedded in the spreadsheet. Exchange-rate data may be delayed, and Google does not promise that a displayed quote matches a rate available for a particular card purchase, cash exchange, transfer, or other transaction.

Currency codes are generally the three-letter codes used in international finance, such as USD for the U.S. dollar, EUR for the euro, GBP for the British pound, CAD for the Canadian dollar, and JPY for the Japanese yen. Use the codes rather than typing currency names into the ticker. To check the other direction, reverse the pair: EURUSD asks for euros to U.S. dollars. The reciprocal of a quoted rate is a useful rough check, though small differences can occur because of data timing or rounding.

Convert an amount using a live rate

A basic conversion multiplies an amount by the rate for the same direction. For a small, readable conversion table, arrange the sheet with the amount in A2, the source currency code in B2, and the target currency code in C2. Enter this in D2 to retrieve the rate:

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

With the amount in A2, source code in B2, and target code in C2, enter this in E2 to calculate the converted amount:

=A2*D2

For example, if A2 contains 100, B2 is USD, C2 is EUR, and D2 returns an illustrative rate of 0.92, E2 calculates 92 euros. The 0.92 figure is only an example, not a promise about the current rate. Format the result as the target currency so the number is easier to read: select the result cell and choose Format > Number, then choose a suitable currency option. Currency formatting changes how a number appears; it does not change the calculation or verify the exchange rate.

You can also put the rate request directly into the conversion formula. With the amount in A2, the source code in B2, and the target code in C2, use:

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

Keeping the rate in its own cell is often preferable in a reusable sheet: it makes the direction and returned quote visible, and lets you inspect or format the rate separately. To apply a formula to more rows, drag the fill handle down from the cell’s lower-right corner. Check that each row has the intended amount and currency codes before relying on the results.

Set up a reusable currency table

A well-labeled layout helps prevent the most common conversion mistake: reversing the source and target currencies. A practical table might have columns for transaction date, amount, source currency, target currency, exchange rate, and converted amount. Put the currency codes in their own cells rather than burying them in long formulas. That makes it easier to change a pair and easier for another person to review the sheet.

Use one row per amount or transaction, with a clear heading above each column.
Keep currency codes consistent, and avoid mixing a code such as EUR with a text label such as euros in the same input column.
Display enough decimal places in the rate to make the calculation understandable; round the final display only as appropriate for the task.
Label whether the amount is before or after fees, and note the date or source of a rate if the sheet is used for record keeping.

For a simple estimate, the calculated result may be enough. For a record of a past transaction, a rate that updates later can be misleading: the sheet may show a different quote from the one available on the transaction date. Preserve the original rate or converted amount as a value if you need a stable record, and make a note of where and when it came from. Pasting values over formulas removes the live calculation, so keep a separate copy of the formula-based table if you still need it.

Historical rates and date-specific conversions

GOOGLEFINANCE can also request historical data for supported securities and attributes. A historical request can return a small table, including a date column and a value column, rather than a single rate. For example, to request daily USD-to-EUR price data over a date range, use this in Google Sheets:

=GOOGLEFINANCE("CURRENCY:USDEUR","price",DATE(2024,1,1),DATE(2024,1,7),"DAILY")

This example requests data from January 1 through January 7, 2024; it does not assert what rates the request will return. Historical availability and returned results can vary, so check the output and the function’s current behavior rather than assuming every date will have a value. The date arguments here are produced with DATE, which avoids ambiguity between day/month and month/day date entry. The interval shown is DAILY; historical requests may return headers and multiple rows, so leave room below and beside the formula for the results to expand.

Historical data is not the same as a transaction receipt. A daily series may not represent the exact time, provider, or spread used for an individual payment. If exact reconciliation matters, use the transaction’s rate and fees from the bank, card issuer, exchange service, or accounting records rather than substituting a general market quote.

Refresh behavior, accuracy, and fees

A rate returned by GOOGLEFINANCE is useful for planning, comparing values, or building an indicative report, but it should not be treated as a guaranteed executable price. Providers can apply a spread, charge a separate fee, use a different quote time, or round amounts differently. A cash exchange counter may offer a rate that differs from a financial-market quote. The final amount paid or received depends on the provider’s terms and the transaction.

Google Sheets may update externally sourced data periodically, and its finance data can be delayed. The function is not a tool for locking a rate at a particular moment. Reopening or recalculating a sheet does not turn its result into a verified transaction quote. For a spreadsheet that will be reviewed later, record the rate, timestamp, and source as fixed information instead of relying solely on a changing formula.

Rounding also deserves attention. If a displayed rate is rounded to two decimal places, the underlying cell may contain more precision than shown. Calculations normally use the stored value, not merely the visible digits. For ordinary display, number formatting can show fewer decimals without changing the underlying number. If you deliberately need to round the calculated amount, decide how many decimal places are suitable for the purpose; currencies do not all use the same minor-unit conventions, and provider rules can differ.

Common errors and how to troubleshoot them

If a formula returns an error or no useful quote, first check the ticker and the pair order. The ticker needs the currency prefix and two valid currency codes, joined without spaces, as in CURRENCY:USDEUR. If the codes are stored in cells, check for trailing spaces or misspellings. Also confirm that the sheet has an internet connection and allow time for the external data request to load.

Wrong conversion direction: USD-to-EUR and EUR-to-USD are different rates. Confirm that the first code is the currency you have and the second is the currency you want.
Unavailable or incomplete data: Google may not return a quote for every request or date. Try a supported pair, check the function syntax, and do not assume missing data means a zero rate.
Formula parse error: Check quotation marks, parentheses, and separators. Spreadsheet locale settings can affect formula separators; if commas are rejected, review the sheet’s locale and use the separator expected by that sheet.
Numbers stored as text: An amount that looks numeric but is stored as text may not multiply as expected. Check the cell’s contents and number format.
Unexpected result: Verify that you multiplied by the rate in the same direction as the requested conversion, and that the amount and rate cells are the ones you intended.

For a cleaner display when a request fails, a formula can catch an error and show a note. With the source code in B2 and target code in C2, this rate formula displays a message if the request errors:

=IFERROR(GOOGLEFINANCE("CURRENCY:"&B2&C2),"Check currency pair")

That message is a convenience, not a diagnosis: it can hide different causes behind the same text. During setup, inspect the original error so you can distinguish a typo from unavailable data or a temporary problem.

Google Sheets compared with Excel and other options

Google Sheets is convenient when a shared online sheet needs a simple rate lookup, because GOOGLEFINANCE is built into the spreadsheet formula environment. The corresponding GOOGLEFINANCE formula is a Google Sheets function, not a native Excel worksheet function. In Excel for Microsoft 365 on Windows, users generally need another data source or an approved add-in or service to obtain rates; the precise approach depends on the organization’s data access and update requirements. Do not expect a Sheets formula to work unchanged in Excel.

For quick personal estimates, a search engine, bank app, or currency-conversion website may be faster than building a spreadsheet. A spreadsheet becomes more useful when you want to convert many rows, keep a visible calculation, combine rates with other data, or share a repeatable estimate. For actual payments, check the provider that will execute the exchange. Its quote and disclosed fees are more relevant than a general informational rate.

Google Sheets and its built-in function do not require a separate purchase for each lookup, but normal access to a Google account and internet service is needed, and organizations may apply their own account or data policies. The function should not be mistaken for a paid real-time market data feed or a service-level guarantee. If a business needs dependable, timestamped, auditable rates, evaluate a specialist data provider and confirm licensing, coverage, update frequency, and permitted use.

Frequently Asked Questions

How do I convert USD to EUR in Google Sheets?
Use =GOOGLEFINANCE("CURRENCY:USDEUR") to request the rate, then multiply your USD amount by the returned number. For instance, at an illustrative rate of 0.92, $100 converts to €92 before any provider fees or spread.

Can Google Sheets convert currencies automatically?
Yes. GOOGLEFINANCE can return a currency quote, and a formula can multiply amounts by that quote. The result can update as external data refreshes, but it is an estimate and is not guaranteed to match a transaction provider’s rate.

Why is GOOGLEFINANCE not updating or showing an error?
Check the currency codes, pair order, formula punctuation, internet connection, and whether the requested pair or historical date is available. Google’s data can also be delayed or temporarily unavailable, so an error should not be interpreted as a zero exchange rate.

Can I get an exchange rate for a past date?
GOOGLEFINANCE supports historical requests for some data, and a currency request may return a date series. Availability is not guaranteed for every date or request. For an exact completed transaction, use the rate on the receipt or provider statement.

Are Google Sheets exchange rates the same as bank rates?
Not necessarily. A bank, card issuer, transfer service, or cash exchange provider may use its own rate, spread, fees, timing, and rounding. Use the provider’s stated terms to determine the amount for an actual transaction.

When this method is a good fit

Google Sheets currency conversion is most appropriate when you need a convenient, visible estimate or a repeatable way to compare amounts across currencies. It is less suitable as the sole source for an executed payment, formal accounting record, or time-critical decision unless the rate source, timestamp, and required precision meet that use. Keep the rate direction explicit, label assumptions, and verify important figures against the service or records that govern the real transaction.

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.