Back to Scrapfly in Excel
SheetXAI logo
Scrapfly logo
Scrapfly · Excel Guide

Bulk Screenshot Competitor Landing Pages and Store URLs in a Excel workbook

2026-05-14
5 min read

The Scenario

You are a UX designer preparing a competitive teardown for a new landing page redesign. You have 40 competitor landing page URLs collected over the past month in column A of your Excel workbook. The design review is Monday. You need screenshots of every page in a shared deck by Friday afternoon so the team can annotate and compare layouts before the weekend.

You have never used a screenshot API before. You do not have time to learn one.

The bad version:

  • Take each URL, open it in a browser, use a full-page screenshot extension, wait for it to load (some pages block extensions), save the file with a manually typed filename, upload to a shared drive, copy the link, paste it back into column B — 40 times
  • Discover that seven pages have cookie consent overlays covering the content in the screenshot, go back and manually dismiss them before re-capturing
  • Run out of browser extension quota halfway through, switch to a different tool, now your screenshots are inconsistent sizes and formats

The deck is due Friday. Your time is better spent on the analysis — which layouts convert, which CTAs are buried, which pages look like they were built in 2018 — not on screenshotting 40 URLs one at a time.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent that lives inside your Excel workbook. It reads the URLs in column A, calls Scrapfly's screenshot API for each one with JavaScript rendering enabled, and writes the returned screenshot URL back into column B — all 40 in one pass.

For each URL in column A, use Scrapfly to capture a full-page screenshot with JavaScript rendering enabled and write the returned screenshot URL into column B

What You Get

  • Column B fills with a Scrapfly-hosted screenshot URL for each landing page in column A
  • Screenshots are full-page captures, not viewport-only — scroll-dependent content is included
  • JavaScript rendering is applied, so dynamically loaded hero images and above-the-fold animations appear in the capture
  • Any URL that failed to capture returns an error note in column B rather than a blank cell

What If the Data Is Not Quite Ready

Pages with GDPR consent overlays will have the banner covering the hero in the screenshot. Ask SheetXAI to handle this:

For each URL in column A, use Scrapfly to capture a full-page screenshot with JavaScript rendering and attempt to dismiss cookie consent overlays before capturing — write the screenshot URL into column B

You need screenshots at a specific viewport width for mobile comparison

If your teardown includes mobile layout analysis alongside desktop:

For each URL in column A, capture two screenshots using Scrapfly — one at 1440px viewport width (desktop) and one at 390px (mobile) — write the desktop screenshot URL into column B and the mobile screenshot URL into column C

You want to annotate which screenshots look outdated before sharing the deck

Your team is going to assess design age visually, but you want a rough pre-sort. After screenshotting, ask SheetXAI to add a preliminary note:

For each URL in column A, capture a full-page screenshot using Scrapfly and write the URL into column B, then in column C note whether the page title or URL contains any indicators of age (year in slug, "v1," "old," or similar) — mark those rows as Likely Outdated

You want the screenshots captured, grouped by competitor, and prepped for a slide outline in one pass

For each URL in column A, capture a full-page screenshot using Scrapfly and write the URL into column B, then in column C extract the competitor name from the domain, and in column D write a one-line description of the apparent page type (homepage, product page, pricing page, landing page) based on the URL structure

One pass, and the deck has a structure to build from.

Try It

Get the 7-day free trial of SheetXAI and open your competitor URL list in Excel, then ask it to capture full-page screenshots using Scrapfly and write all the image URLs into column B. You can also use SheetXAI to extract structured data from those same pages — see the spoke on scraping competitor product prices for the data-extraction angle.

Stop memorizing formulas.
Tell your spreadsheet what to do.

Join 4,000+ professionals saving hours every week with SheetXAI.

Learn more