Google Sheets → Excel

GOOGLEFINANCE doesn’t work after I opened my Sheet in Excel

You had =GOOGLEFINANCE("NASDAQ:AAPL","price") pulling a live quote. In Excel that cell either shows #NAME?, or a number that hasn’t moved since the day you downloaded the file.

What’s actually breaking

GOOGLEFINANCE is a live market-data feed built into Sheets — prices, exchange rates, historical series, fundamentals — with no Excel function of the same name and no exact equivalent. The closest thing Excel has is the Stocks linked data type in Excel 365 (Data → Stocks): you type a ticker or company name into a cell, convert it to the Stocks type, and pull fields out of it with dot-notation formulas like =A1.Price. It’s a different mechanism (a typed cell, not a function call) with a different field set, so it isn’t a drop-in swap — some of what GOOGLEFINANCE could pull (certain historical ranges, some currency pairs) the Stocks type simply doesn’t carry.

When a GOOGLEFINANCE cell crosses over to Excel, it goes through the same export path as every other Sheets-only function: a dead formula, a cached error, or Google’s __xludf.DUMMYFUNCTION wrapper with the last quote cached inside it — see that page for how to read the cached value back out.

How xlsx-for-ai handles it

xfa (the reader I use for this) flags a dead GOOGLEFINANCE cell the same way it flags any Sheets-only function: a live formula Excel can’t resolve, a cached #NAME?, or the __xludf.DUMMYFUNCTION wrapper all get caught and reported, with the cached quote pulled out where it’s recoverable.

What it does not catch: a quote already frozen to a plain number with no formula or wrapper surviving in the file. A stock price that’s just a number looks identical to one typed by hand, and xfa won’t claim to tell those apart. If a price matters and the cell used to be GOOGLEFINANCE, treat any unflagged number as unverified and check it against a live source before you rely on it.

How to check your file

  1. Add the connector to Claude once — open Settings → Connectors → Add custom connector and paste https://api.xlsx-for-ai.dev/mcp/claude. Full steps are on the developers page.
  2. Read the live Sheet by id. In Claude, ask: 
    Read this Google Sheet and convert it to an .xlsx, with xfa.
Flag anything that won't survive the conversion:
https://docs.google.com/spreadsheets/d/YOUR_SHEET_ID/edit
    Reading a live Sheet is read-only and uses a read-only Google token you supply — see the developers page for the one-time setup.
  3. Or skip the token — in Google Sheets choose File → Download → Microsoft Excel (.xlsx), then ask Claude to “read this file with xfa and tell me what it flagged.” Same reader, same flags.
  4. Read the flags. The result tells you exactly what it did and what it couldn’t carry across — so you review a short list instead of hunting for a wrong number later.
Rebuilding tip: put the ticker in a cell, Data → Stocks to convert it to a linked data type, then reference fields with =CELL.Price, =CELL."52 Week High", and so on — that’s the closest live equivalent Excel has.

More Google Sheets ↔ Excel problems

← All Google Sheets ↔ Excel guides