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.
Your results
Run a search above. The rows land in this sheet.
| Row | URL | Title | Description | Author | Language | Crawl Depth | Content (Markdown) | Content (Text) | Word Count | Canonical URL | Meta Keywords | Final URL | Found On |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | |||||||||||||
| 2 | |||||||||||||
| 3 | |||||||||||||
| 4 | |||||||||||||
| 5 | |||||||||||||
| 6 | |||||||||||||
| 7 | |||||||||||||
| 8 |
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.
- URL
- Title
- Description
- Author
- Language
- Crawl Depth
- Content (Markdown)
- Content (Text)
- Word Count
- Canonical URL
- Meta Keywords
- Final URL
- Found On
From this page to your sheet
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. 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. 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)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.
More free scrapers
All free tools- Free email extractorEnter a website and we read its homepage and the pages it links to, like Contact and About, for emails, phone numbers and social profiles. You see up to 5 results here; install SheetMagic free to get every result in Google Sheets.
- Free website traffic checkerEnter a website and see its estimated monthly visits, global rank, engagement and where its traffic comes from. Install SheetMagic to get every result as rows in Google Sheets.
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.
