The Scenario
You are a growth marketing director at a company with five company domains in an Excel workbook, a mix of regional sites and product sub-brands. Quarterly landscape review is next week. You need the top 10 organic search competitors for each domain from Semrush, with common keyword count and authority score, all in one flat table.
The first question at the review will be: "Who are we actually competing against, and how big are they?"
The bad version of this week:
- You open Semrush and pull the organic competitors report for Domain 1
- You export it, paste it into a tab, label it
- You repeat for four more domains
- You now have five tabs and no single view
- You manually copy rows into a summary tab, forgetting to add the Domain column on tab three
- You spend Wednesday rebuilding the summary table with correct domain labels.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the domain list from the workbook and pulls the organic competitor data for each domain from Semrush, assembling it all into one flat table.
Open the SheetXAI sidebar and type:
For each domain in column A of the Domains tab, fetch its top 10 organic search competitors from Semrush and write each competitor domain, common keyword count, and authority score into new rows in a Competitors tab. Include an OurDomain column so I can filter by which of my domains each competitor belongs to.
SheetXAI iterates through all five domains, pulls competitor data for each, and builds the Competitors tab with an OurDomain column keeping everything attributed.
What You Get
A single Competitors tab with up to 50 rows:
- Column A — OurDomain — which of your five domains this row belongs to
- Column B — CompetitorDomain — the competing site
- Column C — CommonKeywords — keywords both domains rank for
- Column D — AuthorityScore — Semrush authority score of the competitor
Sort by OurDomain, then CommonKeywords descending. The competitors with the most keyword overlap are your real search rivals.
What If the Data Is Not Quite Ready
Competitor lists need context to be actionable.
When you want a deduplicated view of competitors across all domains
The same large competitor shows up in the top 10 for four of your five domains. You want a consolidated view.
After building the Competitors tab, create a deduplicated view in a new tab called CompetitorSummary. For each unique competitor domain, list the CompetitorDomain, AuthorityScore, and which of our domains it appears as a competitor for, as a comma-separated list in a DomainsOverlapping column.
When you want to flag high-authority competitors only
Your team only wants to monitor competitors with authority score above 40.
Pull top 10 organic competitors per domain as above. In the Competitors tab, add a Priority column: "Track" for competitors with authority score above 40, "Ignore" for those below. Sort so "Ignore" rows appear at the bottom.
When you need common keyword count and SE traffic together
Common keywords alone do not show the full threat. A competitor with 200 shared keywords and massive organic traffic is more dangerous than one with 500 shared keywords and minimal traffic.
For each domain in column A of the Domains tab, fetch its top 10 organic competitors from Semrush. Write competitor domain, common keyword count, SE traffic estimate, and authority score into the Competitors tab with an OurDomain column. Sort by SE Traffic descending within each domain group.
When the quarterly review needs data, a threat ranking, and a summary narrative in one pass
The deck needs numbers and prose.
For each domain in column A of the Domains tab, fetch the top 10 organic competitors from Semrush. Write competitor domain, common keywords, SE traffic, and authority score into a Competitors tab with an OurDomain column. Rank competitors by a composite threat score: common keywords × 0.4 + authority score × 0.6, normalized to 100. Write the threat score in a ThreatScore column. Then write a 2-sentence summary for each of our five domains at the top of the Competitors tab describing who the top competitor is and why they are the biggest search threat.
The pattern: the data pull, the scoring, and the narrative for the deck all come from one prompt.
Try It
Get the 7-day free trial of SheetXAI and put your domains in column A of any Excel workbook, then ask it to build the competitive landscape table. The Semrush integration is included in every SheetXAI plan. For a related workflow, see how to research the paid search landscape from Semrush in Excel or the Semrush in Excel overview.