← All posts

SEO · Free Tools

How to Audit Backlinks Using a Google Sheet and Free Tools

Marianne Gatlabayan runs backlink audits with Google Sheets, Search Console, and free tools. Save $3,816 per year. Full process with scoring formula. Learn the steps.

Marianne Gatlabayan · Sep 24, 2026 · 16 min read

In short: Google Search Console, Bing Webmaster Tools, and Ahrefs Webmaster Tools combine into a free backlink audit stack that saves $3,816 per year over paid tools. A Google Sheet with a scoring formula handles the analysis. The whole workflow covers 80% of what a small site owner or freelance SEO actually needs and pays for itself immediately.

Key Takeaways

  • Paid backlink tools cost $318 per month combined (Ahrefs, Semrush, Majestic)
  • Free tools cover 80% of small-site backlink audit work
  • Marianne Gatlabayan runs monthly audits on client sites with this exact stack
  • A scoring formula in Google Sheets replaces manual toxic link analysis
  • Google accepts disavow files in a simple text format uploaded via Search Console

Split-cost comparison card showing a paid SEO stack (Ahrefs $129, Semrush $139, Majestic $50) totaling $318 per month against a free stack (Google Search Console, Bing Webmaster Tools, Ahrefs Webmaster Tools) totaling $0, with a footer banner reading $3,816 saved per year

Why this guide exists

Ahrefs costs $129 a month. Semrush costs $139. Moz costs $99. For a small site owner or freelance SEO managing 3 to 5 client sites, that is $400+ a month in tooling before any work happens. Across a year, the paid stack alone runs close to $5,000, which is real money for a solo operator or a small agency.

Google Search Console is free. Bing Webmaster Tools is free. Google Sheets is free. Together they cover most of what a backlink audit actually needs. The paid tools add competitor analysis and historical data, both of which matter for enterprise SEO but rarely for small-site work.

Marianne Gatlabayan walks through the exact process on a real site below. The methodology comes from her years leading link building teams, adapted for anyone who does not have enterprise SEO tool budgets. The free stack is not a lesser version of the paid one. It is a leaner version tuned for the 80% of use cases that do not need historical or competitor data.

What questions does a backlink audit actually answer?

Four questions. Every paid tool answers these. So does the free stack in this guide.

Which sites link to me? The universe of external links pointing at your domain. This is the raw data that every other analysis builds on. Missing this data means missing the whole audit.

Are any of those links toxic? Spam directories, private blog networks, or hacked sites that could trigger a Google penalty. Toxic backlinks accumulate slowly and quietly, and a manual annual review is often the first time anyone notices the problem.

Which of my pages get the most links? Your topical authority signals. Understanding which pages attract natural links tells you what kinds of content earn attention and where to focus future SEO work.

What anchor text do those links use? Signals to Google about what your pages are about. Anchor text distribution flags manipulative link building patterns even when the sites themselves look legitimate.

Answering these four questions well is what makes an audit useful. Everything else is data collection theatrics.

Which free tools replace paid backlink tools?

Google Search Console. Free. Shows all backlinks Google knows about. Coverage matches what actually influences your rankings, which matters more than raw quantity. If Google does not know about a link, it does not count for ranking purposes, so Search Console's dataset is by definition the most complete view of what affects your SEO.

Bing Webmaster Tools. Free. Provides a second view. Often catches links Google missed, particularly on newer sites or from newer link placements. Combining Google and Bing data catches roughly 90% of the backlinks a $129 Ahrefs subscription would show, which is enough for small-site work.

Ahrefs Webmaster Tools. Free tier for verified site owners. Uses Ahrefs data, restricted to your own site. Best free source for topical grouping and referring domain metrics. Setup takes 10 minutes with domain verification through DNS or Google Search Console integration.

Together these three cover 80% of what a $129/mo Ahrefs subscription provides for site-owner use cases. The missing 20% (competitor analysis, historical data, broken backlink discovery) is real but often not necessary for a small-site monthly audit.

Step 1: How do you export backlinks from Search Console?

Sign in to Search Console at search.google.com/search-console. Pick your property from the dropdown at the top left. Click Links in the left sidebar. The Links dashboard opens with three panels: External links, Internal links, and Top linking text.

Under External links, click Top linking sites. The panel shows every domain that links to yours, sorted by link count. Click Export at the top right and pick CSV. Do the same for Top linked pages (which pages on your site get the most external links) and Top linking text (which anchor text is most common).

You now have three CSVs downloaded to your computer. Import each into a fresh Google Sheet as separate tabs. Name the tabs Linking Sites, Linked Pages, and Anchor Text. Freeze the first row of each so headers stay visible when scrolling.

That is your baseline dataset. Everything else in the audit builds on top of this data.

Step 2: How do you enrich the data with Bing?

Sign in to Bing Webmaster Tools at bing.com/webmasters. Add your site if you have not already (verification takes 5 minutes via meta tag or DNS). Navigate to Reports and Data in the left sidebar, then Backlinks.

Export the data. Add it to a fourth tab in your audit Sheet called Bing Data. The Bing data structure differs slightly from Google's, so expect column names to differ.

Compare against your Google linking sites list. Every domain unique to Bing gets flagged for investigation. Sometimes Bing catches a placement that Google has not yet indexed, particularly on newer sites where Bingbot moves faster than Googlebot. Sometimes Bing surfaces links that Google chose not to include because of algorithmic filters.

Both cases are worth investigating. New good links deserve attention because they are candidates for outreach relationships. Links that Google filtered out are candidates for the disavow file because Google's filter is a hint that something looks unnatural about them.

Step 3: How do you add Ahrefs Webmaster Tools data?

Sign up for the free Ahrefs Webmaster Tools account at ahrefs.com/webmaster-tools. This is a completely separate free product from the paid Ahrefs subscription. It uses the same Ahrefs data but restricts access to only the domains you verify ownership of.

Verify your domain via Google Search Console integration or DNS. The integration option is fastest if you already have Search Console access. Wait for the first crawl. Usually completes within 24 hours for a small site, longer for large sites.

Export the backlinks report. Add to a fifth tab in your Sheet called Ahrefs Data. This is where the free stack really shines because Ahrefs categorizes links by dofollow/nofollow, topical relevance, and referring page traffic estimates in ways that Search Console does not.

Now you have three overlapping views of your link profile. Deduplicate later using QUERY or Pandas. Coverage variance is what makes the free stack competitive with paid tools. Any link that appears in only one of the three sources is worth extra attention because the other tools failed to capture it, which sometimes signals filtering.

Step 4: How do you score each domain for toxic risk?

This is where a formula does the work of a subscription. Manual toxic link analysis takes hours; a scoring formula narrows the review to just the domains that need human judgment.

Add a Score column next to each linking domain. Use these signals to build the score. Each signal adds or subtracts points based on how strongly it suggests the link is legitimate or manipulative.

Domain matches your industry. +1 point. Relevance signals a natural link. A SaaS company getting a link from a marketing blog is exactly the pattern natural link building produces.

Domain uses HTTPS. +1 point. Legitimate sites have moved on from HTTP. HTTP-only sites in 2026 are usually either abandoned or spammy.

Domain has active recent content. +1 point. Check by visiting the site. Active sites publish something in the last 90 days. Ghost sites with no updates in years are often abandoned link farms.

Anchor text is your brand name or a natural phrase. +1 point. Natural links use brand or descriptive anchors.

Anchor text is exact-match commercial ("best CRM software"). -2 points. Overuse looks manipulative. Real editors rarely link with exact commercial keywords as anchor text.

Domain contains words like "seo", "directory", "links", "backlinks" in the URL. -3 points. Classic spam signal. Sites that advertise their SEO purpose in the URL are almost always link farms.

Site loads to a parked page, casino, or unrelated content. -5 points. Almost certainly toxic. These are the obvious "we bought this expired domain to build a link farm" cases.

Any domain scoring -3 or lower goes on the review pile. Anything scoring 0 or higher is probably fine to keep. The middle range needs case-by-case judgment.

Step 5: How do you review flagged domains efficiently?

Filter your Sheet by the score column. Sort ascending so the most toxic-looking domains appear first. This ordering means you spend the first 30 minutes on the clearest cases and only get to the ambiguous ones after you have caught the obvious problems.

Every domain with a negative score gets a manual review. Open the linking page in a browser (not just the domain, the specific page where the link lives). Look at what it actually is. Is the link buried in a paragraph of legitimate content, or is it in a footer link farm alongside 200 other unrelated sites?

Three outcomes per review:

Keep. Real link on a real site. Score was misleading. Common when a legitimate industry directory happens to have "directory" in the URL and triggered the -3 penalty.

Watch. Suspicious but not clearly toxic. Note in a separate column, revisit next quarter. This is the pile that either becomes clearly toxic over time or reveals itself as a fluke.

Disavow. Confirmed spam or manipulation. Add to your disavow file. Do this only after clear evidence, never on suspicion alone.

Speed matters here. A pace of 30 seconds per domain lets you review 200 domains in under two hours. If you find yourself spending 5 minutes on a single domain, add it to the Watch pile and move on. The audit has to complete this month or it will not happen.

Pie chart of a typical small-site backlink profile showing 60% clean links, 25% low quality, 12% needing monitoring, and 3% toxic, based on three site audits

Step 6: How do you build a Google disavow file?

Google accepts disavow files in a simple text format. One line per domain or URL. Comments start with # and get ignored.

# Disavow file for example.com
# Generated 2026-09-24
domain:spammydirectory.com
domain:linkfarm-example.net
https://specific-page.com/spammy-post

The domain: prefix disavows the entire domain. A raw URL disavows only that specific page. Prefer domain-level unless you have a specific reason to keep other pages from the same site. Most toxic sites are toxic across all their pages, and domain-level disavow is faster to apply and maintain.

Save as disavow.txt. Upload via Google's Disavow Links tool at search.google.com/search-console/disavow-links. Pick your property, upload the file, and confirm. Google does not confirm receipt or provide processing status, so trust that it worked once the file uploads without error.

Recheck no sooner than 90 days later. Google needs time to reprocess the disavowed links, and the effect on rankings shows up over months rather than weeks. Keep a copy of every disavow file version in a folder so you can track what you have disavowed over time.

Step 7: How do you analyze anchor text distribution?

Head to your Anchor Text tab. Use QUERY to aggregate the raw anchor text data into meaningful counts:

=QUERY(A2:B, "SELECT A, SUM(B) GROUP BY A ORDER BY SUM(B) DESC", 0)

Now you see anchor text ranked by frequency. Look at the top 20 anchors to understand what pattern your backlink profile is sending to Google.

Healthy profiles look like:

50 to 60% brand and URL anchors ("Marianne Gatlabayan", "marianne.click"). These are what natural editors use when they want to attribute a source without keyword optimization.

20 to 30% naked URLs and generic anchors ("here", "this", "click here"). Natural but boring linking.

10 to 15% partial-match anchors ("data automation guide"). Descriptive without being manipulative.

5% or less exact-match commercial anchors ("best CRM software"). Any higher and Google's algorithms notice.

If exact-match commercial anchors exceed 10%, your profile looks manipulated to Google regardless of intent. This is often the case for sites that hired an SEO service that used the same anchor text template across many placements.

Step 8: How do you track backlink growth over time?

Add a Snapshots tab. Every month, log four numbers:

Total referring domains. The universe of unique domains linking to your site. New referring domains this month. New links earned or acquired. Lost referring domains this month. Links that disappeared, either from content changes or takedowns. Estimated toxic domain percentage. The share of your profile that scored negative in the toxic analysis.

After six months you have a trend line. After a year you have a story to tell prospects when they ask what results look like. The snapshot tab becomes the highest-leverage piece of the whole audit workflow because it turns one-off cleanup work into a continuous improvement story.

Set a monthly reminder to run the snapshot. Marianne Gatlabayan runs it on the first Monday of every month as part of a broader SEO health check for each client. The snapshot takes 10 minutes and produces the most-cited data in the monthly client report.

Line chart of referring domains growth over nine months with two lines: total referring domains climbing from around 30 to 150, and new domains per month rising slowly from 10 to 20

What does the free stack miss?

Historical data. Paid tools store years of link history and let you see when specific links were gained or lost over long periods. Free tools show only current state. The workaround is to snapshot monthly and build your own history over time, which produces useful data after 6 to 12 months of consistent snapshots.

Competitor analysis. Google Search Console only shows your own links. Ahrefs and Semrush show competitors and let you research what backlinks competitors have earned that you have not. If competitive research matters to your workflow, budget for a paid tool. For most small-site owners, this is not a monthly need and a one-time subscription for a specific competitive analysis project makes more sense than an ongoing subscription.

Broken backlink discovery. Paid tools flag pages that link to a 404 on your site, which is a fixable ranking loss because you can either restore the page or set up a redirect. Free tools do not surface this data automatically. For a small site, a quarterly manual check catches most broken backlinks by comparing the top linked pages report against your current site structure.

For 80% of small-site backlink work, the free stack is genuinely sufficient. The missing 20% matters more for enterprise SEO than for small-site work.

When should you upgrade to a paid tool?

Upgrade to a paid tool when you cross any of these thresholds.

You manage 10+ sites and spend more than 10 hours a week on link audits. At that volume, the time savings from paid tool automation pay for the subscription many times over.

Competitor analysis is core to your strategy. You need to see what competitors are doing to guide your own outreach, content, or product decisions. Free tools cannot provide this.

Clients expect a monthly report branded with Ahrefs or Semrush visuals. Client perception sometimes requires the paid tool logos even when the analysis could be done with free tools. In this case, the subscription is a marketing expense, not a data expense.

Until then, the free stack pays for itself in saved subscription fees. Every year on the free stack is $3,816 not spent on Ahrefs, Semrush, and Majestic combined. That money goes further into content production, freelancer contracts, or advertising than it does into tool subscriptions.

Frequently Asked Questions

Is the disavow file dangerous to use?

Yes if used carelessly. Disavowing good links tells Google to ignore them, which drops your rankings. Only disavow confirmed spam. When in doubt, add the domain to the Watch pile instead and revisit next quarter.

How often should I audit backlinks?

Quarterly for most small sites. Monthly if you actively run link building or notice unusual ranking changes. Any time you notice a ranking drop unrelated to content or technical changes deserves an emergency mini-audit to check for a sudden influx of toxic links.

Does Ahrefs Webmaster Tools show all my backlinks?

It shows all backlinks Ahrefs has crawled and verified. Coverage varies but is broadly comparable to Search Console for most sites. Newer links appear in Ahrefs Webmaster Tools within days or weeks of first crawl.

Can I audit competitor backlinks with free tools?

No. Free tools cover only your own domain. Competitor backlink data requires a paid tool like Ahrefs or Semrush. This is the single biggest limitation of the free stack.

How long does it take Google to process a disavow file?

Google says 90 days minimum. In practice, effects appear over 3 to 6 months as Googlebot re-crawls the disavowed domains and the algorithm updates its assessment of your link profile. Do not expect immediate ranking recovery.

What to read next


About the Author: Marianne Gatlabayan is a Systems Strategist and Industrial Engineer focused on optimizing operations, automating workflows, and driving business growth. With over a decade of experience in analytics, reporting, and process improvement, she helps organizations build scalable systems that turn complexity into measurable results. In her free time, Marianne enjoys discovering and sipping her favorite coffee bean of the week. Connect on LinkedIn.

Sources

Work with me

Have a process like this worth automating?

Tell me about the bottleneck: the report nobody wants to build, the data nobody trusts. I'll come back with a practical way to automate it.