The Scenario
You're presenting a sector landscape to a group of institutional investors next Thursday. The thesis requires showing them how cryptocurrency value is distributed across categories — DeFi, Layer 1, stablecoins, NFTs, and the long tail of everything else. Your data source is Coinranking, which maintains a comprehensive tag taxonomy with market-cap and dominance figures for each category.
A colleague tried to build this table three weeks ago by going through the Coinranking UI tag by tag, counting coins, and copying numbers into an Excel workbook. She got 22 tags in before the meeting moved to a different topic and the work got abandoned. The workbook is still sitting there, 22 rows, out of date, labeled "WIP."
The bad version:
- Navigate to Coinranking's tag listing, read off tag names and their associated coin counts one by one, type them into the workbook.
- Try to find where Coinranking surfaces total market cap and dominance per tag — it's there, but it requires clicking into each tag's dedicated page to see the aggregate metrics.
- 40+ tags, 40+ page navigations, manually copying four numbers each time. Someone will transpose a digit. Someone will copy the wrong row.
The investors are going to look at this table and ask why certain sectors have higher dominance than others. If the table has a transcription error in the market cap for DeFi, that question is going to land badly.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside Excel with a direct Coinranking integration. It can pull every tag in the taxonomy — names, coin counts, market caps, dominance figures — in one request, without you clicking through 40 pages.
Fetch all Coinranking tags and write tag name in column A, coin count in column B, total market cap in column C, and 24h volume in column D into this worksheet — one row per tag, starting at row 2
What You Get
- Every tag in Coinranking's taxonomy in a single run — typically 40+ categories
- Tag name, coin count, market cap (USD), and 24h volume written as clean numbers
- Rows ordered by total market cap descending so the dominant sectors appear at the top
- A count of total tags retrieved if you ask for it in cell A1
What If the Data Is Not Quite Ready
You want dominance as a percentage column instead of raw volume
Fetch all Coinranking tags and write tag name, coin count, total market cap, and tag dominance percent into columns A through D starting at row 2, sorted by dominance descending
You want to filter out tags with fewer than 10 coins
Fetch all Coinranking tags, write name, coin count, market cap, and 24h volume into columns A through D, then remove any rows where the coin count is fewer than 10
You want to highlight the top 5 sectors by market cap
Fetch all Coinranking tags, write name, coin count, market cap, and dominance into columns A through D sorted by market cap descending, then highlight the top 5 rows in yellow
Full investor landscape table in one shot
Clear columns A through E from row 2 downward, write "Sector", "Coins", "Market Cap (USD)", "24h Volume (USD)", "Dominance (%)" in row 1, fetch all Coinranking tags and write one row per tag starting at row 2 sorted by market cap descending, filter to only include tags with 10 or more coins, and highlight the top 3 rows by market cap in light blue
A clean, filtered sector landscape table ready for the deck in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook where you're building the sector landscape, then ask it to pull the full Coinranking tag table. When you want to drill into individual sectors, see Pull All Coins in a Sector Tag Into an Excel workbook for Sector Analysis and the Coinranking Excel overview.