The Scenario
You're a competitive analyst at a SaaS company. Your head of product asked for a pricing comparison across 80 competitors — tiers, key differentiators, taglines — by end of week. You already collected the URLs into column A of an Excel workbook three weeks ago. That part felt like progress.
Now it's Thursday afternoon, and the actual work of filling in columns B through D hasn't happened.
The bad version:
- Open URL 1, find the pricing page, manually note the tier names and prices in column B, read the feature bullets and condense them into column C, find the tagline buried in the hero section and paste it into column D
- Repeat for URL 2, then URL 3, then realize the pricing page moved and you're on the blog now, go back, fix the row
- By URL 12 you're abbreviating tier descriptions in ways that make the data inconsistent across rows, and by URL 40 you've stopped reading feature bullets and are writing "see site"
Your product lead is expecting a slide deck built from this workbook on Friday morning. The workbook in its current state couldn't support a single chart.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads your URL list, understands the columns, and uses its built-in ScrapeGraph AI integration to run SmartScraper across every row — then writes the extracted fields directly back into your columns.
Open the SheetXAI sidebar and paste this:
For each URL in column A, use ScrapeGraph AI SmartScraper to extract pricing tiers, key features, and company tagline, then write the results into columns B, C, and D
What You Get
- Column B fills with pricing tier names and price points, formatted consistently across all 80 rows
- Column C fills with the 2-5 key product features listed on each pricing page
- Column D fills with the company tagline or hero headline from the page
- Rows where ScrapeGraph AI can't reach the page get flagged with a note rather than left blank
What If the Data Is Not Quite Ready
Some pricing pages require a plan selection before showing prices
For each URL in column A where column B is blank after the first scrape pass, re-run ScrapeGraph AI SmartScraper with the prompt: extract any pricing information visible without clicking, including plan names, starting prices, and any visible tiers
Competitor sites use different terminology for the same tier concept
Normalize the pricing tier values in column B: consolidate variations like "Starter", "Basic", "Free Plan", and "Lite" into a single label "Entry", and "Professional", "Pro", "Growth" into "Mid-Tier", then flag any value that doesn't fit either category in column F
You need features compared against a fixed list, not free-text extraction
For each row, compare the features in column C against this reference list in column G and mark column H with which reference features were mentioned, which were absent, and which the competitor added that aren't on our list
Cleanup plus extraction plus formatting in one pass
For the 80 URLs in column A: scrape pricing tiers, key features, and tagline using ScrapeGraph AI SmartScraper; normalize all prices to USD with two decimal places; deduplicate any repeated feature phrases within a single cell; flag rows where the tagline is longer than 10 words; write cleaned results into columns B, C, and D and a summary row in row 82 counting how many competitors have more than 3 tiers
The cleaner the extraction prompt, the less cleanup you do after. Ask for normalization and deduplication in the same instruction.
Try It
Open an Excel workbook with competitor URLs in column A, then Get the 7-day free trial of SheetXAI and ask it to run ScrapeGraph AI SmartScraper across your list and populate pricing tiers, features, and taglines. For related tasks, see how to enrich a lead list with web data or apply a consistent schema across a URL batch.