The Scenario
You're building a token comparison tool in Excel. It needs metadata for 50 specific tokens: token ID, contract address, chain, circulating supply, and creation date. The data lives in Token Metrics. Your workbook has the symbols in column A. You need the rest of the columns filled.
You came into this project cold — the developer who built the original version is no longer on the team, and the handoff documentation is sparse. There's a note that says "data comes from Token Metrics" and nothing else.
The bad version:
- Try to locate the Token Metrics API endpoint that returns token metadata, find the authentication requirements, figure out how to resolve symbols to internal token IDs
- Discover that contract addresses for multi-chain tokens are stored differently depending on the chain, and what you pasted into row 18 is the wrong network
- Spend four hours on 30 of 50 tokens, then get pulled into another meeting
You're supposed to be delivering the comparison tool. Instead you're doing API archaeology.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your symbol list, searches the Token Metrics catalog for each one, and populates the metadata columns in one pass — without you needing to know what the internal token ID is or which API endpoint serves contract addresses.
Fetch full token metadata from Token Metrics for each symbol in column A of my Excel sheet and fill in columns for token ID, creation date, total supply, and max supply
What You Get
- Token ID (Token Metrics' internal identifier) for each row
- Creation date where Token Metrics has it
- Total supply and max supply as numbers, not formatted strings
- Rows where the symbol doesn't resolve in Token Metrics get a clear note rather than a blank
What If the Data Is Not Quite Ready
You also need contract address and chain for the comparison tool
Search Token Metrics for each token symbol in column A of my 'Tokens' worksheet and populate 'Token ID', 'Contract Address', 'Chain', 'Circulating Supply', 'Total Supply', and 'Creation Date' columns — use 'N/A' for any field Token Metrics doesn't return
Some of your symbols are ambiguous — you want the highest market cap match
For each symbol in my workbook's 'Symbol' column, search Token Metrics and populate the token metadata for the result with the highest market cap — write Token ID, Contract Address, Chain, and Circulating Supply into the adjacent columns
You need to cross-reference your existing token IDs to catch outdated entries
For each row in my workbook, compare the value in my 'Existing Token ID' column against what Token Metrics returns for that symbol — mark 'MISMATCH' in a 'ID Check' column for any row where the IDs don't match, and write the correct Token Metrics ID in the adjacent column
Full pipeline: search catalog, populate metadata, flag missing contract addresses, and write a summary
Search Token Metrics for each symbol in column A. Populate Token ID in column B, Contract Address in column C, Chain in column D, and Circulating Supply in column E. In column F, write 'MISSING CONTRACT' for any row where Token Metrics doesn't return a contract address. In cell H1, write a count of how many tokens are missing contract data.
One prompt resolves the symbols, populates the metadata, flags the gaps, and writes the summary count.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a column of token symbols, then ask it to pull full token metadata from Token Metrics including contract addresses and supply details. See also: Bulk Fetch Live Crypto Prices and the Token Metrics overview.