Web scraper Chrome extension: how to use one, step by step
In short: A web scraper Chrome extension turns a public listing page into a spreadsheet without code. Install and pin it, open the page, check the detected columns, handle pagination, then export to Excel, CSV, or Google Sheets. Most beginner problems, such as empty columns, missing images, and duplicates, have quick fixes.
A point-and-click scraper extension turns a page you can already see in Chrome into rows in a spreadsheet. You don't write code, and you usually don't build selectors. This tutorial walks through the whole routine on a public listing page: install, check the columns, handle pagination, export, and fix the problems beginners usually run into. The steps apply to most extensions of this kind, and one section shows how ScrapeSheet does them.
Do you need a web scraper Chrome extension at all?
Not always. Check the simpler routes first, because they may be all you need:
| Situation | Try this first | Why |
|---|---|---|
| One short table | Copy and paste | It takes seconds |
| Site offers a CSV or an API | The official download | Clean data, provided by the site |
| Simple table that changes over time | Excel From Web or Sheets IMPORTHTML | Built in and refreshable |
| Repeating cards or lists | A scraper extension | Works on the page in your browser |
For the built-in routes, see our guides to Excel's Get Data from Web and scraping data into Google Sheets. If your data looks like the last row of the table, read on.
Step 1: Install and pin the extension
- Open the extension's page in the Chrome Web Store. Check the publisher, the last update date, and the reviews.
- Click Add to Chrome. Read the permissions Chrome lists, then confirm with Add extension.
- Click the puzzle-piece Extensions icon to the right of the address bar.
- Click the pin next to the extension so its icon stays on the toolbar.
Step 2: Open a public page and check the detected columns
Start with an easy page so you learn the tool instead of fighting the site. A Wikipedia list article, a public open-data portal, or the catalog on your own website are all good choices.
- Open the page and let it finish loading. If the list grows as you scroll, scroll to the bottom first.
- Click the extension icon and run the extraction. Tools of this kind look for tables and repeating lists.
- If the tool offers more than one table or list, choose the one you came for.
- Compare the result with the page. Check the first row, the last row, and the row count.
- Look down each column. Every cell should hold one kind of data: a name, a price, or a link.
The row count is the fastest test. If the page shows 20 items and you get 26 rows, the tool probably caught a menu or a promoted block as well. If you get 12, the rest of the list may not have loaded yet.
Step 3: Handle pagination, then export
Follow the pages
Scroll to the end of the list and see how it continues: numbered pages, a Load more button, or infinite scroll. Our guide to scraping multiple pages explains each type. Whatever the type, work in this order:
- Extract the first page and check the columns. Any problem here repeats on every page.
- Run a short test of two or three pages if your tool can follow pages.
- Check that the total is close to the rows per page multiplied by the number of pages.
- Run only the pages you need, at a pace that doesn't strain the site.
If the site shows a captcha or blocks you, stop. Look for an official download or API, or ask the site owner for the data.
Choose the export format
- Excel: pick
.xlsxif your tool offers it. For a CSV file, use Data > From Text/CSV in Excel. - CSV: the usual choice for importing the data into other software.
- Google Sheets: use File > Import > Upload with a CSV file, or paste from the clipboard.
How to do it with ScrapeSheet
ScrapeSheet follows the same routine with very little setup. Our no-code web scraper page has the overview.
- Install ScrapeSheet from the Chrome Web Store and pin it.
- Open a page and click the ScrapeSheet icon to open the panel.
- Click Extract. It detects tables and lists on its own.
- Export to Excel (
.xlsx), to CSV, or to the clipboard. For Google Sheets, paste from the clipboard or import the CSV. - If you have Pro and the page is messy, paste your Claude or OpenAI key in Settings and describe what you want, such as "get name, price and link."
Know the limits before you start. The free plan allows up to 20 rows per export and one page per run, which suits short lists and first tests. ScrapeSheet Pro costs €12.99 per month (taxes calculated at checkout), and you can cancel anytime. It removes the row limit, covers all pages, and adds AI extraction with your own key. The use cases page shows other jobs it handles.
How do you fix common scraping problems?
Empty columns
The value may not have loaded yet, or it may appear only on a detail page or when you hover over an item. Reload the page, let it finish, scroll past the data, and run the extraction again. To measure the gap, count the blank cells in a column. For 20 rows of data in column B, this works in both Excel and Google Sheets:
=COUNTBLANK(B2:B21)
If a value exists only on the detail page, the listing can't supply it. That isn't a bug in the tool. Delete the column or collect that field another way.
Lazy-loaded images
Many sites load an image only when it gets close to the screen. Until then, the page may hold a placeholder instead of the real file. If every row shows the same image URL, you have probably captured the placeholder. Scroll slowly through the whole list, wait for the images to appear, and extract again. A copied link also doesn't give you the right to reuse the image, so check its license before you publish it.
Duplicate rows
Listings can shift while you move between pages, and promoted items may repeat on each one. Keep a copy of the raw export, then remove the repeats:
- Excel: select the data and use Data > Remove Duplicates.
- Google Sheets: select the data and use Data > Data cleanup > Remove duplicates.
In both tools, compare only a column that identifies each item, such as its URL. Two different products can share a name or a price.
Garbled characters
If accented letters look wrong when you open a CSV in Excel, import it with Data > From Text/CSV and set File Origin to 65001: Unicode (UTF-8).
Use public data and respect the site. Read the site's terms before you start, and never work around logins, captchas, paywalls, or rate limits. The robots.txt file is written for crawlers, but it's a useful signal of what the owner wants. RFC 9309 describes its rules as requests to crawlers, not as access control. Names, emails, and phone numbers are personal data even when they're public, so the GDPR can apply. You then need a lawful basis, such as legitimate interest (see the EDPB guidelines, version 1.0 for public consultation). Collect only what you need, and honor people's right to object. This is general information, not legal advice. Our guide on whether web scraping is legal goes further.
More step-by-step guides are on the ScrapeSheet blog.
FAQ
How do you use a web scraper Chrome extension?
Install it from the Chrome Web Store and pin it. Open a public page, run the extraction, and compare the rows and columns with the page. Then export the result to Excel, CSV, or Google Sheets.
Is there a free web scraper Chrome extension?
Yes. Several extensions offer a free plan, usually with limits, so check them before you start a big job. ScrapeSheet's free plan extracts tables and lists and exports to Excel or CSV, with up to 20 rows per export and one page per run.
How do I handle pagination with a web scraper Chrome extension?
First see whether the list uses numbered pages, a Load more button, or infinite scroll. Extract one page, check the columns, and then run a short test before you collect everything. ScrapeSheet's free plan covers one page per run, and Pro covers all pages.
Why are some columns empty after scraping?
The value may not have loaded yet, or it may appear only on a detail page or when you hover over an item. Reload the page, scroll past the data, and extract again. If the value isn't on the listing page at all, the tool can't collect it from there.
Can I use a scraper extension on any website?
No. Stick to public pages, read each site's terms, and never work around logins, captchas, paywalls, or rate limits. If the data identifies people, data protection rules such as the GDPR can apply. This is general information, not legal advice.
Sources
- RFC 9309: Robots Exclusion Protocol (RFC Editor)
- EDPB Guidelines 1/2024 on processing of personal data based on Article 6(1)(f) GDPR (version 1.0, for public consultation)
General information, not legal advice. Always check the website's terms and the data-protection rules that apply to you.
Web Scraper is a trademark of its owner; ScrapeSheet is not affiliated with it. Comparisons are based on publicly documented features as of November 2026 and may change.