The Scenario
You're the category manager for a consumer electronics retailer. Your job this week is to put together a product comparison table — every product across ten Amazon and Best Buy search result pages, with name, price, and rating. You've done this before. The last time, you built it by opening each page, scrolling to the bottom, and adding rows one product at a time.
Ten search result pages sounds manageable. Ten search result pages with 24+ products each, dynamically loaded, across two different site layouts, is something else.
The bad version:
- Open the first search result page. Scroll. Count. Start adding rows to the workbook — product name, price, rating.
- Realize by page three that Best Buy and Amazon format prices differently. Spend time normalizing as you go.
- Hit page six and lose track of which products you've already added. Start seeing duplicates.
Nobody hired you to manually transcribe search results. The value you bring is in what you do with the data — not in the hour and a half it takes to collect it.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook and through its built-in ScrapingBee integration it can scrape full search result pages — JavaScript rendering included — and write every product it finds into a new worksheet as individual rows.
For each search result page URL in column A, use ScrapingBee to scrape the page with JavaScript rendering and extract all product names, prices, and star ratings found on the page — write one row per product in a new worksheet called All Products.
What You Get
- A new worksheet called "All Products" with one row per product found across all ten pages.
- Columns for product name, price (as listed), and star rating.
- A source URL column so you know which search page each product came from.
- Duplicate products (same name appearing across multiple pages) included — you control dedup in a follow-up step if needed.
What If the Data Is Not Quite Ready
Prices from Amazon and Best Buy come back in different formats — "$1,299.99" on one, "From $1,299" on another
After compiling all products into the All Products worksheet using ScrapingBee, normalize the price column — strip "From" prefixes, remove commas, extract numeric values only, and write clean prices into a Price Normalized column so I can sort the full table.
Some search result pages paginate — you need page 2 results too, but only page 1 URLs are in column A
For each URL in column A, use ScrapingBee with JavaScript rendering to scrape the first page of results and extract all products into the All Products worksheet — then check whether a "Next Page" or page 2 link exists on each result page and, if so, scrape that page too and append its products to the same worksheet.
You want to filter the compiled table to only products rated 4.0 or above before presenting it
After compiling all products into the All Products worksheet using ScrapingBee, filter to rows where the star rating is 4.0 or above — write the filtered set into a new worksheet called Top Rated with the same columns, sorted by price ascending.
Kill chain: scrape all ten search pages, compile products, normalize prices, deduplicate by product name, and output a clean comparison table sorted by rating
For each URL in column A, use ScrapingBee with JavaScript rendering to extract all product names, prices, and ratings — compile into the All Products worksheet, normalize prices to numeric values, deduplicate rows where the same product name appears more than once (keep the lowest price), and output the final table sorted by star rating descending into a worksheet called Comparison Table.
The goal was a comparison table. This gets you one without a detour through ten browser tabs.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with e-commerce search result page URLs in column A, then ask it to compile all listed products using ScrapingBee. See also: Scrape Anti-Bot-Protected Sites Into an Excel workbook Using Stealth Proxy and the full ScrapingBee integration overview.