Free Website Traffic Checker for Google Sheets
Enter 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.
Your results
Run a search above. The rows land in this sheet.
| Row | Domain | Global Rank | Country Rank | Category | Monthly Visits | Avg Visit Duration | Pages Per Visit | Bounce Rate | Primary Country | Top Country | Direct Traffic | Search Traffic | Social Traffic | Referral Traffic | AI Traffic (ChatGPT) | AI Traffic (Claude) | AI Traffic (Perplexity) | Site Title | Category Rank | Email Traffic | Top AI Prompts |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 website traffic checker for Google Sheets, in short
To check website traffic in Google Sheets for free, enter a domain on this page to preview its estimated monthly visits, ranks, bounce rate and traffic sources. Then install the free SheetMagic add-on and type =SIMILARWEB("stripe.com") in a cell, or point it at a column of domains, to get one row per website.
21 columns for every result
Each result is one row, with these columns in this order. Fields the source does not show stay blank.
- Domain
- Global Rank
- Country Rank
- Category
- Monthly Visits
- Avg Visit Duration
- Pages Per Visit
- Bounce Rate
- Primary Country
- Top Country
- Direct Traffic
- Search Traffic
- Social Traffic
- Referral Traffic
- AI Traffic (ChatGPT)
- AI Traffic (Claude)
- AI Traffic (Perplexity)
- Site Title
- Category Rank
- Email Traffic
- Top AI Prompts
From this page to your sheet
1. Check a website here
Type one to three domains, like stripe.com, and run the check. You see a preview of the results on this page.
2. Install SheetMagic for free
Add SheetMagic from the Google Workspace Marketplace and click Activate. No card is needed, and the free plan includes 100 one-time scraping credits.
3. Get every result in Google Sheets
Type =SIMILARWEB(A2:A20) next to a column of domains. Each website becomes one row with visits, ranks, engagement and traffic sources.
Who uses it, and for what
Competitor benchmarking for marketers
List your competitors in one column and compare their monthly visits, bounce rate and share of search versus social traffic side by side.
Agency pitches and client reports
Before a sales call, pull a prospect's traffic, top country and traffic sources into the sheet you already use for the pitch.
Vetting link and partner sites
Check the estimated traffic and category rank of sites offering guest posts, sponsorships or affiliate deals before you pay for a placement.
The same thing, inside Google Sheets
SIMILARWEB takes one domain or a range of domains and writes one row per website below the cell, with the same columns you see on this page. It runs in the background and uses scraping credits per website. It's just a formula, so you never leave the sheet.
=SIMILARWEB(A2:A20)Other ways to do it
- Copying numbers by hand from a traffic site
- Works for one or two domains. For a list of competitors it means tab switching and retyping, and the numbers in your sheet go stale.
- IMPORTXML
- Free, but traffic sites load their numbers with JavaScript and block automated requests, so IMPORTXML usually returns errors or empty cells.
- Similarweb's own export or API
- The source of these estimates, with more data than these columns. Export and API access are sold on Similarweb's own plans, and you still need to get the data into Sheets.
- A standalone traffic checker website
- Fine for a quick look at one site. You check domains one at a time and copy the results into your spreadsheet yourself.
Questions
- Is this website traffic checker free?
- Yes. Checking a website on this page is free and shows up to 5 results. To get every result in Google Sheets you install the free SheetMagic add-on, whose free plan includes 100 one-time scraping credits. Larger runs use more credits.
- How accurate are the traffic numbers?
- They are Similarweb estimates, not the site's own analytics. They are useful for comparing sites against each other. Small sites with little traffic may come back with few or no figures, and only the site owner's analytics show exact visits.
- What data do I get for each website?
- One row per website with monthly visits, global, country and category rank, category, average visit duration, pages per visit, bounce rate, primary and top country, site title, and the share of traffic from direct, search, social, referral, email and AI assistants.
- How many websites can I check?
- This page checks up to three domains per run and shows up to 5 results. In Google Sheets, the SIMILARWEB formula takes a single domain or a whole range, and each website becomes one row that uses scraping credits.
- How do I get website traffic data into Google Sheets?
- Install SheetMagic from the Google Workspace Marketplace and click Activate. Then type =SIMILARWEB("stripe.com") in a cell, or =SIMILARWEB(A2:A20) next to a column of domains. Results are written as rows below the formula.
- Can I enter full URLs instead of domains?
- Yes. A bare domain like stripe.com works best, but full links work too. Only the domain is looked up, so a page path is ignored, and a repeated website is looked up once.
- Is it allowed to check another company's website traffic?
- Yes. You get third-party traffic estimates, not access to anyone's private analytics account. No login to the site and no permission from its owner is involved, just like the public traffic checker sites.
Free plan
100scraping credits, one time
Run the full website traffic checker in Google Sheets.
Install SheetMagic from the Google Workspace Marketplace. No card, no separate account, and no deadline on the free allowance.
