Excel Linked Data Types in 2026: Turn Stocks, Geography, and Organizations Into Live Spreadsheet Data
If you are still copy-pasting stock prices or population figures into Excel by hand, you are doing 2015-era spreadsheet work in a 2026 world. Excel's Linked Data Types have quietly matured into one of the most powerful, underused features in the entire Microsoft 365 suite. They turn a plain text entry like "Microsoft" or "AAPL" into a rich, connected data card that pulls live financial, geographic, or organizational information straight into your worksheet — and keeps it updated automatically.
Whether you track a stock portfolio, build a sales territory map, or research companies for a report, Linked Data Types eliminate the manual lookup work that used to eat up entire afternoons. Here is how to put them to work today.
What Are Linked Data Types, Exactly
A Linked Data Type is a cell value connected to an external, structured dataset. Instead of just holding "Seattle" as text, the cell becomes a live record connected to Bing's Geography dataset, carrying dozens of attributes: population, area, time zone, and more. Excel shows a small icon next to linked cells, and clicking it opens a card with every available field.
Three built-in data types matter most for everyday work:
**Stocks** — real-time and end-of-day pricing, market cap, P/E ratio, 52-week range, and analyst ratings for public companies and funds
**Geography** — population, area, capital, flag, currency, and administrative details for countries, states, and cities
**Organizations** — company profiles pulled from Bing, including headquarters, founding year, industry, and employee count
Setting Up Your First Linked Data Type
Getting started takes under a minute:
Type plain text labels into a column — ticker symbols, country names, or company names
Select the range
Go to the Data tab and choose Stocks, Geography, or Organizations from the Data Types gallery
Excel matches each entry to a record; a small "card" icon appears when the match succeeds, and a question mark appears if Excel needs you to confirm which entity you meant
If a value shows a question mark, click it and pick the correct match from the suggestion list. This matters most with ambiguous names — "Georgia" could resolve to the country or the US state, so Excel asks you to confirm once, then remembers your choice.
Extracting Fields With the Data Selector
Once a column is linked, click the small table icon that appears when you hover over the column header, or use the Insert Data card. This opens a field picker where you can choose exactly which attributes to pull into adjacent columns — price, currency, percent change, or capital city, for example. Selecting a field automatically writes a formula using the FIELDVALUE function, so the extracted values update whenever the underlying data refreshes.
You can also reference fields directly in formulas without extracting a whole column. For a stock in cell A2, typing `=A2.Price` or `=FIELDVALUE(A2,"Price")` returns the current price on its own. This dot notation is one of the most convenient shortcuts Excel added for linked records, and it works inside any formula, including SUMPRODUCT, IF, and conditional formatting rules.
Building a Live Stock Tracker
A practical five-minute project: list ticker symbols in column A, apply the Stocks data type, then extract Price, Change, Change %, and 52-Week High into columns B through E. Add conditional formatting so Change % turns green above zero and red below. Because the data type refreshes automatically (and manually via Data > Refresh All), your tracker updates every time you open the file — no formulas to rebuild, no external add-ins required.
Combining Data Types With Copilot
In 2026, Copilot in Excel can generate and explain formulas that reference linked data fields, which removes the last bit of friction for non-technical users. Ask Copilot something like "add a column showing which stocks dropped more than 5% this week" and it will write the FIELDVALUE-based formula and conditional formatting for you, referencing the fields already present in your linked column. This pairing — structured live data plus a natural-language formula assistant — is what makes Excel feel less like a static grid and more like a connected research tool.
Refreshing and Managing Linked Data
Linked Data Types refresh automatically on file open, and you can force an update anytime with Data > Refresh All or by right-clicking a linked cell. If you need to freeze values for an audit or historical snapshot, convert the data type back to static text and numbers using Data > Data Types > Convert to Text — this locks in the current values permanently, which is useful before sharing a report externally.
Where This Fits Your Workflow
Linked Data Types shine anywhere you would otherwise maintain a manual reference sheet: investment tracking, competitive research, sales territory planning by country or region, or building dashboards that mix your own business numbers with live external context. Because the data lives inside the cell rather than in a separate lookup table, it travels with the file and updates for anyone who opens it with an internet connection.
Try It This Week
Pick one spreadsheet you already maintain by hand — a watchlist, a client roster with company details, or a regional sales report — and swap in a Linked Data Type column. Once you see how little maintenance it takes to keep that data current, you will start looking for other places to retire manual lookups. Start small, extract just two or three fields, and build from there.
