Magic Scraper – Lead & Web Scraper to Excel by Magic Scraper

Magic Scraper turns any web page into a spreadsheet. Open it on a page with repeated data — product listings, directories, tables, search results or card grids — and it finds the rows and names the columns for you. Export to CSV, Excel or JSON.

Building a lead list? Business directories, chamber and association member lists and trade show exhibitor lists come out with every listing on every page — names, phones, emails and websites — with no credits and no per-lead limits.

Export to CSV, Excel, JSON or your clipboard, or paste the table into a new Google Sheet in one click. With Pro, send the rows to your own webhook: Zapier, Make, n8n or your server.

Keep it open in Firefox's sidebar beside the page while you click, or open it in a window of its own.

What it handles

• Tables, lists, directories and product grids, and lists split under headings (one table, with the heading as a column)
• Pagination of every kind — Next links, arrows, page numbers, Load more buttons and infinite scroll — in more than 80 languages
• The right list on a busy page: choose another table or point at the rows yourself, and it pages that list by its own pager
• Manual selection: click a row, shift-click anything else on the page to add it as a column
• Images, links, prices, badges, ratings and other page data
• schema.org markup, web components (open shadow roots) and same-origin iframes
• Multi-page scraping with randomized delays and rate-limit handling
• A "verify you're human" check stops the run and hands you the tab — it never tries to get past it

Drill-down. Need more from each result? Drill-down opens the page behind every row and adds its fields as new columns, as many levels deep as the data is buried. When that page holds a table — price breaks, branches, a category's products — each of its rows can become a row of yours, every page of it. The free version drills the first 3 rows of a run, so you can see what comes back before paying for the rest.

Private by design. Everything runs in your browser. No account, no analytics, no telemetry, and your scraped data is never sent to us. It goes only where you send it: a file, or your own webhook. Installing it opens a short welcome page on magicscraper.app, and removing it opens an optional one-question page asking why.

Free
Unlimited scraping, filtering, column editing, exports, and pagination with no page limit. Your setup for a site is remembered. Drill-down on the first 3 rows of a run, and one setup over a list of pages for the first 2 addresses. A long crawl that dies with its tab is offered back next time.

Pro — a one-time purchase, no subscription and no account

• Drill-down on every row
• Saved setups you can name, reuse on other sites and export
• Run one setup over a whole list of pages — every category, every town — merged into one sheet
• A Changes tab: what changed, what is new and what is gone since your last run
• Compare with a file — your CRM export or last month's list — read on your computer, never uploaded
• Run a saved setup on a schedule while Firefox is open
• Send rows to your own webhook (Zapier, Make, n8n or your server)

Practise on a sandbox built for it: https://magicscraper.app/demo
Every job, step by step: https://magicscraper.app/how-to-use-magic-scraper