The Scenario
It's a Wednesday afternoon and you're three hours into a market entry presentation for the UK fintech space. Your manager asked for a slide showing the major players — specifically, the top 30 fintech websites ranked by UK traffic. You assumed SimilarWeb would have this. It does. What you didn't assume is that getting it into your Excel workbook — where the rest of the analysis lives — would require exporting, reformatting, and reconciling a file that doesn't quite match your column structure.
The bad version:
- Navigate to SimilarWeb's top-sites tool, apply the Finance category and United Kingdom filters, screenshot or manually note the top results because the export option requires a higher-tier plan.
- Open the workbook, create two columns (Domain, Global Rank), and start typing in what you saw on the screen — pausing every few rows to flip back to the browser and verify you didn't miss one.
- Realize the slide needs to show both the domain and the rank number, go back, add the rank column, and re-enter or copy-paste the ranks for all 30 rows.
The presentation is going to your director tomorrow morning. Reformatting data by hand at 4pm is not what you signed up for.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook and talks to the SimilarWeb DigitalRank API on your behalf — including the filtered top-sites endpoint that lets you scope by country and category.
Fetch the top 30 websites from SimilarWeb filtered to the Finance category and United Kingdom and write each site's domain and global rank into columns A and B.
What You Get
- Column A fills with 30 domain names, starting at the top-ranked UK fintech site.
- Column B fills with each site's global rank — the numeric position SimilarWeb assigns globally, even though the filter scoped the list to UK Finance.
- The data lands in row order (rank 1 at the top), ready to copy into your slide or continue analyzing in the workbook.
What If the Data Is Not Quite Ready
You need multiple countries in the same workbook
Fetch the top 20 websites from SimilarWeb for each country listed in column A (filtered to Finance) and write domain, global rank, and country as rows grouped by country into columns B, C, and D.
You want the top sites for several categories, not just Finance
For each category name in column A of my sheet, fetch the top 10 globally ranked websites in that category from SimilarWeb and write the domain names and global ranks as rows grouped by category into columns B and C.
You need to cross-reference the results against your existing watchlist
Fetch the top 50 websites from SimilarWeb filtered to Finance and United Kingdom, write domain and global rank into columns A and B, then check each domain against my 'Watchlist' worksheet column A and flag any matches with "ON WATCHLIST" in column C.
Full kill-chain: filter, fetch, cross-reference, and summarize
Fetch the top 30 UK Finance websites from SimilarWeb, write domain and global rank into columns A and B, flag any domain that appears in my 'Existing Partners' worksheet column A with "PARTNER" in column C, then add a summary row at the bottom counting how many of the top 30 are already partners.
One prompt handles the full chain — API call, write-back, cross-reference, and summary — so the analysis is sitting there when you open the workbook next.
Try It
Open an Excel workbook and Get the 7-day free trial of SheetXAI — ask it to pull the top 30 SimilarWeb-ranked Finance sites for any country you're analyzing, written directly into your columns. From there, see how to enrich a competitor domain list with global ranks or return to the SimilarWeb DigitalRank API overview.