How to Pull Live Foreign Exchange Rates into Google Sheets

Use the native GOOGLEFINANCE function. No external APIs or scripts are required. To fetch the live exchange rate for United States Dollars (USD) to Euros (EUR), copy and paste the following formula into any cell:

Excel

=GOOGLEFINANCE("CURRENCY:USDEUR")

The Syntax Breakdown

• =GOOGLEFINANCE(...): The native Google Sheets function used to fetch current or historical securities information, including currency pairs, directly from Google Finance.
• "CURRENCY:": The specific attribute prefix required within the quotation marks to instruct the function that you are requesting foreign exchange (FX) data, not stock market data.
• USDEUR: The consecutive pairing of ISO currency codes. The first three characters (USD) represent the source or base currency. The final three characters (EUR) represent the target or quote currency. There must be no spaces between the codes.

Real-World Example: Consolidating International Expense Reports

A US-based operations manager needs to consolidate an expense report from a European subsidiary. The raw data contains expenses in Euros (EUR), and the final report must display all costs in US Dollars (USD) based on the live exchange rate.

Here is the raw data table in Google Sheets:

To calculate the exchange rate and the final USD amount, follow these steps:

1. In cell E2, enter the following formula to fetch the dynamic rate:Excel=GOOGLEFINANCE("CURRENCY:"&D2&C2) (Note: The formula concatenates cells D2 (EUR) and C2 (USD) to create the string “CURRENCY:EURUSD”, fetching the rate required to convert EUR to USD).
2. Copy cell E2 and paste it down through cells E3 and E4.
3. In cell F1, label the column Amount (USD).
4. In cell F2, enter =B2*E2.

The final output looks like this:

Common Errors & How to Fix Them

• #N/A Error (Could not evaluate part of the formula)
  • Cause: You likely have a typo in the currency codes or are using an unsupported currency pair.
  • Fix: Verify that you are using valid three-letter ISO currency codes (e.g., JPY, GBP, CAD) and that there are no spaces within the “CURRENCY:XXXXXX” string.
• Stale Data / Rates Not Updating
  • Cause: GOOGLEFINANCE data can be delayed by up to 20 minutes, and Google Sheets caches results to improve performance. The rate will not refresh on every edit.
  • Fix: To force a refresh, you can temporarily change one of the currency codes in the formula, press Enter, and then change it back. Alternatively, wait for the automatic cache refresh, which occurs periodically. Do not use this function for high-frequency trading where split-second accuracy is required.