How to add and use value tokens in Microsoft Excel
Most Excel sheets are dumb—they contain static text that has no connection to the real world, forcing you to manually update prices and stats by hand. Value tokens change that. These smart pills link your cells directly to live data from the web, turning a boring, stagnant grid into a professional, self-updating dashboard.
To take advantage of value tokens, you need a Microsoft 365 subscription and an active internet connection. At the time of writing (January 2026), value tokens are only available to those using the latest version of Excel for Windows or Excel for Mac. While Microsoft plans support for Android, iOS, and Excel for the web, legacy data types remain the default on those platforms for now.
What exactly is a value token?
To understand why value tokens are a game-changer, we have to look at how Excel used to handle rich data. Previously, while you could use data types like Stocks or Geography , they weren't clear to see in the formula bar. This meant you could have a cell technically connected to live data sources, but in the formula bar, the information looked like plain, static text. This made it difficult to differentiate between a cell you typed manually and a rich cell that pulls live info from the web.
Microsoft solved this by introducing value tokens, which provide a clear visual indication that a cell contains a data type or other rich formats.
The term value token refers to the entire live-data experience. This includes:
-
The icon:A tiny visual symbol added next to the value to help you differentiate between different data types at a glance.
-
The text:The actual live data value.
-
The Insert Data button:A small icon that appears to the right of the selected cell. Clicking this allows you to add specific attributes—like population, time zones, or stock prices—to the adjacent column.
-
The pill container:The rounded background in the formula bar that groups the icon and the text into a single object.
These tokens serve as a bridge to reputable, live data from Bing and Power BI. By showing these tokens directly in the formula bar, Excel finally provides a way to view and differentiate your data types from regular text.
How to activate value tokens
You don't always have to go hunting through Excel's menus to create value tokens—Excel can proactively identify smart data as you type it. If you enter a series of data that Excel recognizes, a prompt appears to help you convert them into value tokens.
You can also activate them manually via the ribbon. Select the cell or range of cells, and in the Data tab, click the appropriate category ("Geography," "Stocks," or "Currencies").
"Dot" formulas: The power user move
While clicking the Insert Data button to the right of the cell is one convenient way to extract related data, power users can take things a step further using dot notation.
Simply type an equal sign, followed by a reference to the cell containing the token, followed by a dot:
As soon as you type that period, you see a drop-down menu containing every attribute Excel knows about that specific token, which you can pull directly into the cell without any manual research.
You don't need to type out the full attribute name. When the drop-down menu appears, use the Arrow keys to navigate to the attribute you want, and press Tab to add it to your formula.
The real power of "dot" formulas comes to the fore when you use these attributes inside larger formulas to build calculations that stay updated. For example, if cell A1 is a geography token for a country, you could calculate the population density (people per km²) by entering:
Why value tokens are essential for professional integrity
Beyond the visual polish, value tokens offer a level of transparency that you simply can't get with standard text.
Detailed information and source verification
When you click the token icon in the cell (or use the keyboard shortcut Ctrl+Shift+F5 or Cmd+Shift+F5), Excel opens a data card displaying images, descriptions, and various other fields (such as a city's area, a company's stock price history, or even local time zones) as well as the source of the information (whether it's live data from Bing or internal organization data via Power BI).
Self-updating data
Value tokens are living objects. Because they're linked to the cloud, you can refresh your sheet at any time to pull the latest information. To update every token simultaneously, click the "Refresh All" icon in the Data tab. On the other hand, to update a single token, right-click it, hover over "Data Type," and click "Refresh."
For time-sensitive data like stocks and currencies, you can automate data refreshes. Right-click a token icon, select Data Type > Refresh Settings, and choose "Automatically every five minutes." This keeps your worksheet current without you ever having to lift a finger.
Data standardization
Tokenizing your data forces Excel to recognize specific entries. It cleans up your sheet by ensuring that inconsistent entries like "MSFT" and "Microsoft" all point to the same verified stock token.
You don't always need to be perfectly accurate when typing. For example, typing a stock ticker like "AAPL" or a common abbreviation for a city often triggers the correct token automatically. Excel is highly intelligent: if you slightly mistype a name, it often interprets the intent and suggests the correct linked data type.
Value tokens make your spreadsheets more accurate and professional by converting your dead data into connected, intelligent objects, and the ability to verify sources via the data card adds a layer of trust that manual typing can never provide. This focus on reliability is particularly important when you share your Excel workbook with others and need to ensure everyone is looking at the same, live information. While not every sheet needs a live connection, if you're still manually looking up prices, you're working harder than you have to.
