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.
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.
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.
Tidy it if you like: click a column header to drop it, double-click to rename it, × to remove a row.
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.
Open it on the first page and go to the Crawl tab.
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.
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.
Free or Pro: Free, with no limit on pages.
Try it on: six pages of products · seven kinds of Next button · a Load more button · 2,000 rows over 40 pages
Goes deeper: When a scraper only scrapes the first page · When it stops after a few pages
Watch it done: on YouTube
03 The right list on a busy page
The page has several lists — a sidebar, a carousel, two tables — and the outline is on the wrong one.
Open Wrong list? and press Another table until the outline sits on the list you want. The panel says how many others it found.
Or choose Pick manually and click a row of the data yourself; shift-click to add something outside it, like a price written above the table.
Crawl as usual. It pages the list you chose, by that list’s own pager, not a neighbour’s.
Free or Pro: Free.
Try it on: two tables on one page · five paged tables, one wanted · a category sidebar beside a table
Goes deeper: When a scraper is not working on a site
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.
Open the directory, then Start crawling to collect every listing on every page.
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.
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.
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.
Collect the list first, crawling its pages if it has them.
Turn on drill-down, preview the first item and confirm the fields. Every row gets them as detail: columns.
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.
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).
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.
Set the list up once — columns dropped, renamed, the right list chosen — and save it as a named setup.
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.
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.
Free or Pro: Pro.
Try it on: a price board that changes every minute
Goes deeper: Track a website’s price changes
08 Send the rows somewhere
The rows belong in a Google Sheet, a CRM or your own system, not a file on your desktop.
Free: open any table in Google Sheets in one click.
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.
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.
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.
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.
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.
Free or Pro: Free.
Try it on: a table inside a frame
Goes deeper: When a scraper is not working on a site · When a scraper misses data