The Scenario
You took over the sector research deck from someone who left the team last month. Their methodology was sound — they'd built a benchmark universe of the top 20 websites in each of five industry verticals, pulled from SimilarWeb, to identify the dominant market players for an investor report. The problem is they left a note saying the data was "last updated Q3" and the underlying workbook has a separate worksheet for each category, all manually populated, with no record of how they pulled it.
Your job is to rebuild it cleanly, in a single flat table, and get it current before the investor call on Friday.
The bad version:
- Open SimilarWeb's top-sites tool, select the first category, note the top 20 domains and their ranks, paste them into the workbook with a category label in column C.
- Switch to the second category, repeat — being careful not to lose your scroll position in the workbook while flipping between browser tabs.
- On the fourth category, realize two of your domain entries are duplicates from a previous category and you've been writing them into the wrong rows because you lost count.
You were hired to analyze market structure, not to manually transcribe ranking data that an API can return in seconds.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook — including any list of category names you've already set up — and pulls the top-site data from SimilarWeb's DigitalRank API across all your verticals in one pass.
Pull the top 20 websites from SimilarWeb for each category listed in column A and write domain, global rank, and category into a flat table on the 'Top Sites' sheet.
What You Get
- The 'Top Sites' worksheet fills with a flat table: domain in column A, global rank in column B, category label in column C.
- All five categories land in one worksheet, grouped by category, so sorting and filtering across the full universe is immediate.
- No duplicate handling required — SheetXAI writes one entry per domain per category pass.
What If the Data Is Not Quite Ready
Your category column uses internal names that don't match SimilarWeb's filter labels
Column A has our internal sector names — map them to SimilarWeb category labels using the notes in column B, then fetch the top 20 websites for each mapped category and write domain, global rank, and original sector name into the 'Top Sites' worksheet.
You want to cross-check the universe against a prior watchlist
Fetch the top 20 SimilarWeb websites for each category in column A, write domain, global rank, and category into the 'Top Sites' worksheet, then flag any domain that appears in my 'Watchlist' worksheet with "TRACKED" in a fourth column.
You need country-scoped results instead of global
For each category in column A, fetch the top 20 websites from SimilarWeb scoped to the United States, and write domain, US-scoped rank, and category into a flat table on the 'US Top Sites' worksheet.
Full kill-chain: fetch, deduplicate, flag, and rank across categories
Pull the top 20 websites for each category in column A from SimilarWeb, write domain, global rank, and category into the 'Top Sites' worksheet as a flat table, deduplicate any domain that appears in multiple categories (keeping the highest-ranking instance), and add a column marking duplicates as "MULTI-CATEGORY."
That one prompt rebuilds the benchmark universe, deduplicates across verticals, and surfaces cross-category leaders — all without a second pass.
Try It
Open an Excel workbook with your list of industry verticals in column A and Get the 7-day free trial of SheetXAI — ask it to pull the top 20 SimilarWeb-ranked sites for each one into a clean flat table. Then explore how to enrich a specific domain list with global ranks or go back to the SimilarWeb DigitalRank API overview.