Currency Rate in Google Sheets: Formulas and Tips

To get a currency rate in Google Sheets, use the GOOGLEFINANCE function with a currency pair, such as =GOOGLEFINANCE("CURRENCY:USDEUR") for the U.S. dollar to euro rate. The result is the number of euros equivalent to one U.S. dollar; multiply it by a dollar amount to estimate a conversion.

The basic GOOGLEFINANCE currency formula

The currency pair is written as two three-letter currency codes joined together: the currency you are converting from comes first, and the currency you want comes second. The CURRENCY: prefix tells Sheets to look up a foreign-exchange pair. For example, with no other cell references needed, =GOOGLEFINANCE("CURRENCY:USDJPY") requests the U.S. dollar-to-Japanese-yen rate.

Common codes include USD for U.S. dollars, EUR for euros, GBP for pounds sterling, CAD for Canadian dollars, AUD for Australian dollars, and JPY for Japanese yen. Use currency codes rather than symbols such as $, £, or €. A dollar sign alone does not identify which country’s dollar you mean.

The returned value is a rate, not a formatted cash amount. If the result is 0.92, for example, it means one unit of the first currency is worth about 0.92 units of the second. Rates change, so treat any example number as illustrative rather than a current quote. You can enter a formula in a cell and press Enter; Sheets displays the returned value when the data is available.

Convert an amount with the rate

To estimate a converted amount, multiply the starting amount by the rate for the correct direction. Suppose A2 contains 100, representing 100 U.S. dollars, and B2 contains a USD-to-EUR rate of 0.92. With that layout, enter =A2*B2 in C2. The result is 92, or approximately €92 before any fees or provider-specific exchange rate adjustments.

Direction matters. A USD-to-EUR rate answers how many euros one dollar buys. It is not the same as the EUR-to-USD rate. To fetch the reverse direction, request the reversed pair. If B2 contains a USD-to-EUR rate, you can also calculate an approximate reverse rate by taking its reciprocal; this is a mathematical conversion, not a guarantee that a bank or card provider will offer that exact rate.

A simple conversion sheet might include:

A2: amount to convert, such as 100
B2: source currency code, such as USD
C2: target currency code, such as EUR
D2: fetched exchange rate
E2: converted amount

Build a reusable currency converter

Putting currency codes in cells makes it easier to change the pair without editing the formula. With the source code in B2 and target code in C2—for example, USD and EUR—enter this in D2: =GOOGLEFINANCE("CURRENCY:"&B2&C2). The ampersands join the prefix and the two codes into a currency-pair request. Enter the amount in A2, then, with the amount in A2 and rate in D2, use =A2*D2 in E2.

Label each cell clearly and validate the currency-code inputs if other people will use the sheet. A misspelled code, an extra space, or the codes in the wrong order can cause an error or produce a rate in the opposite direction. A drop-down list can reduce typing mistakes: select the input cells, then choose Data > Data validation in Google Sheets and set rules for the codes you intend to support.

Request historical exchange rates

GOOGLEFINANCE can also request historical data for supported currency pairs. Historical requests return a small table of dates and values rather than just one rate, so leave room for the results to expand into the cells below and to the right. Do not put unrelated content in that spill area.

With the pair set to USD-to-EUR, the start date set to January 1, 2024, and the end date set to January 5, 2024, this formula requests daily historical data: =GOOGLEFINANCE("CURRENCY:USDEUR","price",DATE(2024,1,1),DATE(2024,1,5),"DAILY"). Sheets supplies the result as a date-and-value table, including headings. The dates in a returned series are not a promise that every calendar day has a separate market observation; weekends and data availability can affect what appears.

Historical rates are useful for looking up a past value or charting a trend, but the number should not automatically be treated as the rate actually charged in a past purchase. A card issuer, bank, or payment service may use its own rate, timestamp, fee, and rounding rules. For accounting or reimbursement records, use the rate and date required by the relevant policy.

How current and reliable is the rate?

Google Sheets retrieves finance data through Google Finance, but the result is not a guaranteed real-time executable quote. Data can be delayed, and Google notes that some data may be delayed by up to 20 minutes. Availability and update timing can vary by instrument and data source. A spreadsheet cell that shows a rate therefore works well for general reference or an estimate, but it is not a substitute for the final rate shown by a payment provider.

There is also a difference between an indicative exchange rate and the amount someone will receive in a transaction. A bank or exchange service may add a spread or fee, and an international card payment may use a rate determined at a different time from when the purchase was made. If you need to reconcile an actual transaction, compare against the provider’s posted rate and fee details rather than assuming the Sheets value matches.

For critical workflows, record the date and time associated with each rate and preserve a copy of values used in a report. A live formula can update, so a sheet left open today may not show the same value when opened later. Copying and pasting a result as a value can preserve a snapshot, but it also stops that cell from updating automatically.

Format the result without changing its value

Number formatting changes how a value looks; it does not perform a currency conversion. For example, formatting 100 as euros does not turn dollars into euros. The multiplication formula must calculate the converted amount first.

In Google Sheets, select the relevant cell or range and choose Format > Number > Currency to apply a currency display. For a specific currency symbol or format, use Format > Number > Custom currency, then select the option you want. The default currency style can depend on the spreadsheet’s locale, so check the displayed symbol rather than assuming it matches the target currency.

It can be clearer to show the currency code in a separate column, especially in a sheet containing several currencies. A value such as 92.00 beside EUR is less ambiguous than a bare number or a symbol that several countries share. Keep enough decimal places in the stored rate for calculation; rounding the displayed rate is usually different from rounding the underlying result.

Common errors and ways to troubleshoot them

Pair not recognized: Check the three-letter codes, remove spaces, and confirm the pair is supported. Some currencies or pairs may not be available through Google Finance.
Wrong conversion direction: Put the source code first and the destination code second. USD followed by EUR is not the same pair as EUR followed by USD.
Loading or unavailable result: A finance-data request may take time or fail temporarily. Wait and check again; do not assume a blank or error means the exchange rate is zero.
Array result cannot expand: A historical request returns multiple cells. Clear any obstructing cells in the output area and check that merged cells are not blocking the results.
Formula parse error: Confirm the quotation marks and parentheses are balanced. Depending on the spreadsheet locale, Sheets may expect semicolons rather than commas between function arguments.
Unexpected symbol or decimals: Check Format > Number and the spreadsheet locale. Formatting can change the appearance, but not the rate or the conversion calculation.

Also remember that GOOGLEFINANCE is a Google Sheets function, not a universal spreadsheet formula. In Microsoft Excel, it will not work as written. Excel for Microsoft 365 has a separate Currencies linked data type in supported setups, and users can also connect to an appropriate data source; the steps and refresh behavior differ from Sheets.

When to use another source

For casual calculations, travel planning, classroom examples, or a dashboard where an approximate rate is enough, GOOGLEFINANCE is convenient because the lookup sits directly in a cell. It avoids manually typing a new rate each time, but it depends on Google’s supported pairs and data availability.

For invoicing, payroll, tax records, regulated reporting, or settlement calculations, first identify the required source, date, and method. A company policy, accounting standard, contract, or financial institution may specify which published rate to use. A bank’s conversion preview or payment receipt may be the right reference for a transaction; an approved official or commercial data provider may be more suitable for repeatable reporting. Check the source’s terms, timestamps, and fees, and consult a qualified professional for financial, tax, or legal questions.

Third-party Sheets add-ons and APIs can cover needs that a built-in function does not, such as a particular provider or update schedule. Before granting an add-on access, review its permissions, privacy policy, and pricing. Avoid putting account passwords, payment credentials, or private transaction details into an unfamiliar tool just to retrieve an exchange rate.

Frequently Asked Questions

What is the formula for USD to EUR in Google Sheets?
Use =GOOGLEFINANCE("CURRENCY:USDEUR"). It returns the rate for one U.S. dollar in euros when the pair is available.

How do I convert euros to dollars instead?
Reverse the pair and request EURUSD. The order of the codes determines the direction: the first code is the currency being converted from, and the second is the destination currency.

Can Google Sheets convert a whole column of amounts?
Yes. Put the same rate reference beside each amount and multiply each amount by that rate, or copy a multiplication formula down the rows. Make sure every row uses the intended source and target currencies.

Why is GOOGLEFINANCE not updating?
Finance data is not guaranteed to update instantly, and availability can vary. Check that the pair is valid, wait and retry if the request is temporarily unavailable, and remember that a displayed rate may be delayed rather than live.

Does formatting a number as euros convert it from dollars?
No. Currency formatting only changes the symbol and number display. To convert the amount, multiply it by the USD-to-EUR rate first, then format the calculated result as euros if that presentation is useful.

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.