The Scenario
It's Sunday afternoon and you're preparing a weekly market review for a group of investors. You need a snapshot of the top 50 tokens by market cap — name, symbol, current price, and market cap in one clean table — to anchor the presentation.
You've been to the Token Metrics leaderboard. The data is there. Getting it into Excel in a structured, presentation-ready format is the part that takes longer than it should.
The bad version:
- Export whatever Token Metrics makes available, open the CSV in Excel, discover it has 30 columns you don't need
- Strip the irrelevant columns, reformat the header row, fix the number formatting so market cap reads as a number and not scientific notation
- Realize the export only goes to rank 25 and you need 50, so you pull a second export and stack them manually
You're 45 minutes into prep work that was supposed to take five. The review content hasn't been written yet.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook, understands what you're trying to build, and pulls the leaderboard data from Token Metrics directly — structured the way you asked, not the way the export defaulted to.
Pull the top 100 cryptocurrencies by market cap from Token Metrics and populate my Excel sheet — include token name, symbol, current price, market cap, and 24h volume
What You Get
- 50 (or 100) rows starting at row 2 with rank, name, symbol, price, market cap, and 24h volume in separate columns
- Headers written automatically in row 1
- Numbers formatted as numbers, not text — ready for sorting and conditional formatting
What If the Data Is Not Quite Ready
You want to include 24h price change and filter out stablecoins
Fetch the top 100 tokens by market cap from Token Metrics, remove any token where the name or symbol contains 'USD', 'USDT', 'USDC', 'DAI', 'BUSD', or 'TUSD', then write the remaining tokens to my 'Market Overview' worksheet with rank, name, symbol, price, market cap, and 24h change columns
The worksheet already has last week's data and you want to overwrite it cleanly
Clear the data in columns A through F starting from row 2 in my 'Market Overview' worksheet, then fetch the current top 50 tokens by market cap from Token Metrics and write rank, name, symbol, price, market cap, and 24h volume with headers in row 1
You want to flag tokens where the 24h decline is more than 10%
Fetch the top 50 tokens by market cap from Token Metrics with rank, name, symbol, price, 24h change, and market cap — write to my 'Market Overview' worksheet, then add 'WATCH' in a 'Flag' column for any token where 24h change is below -10%
Full pipeline: fetch the top 50, flag decliners, and sort by market cap descending
Fetch the top 50 tokens by market cap from Token Metrics with rank, name, symbol, price, 24h change, and market cap — write to my worksheet, add 'WATCH' in a Flag column for any token where 24h change is below -10%, then sort the table by market cap descending
One prompt to pull, flag, and sort. The analysis layer and the data fetch don't need to be separate steps.
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook, then ask it to snapshot the current top 50 tokens from Token Metrics. See also: Bulk Fetch Live Crypto Prices and the Token Metrics overview.