SheetMagicSheetMagic

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.

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.

RowDomainGlobal RankCountry RankCategoryMonthly VisitsAvg Visit DurationPages Per VisitBounce RatePrimary CountryTop CountryDirect TrafficSearch TrafficSocial TrafficReferral TrafficAI Traffic (ChatGPT)AI Traffic (Claude)AI Traffic (Perplexity)Site TitleCategory RankEmail TrafficTop AI Prompts
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 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.

  1. Domain
  2. Global Rank
  3. Country Rank
  4. Category
  5. Monthly Visits
  6. Avg Visit Duration
  7. Pages Per Visit
  8. Bounce Rate
  9. Primary Country
  10. Top Country
  11. Direct Traffic
  12. Search Traffic
  13. Social Traffic
  14. Referral Traffic
  15. AI Traffic (ChatGPT)
  16. AI Traffic (Claude)
  17. AI Traffic (Perplexity)
  18. Site Title
  19. Category Rank
  20. Email Traffic
  21. Top AI Prompts

From this page to your sheet

  1. 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. 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. 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)
Type it in any cell once SheetMagic is installed.

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.