SheetMagicSheetMagic

Free Web Scraper: Website Content into Google Sheets

Enter a web page and we read it plus the pages it links to below it, with the title, description, meta keywords, word count and full text of each. You see up to 5 pages here; install SheetMagic free to get every result in Google Sheets.

Try

Results show here on the page, not in your inbox. Your email caps free runs per person. We send one email asking you to confirm it; nothing else comes unless you click it. Privacy policy

Free. Up to 5 results, in up to about a minute.

Your results

Run a search above. The rows land in this sheet.

RowURLTitleDescriptionAuthorLanguageCrawl DepthContent (Markdown)Content (Text)Word CountCanonical URLMeta KeywordsFinal URLFound On
1
2
3
4
5

Install SheetMagic to get every result in Google Sheets

The same scraper runs from a formula in your sheet and writes every row there. The free plan includes 100 one-time scraping credits.

Free web scraper for Google Sheets, in short

To scrape a website into Google Sheets, install the free SheetMagic add-on, put a start page in A2 and type =CRAWL(A2, 10, 1). It reads that page and the pages linked below it, then writes one row per page to a results tab with the title, description, meta keywords, word count and full text. Each crawled page uses 84 scraping credits; the free plan includes 100.

13 columns for every result

Each result is one row, with these columns in this order. Fields the source does not show stay blank.

  1. URL
  2. Title
  3. Description
  4. Author
  5. Language
  6. Crawl Depth
  7. Content (Markdown)
  8. Content (Text)
  9. Word Count
  10. Canonical URL
  11. Meta Keywords
  12. Final URL
  13. Found On

From this page to your sheet

  1. 1. Try it on this page

    Type a web page, add your email and press run. We read it and the pages it links to below it, and show up to 5 pages with their title, description and text. No install needed.

  2. 2. Install SheetMagic for free

    Add SheetMagic from the Google Workspace Marketplace and click Activate. No card and no separate account. The free plan includes 100 one-time scraping credits.

  3. 3. Get every result in Google Sheets

    Put a start page in A2 and type =CRAWL(A2, 10, 1). The crawl runs in the background and writes one row per page to a new results tab, with the full text in Markdown and plain text.

Who uses it, and for what

SEO audits of a blog or docs site

Crawl a client's /blog and get every post's title, meta description, meta keywords, canonical URL and word count in one tab. Sort by word count to find thin pages, or filter for missing descriptions.

Content research on a competitor

Point the crawler at a competitor's guides section and get the full text of each page in a row. Then run =AITEXT() on the text column to summarize each page or pull out the topics it covers.

Turning documentation into a sheet

Support and ops teams crawl a help center or product docs and keep each page's URL, title and Markdown text in one place, ready to review, tag, or use as reference for answers.

The same thing, inside Google Sheets

CRAWL takes your start pages, the most pages to read in the run, and a link depth (1 reads each start page plus the pages it links to below it). It runs in the background and writes one row per page to a results tab. Each crawled page uses 84 scraping credits. To read one page at a time, =PAGEDATA(A2) returns its URL, title, description, H1 and status from 1 credit.

=CRAWL(A2, 10, 1)
Type it in any cell once SheetMagic is installed.

Other ways to do it

Copy and paste by hand
Free and fine for a page or two, but you open and copy every page yourself. It does not scale to a whole section of a site.
IMPORTXML in Google Sheets
Free and built in, but it reads one page per formula with an XPath you write, cannot follow links to other pages, and misses text that a page loads with JavaScript.
Standalone scraper tools and browser extensions
Many can crawl a site, but you set up the scraper in their app, export a CSV and import it into Sheets each time the content changes.
SheetMagic CRAWL
Reads the live public pages below the start pages you list and writes them straight into Google Sheets from a formula. Uses scraping credits per page, and sites that block automated visitors can come back empty.

Questions

Is this web scraper free?
Yes. Running it on this page is free and shows up to 5 pages. To get every result in Google Sheets, install SheetMagic for free. The free plan includes 100 one-time scraping credits, and larger crawls use those credits.
Is it legal to scrape a website?
This tool only reads public pages that anyone can open in a browser, and it never logs in. What you may do with the content depends on the site's terms, copyright, and privacy laws such as GDPR when pages hold personal data. Check the rules that apply to you and the site.
How many pages can I scrape?
This page shows up to 5 pages per run. In Google Sheets, the second CRAWL argument sets the most pages to read across the whole run. Each crawled page uses 84 scraping credits, so the free 100 credits cover one crawled page; single-page formulas like PAGEDATA start at 1 credit.
What data does the web scraper return?
One row per page with the URL, title, description, author, language, crawl depth, the content as Markdown and as plain text, word count, canonical URL, meta keywords, the final URL after redirects, and the page where the link was found.
How do I scrape data from a website into Google Sheets?
Install SheetMagic from the Google Workspace Marketplace and click Activate. Put a start page in A2 and type =CRAWL(A2, 10, 1) in an empty cell. The results land on a new tab, one row per page, so you never leave the sheet.
Can it extract meta keywords and images from a website?
Meta keywords, yes: every row has a Meta Keywords column, empty when the page does not set the tag. The crawler does not return images. For images, use =GETIMG(A2) in SheetMagic, which lists the image addresses on one page.
Why did a page come back empty or go missing?
Some sites block automated visitors, hide content behind a login, or load text only after clicks. The crawler also follows only links below the start page: acme.com/blog reads acme.com/blog/any-post but not acme.com/pricing, so start from the section you want.
All free tools

Free plan

100scraping credits, one time

Run the full web scraper in Google Sheets.

Install SheetMagic from the Google Workspace Marketplace. No card, no separate account, and no deadline on the free allowance.