Currency Conversion in Google Sheets: Formulas and Tips

To convert an amount in Google Sheets, multiply it by a rate returned by GOOGLEFINANCE. For example, if A2 contains a USD amount, =A2*GOOGLEFINANCE("CURRENCY:USDEUR") converts it to euros using Google Finance’s USD-to-EUR rate; the rate can change and may be delayed, so it is not a guaranteed transaction quote.

What currency conversion in Sheets does

A currency conversion applies an exchange rate to an amount. The rate expresses how much of the target currency one unit of the starting currency buys. If one US dollar is worth 0.92 euros, then 100 USD multiplied by 0.92 equals 92 EUR. That is an illustrative calculation, not a claim about today’s rate.

Google Sheets can retrieve a currency pair’s rate with GOOGLEFINANCE, then use ordinary multiplication to calculate converted amounts. This is different from changing a cell’s number format. Choosing a euro or dollar format changes how a number is displayed; it does not convert the underlying value or look up an exchange rate.

For example, formatting 100 as euros displays a euro symbol alongside 100. It does not make the amount equivalent to 100 dollars. To convert, use a rate in a formula and format the resulting value in the target currency.

Get a rate with GOOGLEFINANCE

In a Google Sheets cell, enter a pair using the format CURRENCY: followed by the three-letter source and target currency codes. With no additional argument, the function returns the current rate Google Finance makes available for that pair.

For the USD-to-EUR pair, the rate lookup is =GOOGLEFINANCE("CURRENCY:USDEUR"). For euros to US dollars, reverse the codes: =GOOGLEFINANCE("CURRENCY:EURUSD"). A rate is directional: the first code is the currency being converted from, and the second is the currency being converted to.

Currency codes are standardized three-letter codes, such as USD for US dollars, EUR for euros, GBP for British pounds, CAD for Canadian dollars, and JPY for Japanese yen. A currency symbol by itself is not enough to identify the currency reliably; for instance, the dollar symbol is used by multiple currencies.

Set up a reusable conversion sheet

A small table makes the conversion formula easier to reuse and check. Put the amount in column A, the source currency code in column B, the target code in column C, and the converted result in column D. For example, row 2 might contain 100, USD, and EUR.

Enter clear headers such as Amount, From, To, and Converted amount.
Type the amount and currency codes in the same row. Use three-letter codes, with no currency symbols in the code cells.
In D2, enter the formula below, then fill it down for additional rows.

With the amount in A2, source code in B2, and target code in C2, enter =A2*GOOGLEFINANCE("CURRENCY:"&B2&C2) in D2. The ampersands join the text fragments into a pair such as CURRENCY:USDEUR. If the returned rate is 0.92, a 100 in A2 produces 92 in D2. The actual result depends on the rate Sheets returns when the formula calculates.

This layout also helps prevent a common mistake: asking for the inverse pair. If B2 is USD and C2 is EUR, the joined pair is USDEUR. Switching the codes requests EURUSD instead, which is a different rate. Do not multiply by a rate from the reverse pair unless you intentionally use its reciprocal.

Choose a formula for one-off or repeated conversions

For a one-off calculation, putting the amount and rate lookup together is concise. With a USD amount in A2 and a desired EUR result, use =A2*GOOGLEFINANCE("CURRENCY:USDEUR"). This is convenient, but it can be harder to inspect because the rate is not visible in a separate cell.

For a worksheet with many amounts, storing the rate separately can make the calculation clearer and avoid repeating the same lookup in every row. With the USD-to-EUR rate in B1 and a USD amount in A2, enter =A2*$B$1 in C2. If B1 contains 0.92 and A2 contains 100, C2 returns 92. The dollar signs keep the rate reference fixed when you copy the formula down.

Separating the rate is also useful when you need to review or replace it. You can label the rate cell with its pair and note when it was obtained. However, a formula in the rate cell may recalculate, so a displayed value is not necessarily a permanently saved historical rate. If you need a fixed rate for a record, copy the rate and use Edit > Paste special > Values only, or record the approved rate in a separate, clearly labeled cell.

Understand updates, delays, and availability

GOOGLEFINANCE retrieves data from Google Finance; it does not promise a live executable quote from a bank, card issuer, payment service, or currency dealer. Google Finance data can be delayed, and availability varies by instrument and market. A spreadsheet result is therefore useful for estimates, comparisons, and routine calculations, but it may not match the rate applied to an actual payment.

Sheets may refresh external data on its own schedule. Editing a cell or reopening a file should not be treated as a reliable method of requesting an exact-time quote. If a value appears stale or unavailable, wait and check again, but do not assume a refresh has happened simply because the sheet recalculated another formula.

Some currency pairs may not return data, may return an error, or may not be supported consistently. Check that both codes are valid, the order is correct, and the pair is available. If a particular pair fails, try a reputable provider that publishes the rate you need, or obtain the rate from the service that will process the transaction.

Historical rates and fixed-rate records

For some supported pairs, GOOGLEFINANCE can return historical data over a date range. Historical queries return a table of dates and values that spills into neighboring cells, rather than a single rate. Leave enough empty space below and to the right of the formula for that result.

With a USD-to-EUR pair and a desired date range, a historical query can be written as =GOOGLEFINANCE("CURRENCY:USDEUR","price",DATE(2025,1,1),DATE(2025,1,5),"DAILY"). It requests daily data from January 1 through January 5, 2025, where available; the returned table includes headings and dated results. Historical data may not be available for every pair or date, and the function’s returned dates and coverage should be checked before using the values.

For accounting, expense reports, invoices, or any process that requires a specified rate source and date, confirm the organization’s policy or the relevant service’s terms. A historical lookup is not automatically the correct rate for a particular transaction. Keep the date, source, currency pair, and rate together if you need an auditable record.

Format and round the converted amount

After conversion, apply a number format that makes the target currency clear. Select the result cells and use Format > Number to choose an appropriate currency or number format. If the preset displays the wrong currency, choose a suitable custom format or use a nearby label such as “EUR”; the label should make the target currency unambiguous.

Formatting controls what readers see, not the underlying precision. A result may display two decimal places while storing more digits. To round the calculated value itself to two decimal places, use a formula that rounds after multiplying.

With the amount in A2 and the target pair USD-to-EUR, enter =ROUND(A2*GOOGLEFINANCE("CURRENCY:USDEUR"),2). If A2 is 100 and the rate returned is 0.92, the result is 92. The 2 tells ROUND to keep two decimal places. Currency conventions differ, and some currencies do not ordinarily use two decimal places, so choose precision appropriate to the currency and the purpose of the sheet.

Rounding each line separately can produce a slightly different total from adding unrounded amounts and rounding once at the end. For reconciliations, decide which method is required and apply it consistently. Do not treat the display format as a substitute for a deliberate rounding rule.

Common problems and practical checks

An error or blank result: Check spelling, the pair format, and whether the pair is supported. A temporary data issue can also prevent a lookup from returning a rate.
The answer looks much too large or small: Check that the source and target codes are in the intended order and that the amount is in the expected source currency.
The result has a currency symbol but is not converted: Number formatting alone does not perform conversion. Confirm the result cell contains a multiplication formula using a rate.
Rows show the same result: When copying a formula down, check that each row refers to its own amount and currency codes. Absolute references are appropriate for a single shared rate cell, not necessarily for row-specific inputs.
The value differs from a bank or card statement: The provider may use a different rate, timestamp, spread, or fee. Compare the transaction details rather than expecting a general market data feed to reproduce the final charge.

It can help to keep a visible rate column rather than hiding the lookup inside a long formula. That lets a reader inspect the pair and rate, spot a reversed code, and distinguish the market-data estimate from any service-specific amount.

Accuracy, costs, and when to use another source

For ordinary planning, a Google Finance rate can provide a convenient estimate without manually searching for each conversion. The spreadsheet formula itself does not charge a conversion fee, but the source data is not a promise that a real-world conversion will be free. Banks, card networks, remittance services, and brokers may apply their own rates, spreads, commissions, or other charges.

For a real purchase or transfer, use the rate and fee information supplied by the provider that will handle it. For formal reporting, verify which source, date, and rate type are required. This article explains spreadsheet calculations, not financial, tax, or legal advice; check transaction terms with the provider or consult a qualified professional when the consequences require it.

Another option is to enter a rate provided by a bank or other trusted source in a cell and multiply by that value. This is often preferable when a workflow requires a specific timestamp or rate source. A manually entered rate will not update automatically, so label it with the source and date, and protect against accidentally overwriting it if the sheet is shared.

Frequently Asked Questions

How do I convert USD to EUR in Google Sheets?
With a USD amount in A2, enter =A2*GOOGLEFINANCE("CURRENCY:USDEUR") in another cell. The result is an estimate in euros based on the rate returned for that pair. Format the result as euros if useful, but remember that formatting does not change the calculation.

Does GOOGLEFINANCE give real-time exchange rates?
Do not assume the result is a real-time transaction quote. Google Finance data may be delayed, and the rate a payment provider uses can differ because of timing, fees, and its own pricing. Use the relevant provider’s quoted rate for a transaction.

Can I convert several currencies in one column?
Yes. Put each row’s amount, source code, and target code in separate columns, then use a formula such as =A2*GOOGLEFINANCE("CURRENCY:"&B2&C2) in the result column and fill it down. Confirm that each row’s codes form the intended pair.

Why does GOOGLEFINANCE return an error for my currency pair?
The pair may be unsupported or temporarily unavailable, or the currency codes may be mistyped or reversed. Check the three-letter codes and try again later. If the data still is not available, use a suitable external source and document its rate and date.

Does changing the cell to a currency format convert the amount?
No. A currency format changes the display, such as adding a symbol or decimal places. Actual conversion requires a rate and a calculation, typically multiplying the source amount by the rate for the source-to-target pair.

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.