Spreadsheets

Pull exchange rates into Google Sheets with GOOGLEFINANCE

Use GOOGLEFINANCE("CURRENCY:USDINR") in Google Sheets for current and historical exchange rates, and learn why they are indicative and not your card's rate.

Editorial illustration for Pull exchange rates into Google Sheets with GOOGLEFINANCE

In Google Sheets, =GOOGLEFINANCE("CURRENCY:USDINR") returns the current US dollar to rupee rate, and adding a date gives the rate for that day. The numbers are market data meant as a guide, so they will not match the rate your bank applied to a card payment. Use them for estimates and keep billed amounts for your records.

How do I get the current rate?

  • Dollar to rupee: =GOOGLEFINANCE("CURRENCY:USDINR")
  • Euro to rupee: =GOOGLEFINANCE("CURRENCY:EURINR")
  • Pick the pair from a cell: if D2 holds USD, use =GOOGLEFINANCE("CURRENCY:"&D2&"INR")
  • The first currency is the one you hold, the second is the one you want the answer in. USDINR means rupees per dollar.

Current values can be delayed and they change every time the sheet recalculates, so do not treat a live cell as a permanent record.

How do I get the rate on a past date?

Add the word "price" and a date: =GOOGLEFINANCE("CURRENCY:USDINR","price",DATE(2025,1,3)). The function returns a small table with a header row (Date and Close) and one data row, which is awkward inside a bigger formula. To keep only the number, wrap it: =INDEX(GOOGLEFINANCE("CURRENCY:USDINR","price",A2),2,2), where A2 holds the transaction date. INDEX picks row 2, column 2 of that small table, which is the closing rate.

Can I pull a whole month of rates at once?

Yes. Give a start date and an end date and a step: =GOOGLEFINANCE("CURRENCY:USDINR","price",DATE(2025,1,1),DATE(2025,1,31),"DAILY"). Sheets fills a two-column table below the formula cell, so leave the cells beneath and to the right empty or you will see a spill error. You can then use this table as the rate table for date-based lookups. Weekends may have no rows, which is why a lookup for the nearest earlier date is useful.

NeedFormula patternResult
Current rate=GOOGLEFINANCE("CURRENCY:USDINR")One number
Rate on one date=GOOGLEFINANCE("CURRENCY:USDINR","price",A2)Two-row table
Rate on one date, number only=INDEX(GOOGLEFINANCE("CURRENCY:USDINR","price",A2),2,2)One number
Daily range=GOOGLEFINANCE("CURRENCY:USDINR","price",A2,B2,"DAILY")Table of dates and rates

Why does the sheet rate not match my card statement?

GOOGLEFINANCE gives a market quote. A card payment is converted by your bank or the card network on its own terms and timing, and the statement may also carry a fee line. Use the sheet rate when you want to estimate what a purchase will cost. When the statement arrives, record the rupee amount it billed. A hypothetical check: a USD 80 purchase with a sheet rate of 83.00 estimates ₹6,640, while a billed amount of ₹6,720 means an effective rate of 84.00. The ₹80 gap is not an error in the sheet; it is the difference between a quote and a bill.

What if I have hundreds of transactions to convert?

Avoid one GOOGLEFINANCE call per row. A sheet with hundreds of separate market-data calls can load slowly and sometimes shows a loading message. Pull one daily range into a Rates tab instead (dates ascending, rates beside them, header in row 1), then look up each transaction with =VLOOKUP(A2, Rates!$A$2:$B$400, 2, TRUE). The TRUE at the end asks for an approximate match, which returns the nearest earlier date, so a Sunday transaction takes Friday's rate. This needs the dates sorted from oldest to newest.

How do I stop the numbers from changing later?

  1. Select the cells that hold the fetched rates.
  2. Copy them, then use Edit, Paste special, Values only.
  3. The formulas are replaced with fixed numbers, so last month's totals stay put.
  4. Keep one live cell for today's rate, and put a note above it saying it is only an estimate.

Checklist

  • Use three-letter codes and put the base currency last (INR).
  • Convert with =C2*E2 once you have the rate in column E.
  • Freeze rates for closed months by pasting values.
  • Record the card's billed rupee amount where you have it.
  • Check Google's current documentation if a pair stops returning data, since supported data can change.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports