The Scenario
Your Monday morning starts with a message from your portfolio manager: the weekly market-cap ranking table in the shared Google Sheet is three weeks out of date and the 9 AM investment committee call is in 90 minutes. You open the sheet and see the last import was done by whoever had the job before you — the columns are right, the data is stale, and there's no documentation for how it was built.
The bad version:
- Open Coinranking, navigate to the top coins list, and download whatever CSV is available — which only covers the top 50 and doesn't include 24h change.
- Open the CSV in a separate tab, copy the columns you need, paste them into the target sheet, and manually fix the numeric formatting on the market cap column that pasted as text.
- Do this again next Monday, and the Monday after, knowing that whoever set up this sheet assumed someone would just keep repeating the process forever.
The investment committee isn't paying for your time to do data entry. The analysis they want — momentum shifts, which coins are climbing, which are slipping — requires fresh numbers. Stale data in that table isn't just inconvenient; it's the kind of thing that undermines confidence in everything the sheet says.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent built into Google Sheets. It reads your sheet, understands the structure, and reaches into Coinranking's live data through its built-in integration — no CSV downloads, no column mapping, no manual paste.
Fetch the top 100 cryptocurrencies by market cap from Coinranking and populate this sheet with rank in column A, coin name in column B, symbol in column C, current price in USD in column D, 24h price change percent in column E, and market cap in column F
What You Get
- 100 rows, one per coin, populated in a single run
- Rank, name, symbol, price (USD), 24h change (%), and market cap written into the exact columns specified
- Numeric formatting preserved — market cap as a number, not text
- Any coin with a missing 24h change value flagged in a status note rather than silently dropped
What If the Data Is Not Quite Ready
The sheet already has headers in row 1 and data starting in row 2
Fetch the top 100 cryptocurrencies by market cap from Coinranking and write rank, name, symbol, price (USD), 24h change percent, and market cap into columns A through F starting at row 2, leaving row 1 headers intact
The market cap column is formatting as scientific notation
Fetch the top 100 coins by market cap from Coinranking, write the data into columns A through F starting at row 2, and format column F as a plain number with no scientific notation
You want to highlight the biggest movers as you import
Fetch the top 50 coins by market cap from Coinranking, write rank, name, symbol, price, 24h change, and market cap into columns A through F, then highlight rows where the 24h change is greater than +5% in green and rows where it's below -5% in red
Full cleanup and enrichment in one shot
Clear columns A through F from row 2 downward, fetch a fresh top 100 coins list by market cap from Coinranking, write rank, name, symbol, price (USD), 24h change percent, and market cap into those columns starting at row 2, highlight green any coin with a 24h gain above 5% and red any with a loss below -5%, and add a text note in column G for any coin missing a 24h change value
One prompt handles the stale-data problem, the formatting, the conditional highlighting, and the data-quality flag at once.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet where you track crypto rankings, then ask it to pull a fresh top-100 market-cap table from Coinranking. When you're done, see also Import Historical Crypto Price Data Into a Google Sheet for Backtesting and the Coinranking Google Sheets overview.