Guide

Nine jobs, start to finish.

Most people come to Magic Scraper with one of nine jobs. Here is each one: the situation, the steps in the extension, what is free and what is Pro, a practice page to try it on, and the guide that goes deeper.

Get Magic Scraper free Chrome, Edge and Firefox. No account.
  1. A table into Excel, right now
  2. Every page of a list, not just the first
  3. The right list on a busy page
  4. A lead list from a directory
  5. The details behind each row
  6. Every category, in one sheet
  7. Watch for changes
  8. Send the rows somewhere
  9. When a page fights back

01 A table into Excel, right now

You are looking at a table, a price list or a grid of cards, and you want it in a spreadsheet.

1

Open the page and click the Magic Scraper icon. It outlines the data it found and shows it as a table, with the columns named from the page.

2

Tidy it if you like: click a column header to drop it, double-click to rename it, × to remove a row.

3

Press Export CSV, or the arrow beside it for Excel or JSON, or open it straight in Google Sheets.

Free or Pro: Free.

Try it on: a trade price list · a grid with no table in it

Goes deeper: Copy a table from a website to Excel

Watch it done: on YouTube

02 Every page of a list, not just the first

The list goes on over page 2, 3, 40 — or loads more as you scroll or click.

1

Open it on the first page and go to the Crawl tab.

2

Press Start crawling. It finds the way to the next page itself: a Next link, an arrow, page numbers, “Older posts”, a word in another language, or a Load more button. For a feed that loads as you scroll, tick Infinite scroll first.

3

Watch the count climb. Stop whenever you like and keep what it has; if the tab dies, open the extension again and it offers to recover the rows.

04 A lead list from a directory

A trade directory, a chamber of commerce or an association lists businesses — and their email, website and hours are on each one’s profile.

1

Open the directory, then Start crawling to collect every listing on every page.

2

On the Crawl tab, turn on drill-down and preview the first profile. Confirm what to take, and each profile’s details become columns on every row.

3

With Pro, Compare with a file: load your CRM export or last month’s list, and the rows marked new are the businesses you do not have yet.

4

Export, and keep to business details: the guides below cover the rules.

Free or Pro: Listing and exporting are free; drill-down reads the first 3 profiles free and every profile with Pro.

Try it on: 24 businesses with profile pages

Goes deeper: Build a B2B lead list · Scrape a business directory · Is it legal to scrape a business directory?

Watch it done: on YouTube

05 The details behind each row

The list has a name and a price; the SKU, the material and the lead time are on each item’s own page.

1

Collect the list first, crawling its pages if it has them.

2

Turn on drill-down, preview the first item and confirm the fields. Every row gets them as detail: columns.

3

If the detail page holds a table — price breaks, branches, variants — tick Every row of its table — one row each to get one row per line of it. Buried deeper? Add another level and follow a link from that page too.

Free or Pro: The first 3 rows free; every row, and chains of levels on every row, with Pro.

Try it on: price breaks on each product page · a ten-level link chain

Goes deeper: How drill-down works

06 Every category, in one sheet

The site splits what you want across categories, towns or brands, each with its own pages.

1

From the category list: choose it with Another table, then drill-down with Every row of its table — one row each. Each category’s table comes back a row per item, with the category on every row, its later pages included (from version 2.1).

2

From a list of addresses: on the Crawl tab, paste the category or town addresses into Run this on a list of pages. Each one is crawled with the same setup, and the rows come back as one sheet with a column saying which list each came from.

Free or Pro: A list of pages runs on the first 2 addresses free and on every address with Pro.

Try it on: six categories, 74 parts

Goes deeper: Scrape a list of URLs

07 Watch for changes

Prices, stock or listings move, and you want to know what changed since last time.

1

Set the list up once — columns dropped, renamed, the right list chosen — and save it as a named setup.

2

Run it again later: the Changes tab compares the run with the last one. Match rows on something stable, like a SKU, and it lists what was added, removed and changed.

3

Put the setup on a schedule and it runs while your browser is open; a run missed while it was closed happens when you next open it.

08 Send the rows somewhere

The rows belong in a Google Sheet, a CRM or your own system, not a file on your desktop.

1

Free: open any table in Google Sheets in one click.

2

With Pro, Send to Google Sheets adds the rows to a sheet of yours, and Send to webhook posts them to Zapier, Make, n8n or your own server — by hand or after every scheduled run.

3

Nothing goes anywhere you did not choose: the rows travel from your browser to your sheet or your address, not through us.

Free or Pro: Open in Google Sheets is free; sending to a sheet or a webhook is Pro.

Goes deeper: Scrape a website into Google Sheets · Receive scraped rows on a webhook

09 When a page fights back

The page asks if you are human, the table is in a frame from another site, or the grid is a picture.

1

A bot check: the run stops and hands you the tab. Clear it yourself and press Start to carry on from the page it never read; the extension never tries to get past one.

2

A table shown in a frame from another site: browsers keep every extension out of it. Open the frame’s address in its own tab and it is an ordinary page — from version 2.1 the panel offers to do that for you.

3

A grid drawn on a canvas is a picture with no text to read; the panel says so rather than handing you an empty table.