Bulk Captures
Windows 10 & 11 Buy license · $39.95
Website screenshots

How to Screenshot Every URL in an Excel List

Screenshot URLs from an Excel list on Windows: clean the column, export it to CSV or text, load it into a batch capture and match each image to its row.

Updated 5 minute read The Bulk Captures team

To screenshot URLs from an Excel list, clean up the URL column so every row holds one complete address, export that column to a CSV or plain text file, then load the file into a batch screenshot tool that visits each URL and saves an image. The key to a good result is the preparation in Excel: fixing missing https://, removing duplicates and blank rows, and deciding how each screenshot will be matched back to its row. This guide covers each step, with formulas you can paste straight into your sheet.

If your list is short, you can open each link and capture it by hand. Past twenty or so rows, a batch run is far quicker and the results are consistently named.

Step 1: Get the URLs into one clean column

Spreadsheets of URLs come from everywhere: CRM exports, SEO crawls, product feeds, a colleague's research. They rarely arrive tidy. Start by copying the URL column into a new sheet so you can clean it without touching the original data.

Remove spaces and stray characters

Pasted URLs often carry leading or trailing spaces, which can make an address fail. In an empty column next to your URLs (assume they start in A2), enter:

=TRIM(CLEAN(A2))

Fill the formula down, then copy the column and use Paste Special → Values to replace formulas with plain text.

Add https:// where it is missing

A list of bare domains such as example.com may work, but full addresses avoid guesswork. This formula adds the prefix only when it is missing:

=IF(LEFT(A2,4)="http",A2,"https://"&A2)

If you know every row needs the prefix, ="https://"&A2 or =CONCAT("https://",A2) does the same job. CONCAT is available in Excel 2019 and Microsoft 365; the & version works in every version.

Extract URLs from hyperlinked cells

If cells show friendly text such as "Product page" with a link behind it, the address is not in the cell value. You can right-click a cell and choose Edit Hyperlink to see it, one cell at a time. For a long list, the quickest route is usually to re-export the data from its source with the raw URLs included.

Step 2: Remove duplicates and junk rows

  1. Select the cleaned column.
  2. Go to Data → Remove Duplicates and click OK.
  3. Sort the column A to Z, which groups blank cells and obvious junk (such as "N/A" or email addresses) together so you can delete them.
  4. Use Home → Find & Select → Replace to strip tracking parameters if you do not need them. For example, find ~?utm_* and replace with nothing. The tilde tells Excel to treat the question mark as a real character rather than a wildcard.

Watch for near-duplicates that Remove Duplicates will not catch: the same page with and without a trailing slash, or with www. and without. They lead to the same page and waste capture time.

Step 3: Decide how screenshots will match your rows

This is the step most people skip, then regret. Once you have 300 images, you need to know which belongs to which row. There are two reliable approaches.

ApproachHow it worksBest when
Name by domainEach file is named after the site, such as example.com_001.pngEach row is a different website
Name by row orderA zero-padded counter follows the list order, such as 001.png, 002.pngMany rows share a domain, such as product pages on one store

If you name by counter, keep the list order fixed: do not re-sort the sheet after exporting, or the numbers will no longer line up. Add a column in Excel with the expected file name so you can link straight to it later:

=TEXT(ROW()-1,"000")&".png"

That gives 001.png for row 2, 002.png for row 3 and so on. For more naming ideas, see our guide on how to automatically name screenshots.

Step 4: Export the column to CSV or text

Batch screenshot tools read plain files, not .xlsx workbooks. The simplest file is one that contains only the URLs, one per line.

As CSV from Excel

  1. Put the cleaned URLs in column A of a new sheet, with no header row if your tool does not expect one.
  2. Choose File → Save As (or Save a Copy).
  3. Set the type to CSV UTF-8 (Comma delimited) and save. Excel warns that only the current sheet is saved; that is what you want.

As plain text via Notepad

  1. Select the cleaned URL cells and press Ctrl+C.
  2. Open Notepad, paste, and check there are no blank lines at the end.
  3. Save as urls.txt.

Step 5: Run the batch

Bulk Captures can load a TXT or CSV file of URLs directly, or you can paste the column straight in. Then:

  1. Choose the URL capture mode and load your file.
  2. Pick visible area or full page, and the viewport widths you need, such as 1920 for desktop and 390 for phone.
  3. Set a load delay of 2 to 5 seconds so fonts and images finish loading.
  4. Set the naming pattern you chose in Step 3, for example {domain}_{n} or {n}, plus the format and output folder.
  5. Run a test with the first ten rows, check the images, then run the full list.

Bulk Captures works through the list in order, waits for each page, retries pages that fail and saves every image under the name you set. Because it runs on your own PC there is no per-capture limit, so a 500-row sheet is the same effort as a 50-row one. The general batch workflow, including how to spot failed captures, is covered in our guide to screenshotting multiple websites at once.

With a predictable file name in each row, you can turn the sheet into an index of your screenshots. If the images are in D:\Captures\2026-10-05\ and the expected file name is in column C, this formula creates a clickable link:

=HYPERLINK("D:\Captures\2026-10-05\"&C2,"Open")

Click any link to open that row's screenshot. If you share the workbook, keep the images in a folder next to it and use a relative path instead.

Common problems

  • Every capture fails: check the file in Notepad. Extra quotes around each URL, a header row or semicolons from a regional CSV format can all confuse the import.
  • Some rows produce error pages: those URLs may be broken, redirected to a login page or blocking automated visits. Filter them out and check them in a browser.
  • File names do not match rows: the sheet was re-sorted after export, or blank rows were removed from the file but not the sheet. Re-export from the final, sorted sheet.
  • You want every page of one site: skip Excel and use the site's sitemap. See how to screenshot all pages of a website.

Frequently asked questions

How do I get URLs out of Excel for a screenshot tool?

Copy the URL column into a new sheet and save it as CSV, or paste it into Notepad and save it as a text file with one URL per line.

Do URLs need https:// in front?

It is safest to include the full address with https://. Add it in Excel with a formula such as =CONCAT("https://",A2) if your list only has domains.

How do I match screenshots back to rows in my spreadsheet?

Name the files by domain or by a counter that follows the row order, then add a column in Excel with the matching file name.

Get three guides like this every month, plus software update notices.Subscribe →