Local SEO Audit Template for Google Sheets

A ready-to-use Google Sheet for auditing the local SEO of any business: its Google Business Profile, directory listings, website and reviews. Mark each check Pass, Fix or N/A, and the sheet scores everything and builds a prioritized fix list you can hand to your client.

$14.99 USD, one-time
Buy Now - $14.99
  • Instant digital download after payment
  • Secure checkout by Stripe (cards, Apple Pay, Google Pay)
  • Works in Google Sheets, needs a free Google account
Local SEO Audit Template for Google Sheets
10tabs, from Google profile to action plan
65+local SEO checks with how-to-check hints
Autoscored dashboard and top 10 priority fixes

What is the Local SEO Audit Template?

It's the same checklist a working SEO consultant uses to audit local businesses, turned into one Google Sheet. It walks you through everything that decides whether a business shows up in Google Maps and local search: the Google Business Profile, Name, Address and Phone on directory sites, the website's titles, meta descriptions and technical health, reviews, and how the business compares to its top 3 map pack competitors.

You don't need to be an SEO expert. Each check comes with a short hint on how to check it. You pick Pass, Fix or N/A, and the sheet does the rest: it scores each section, shows an overall score on a dashboard, and lists every fix in priority order.

What is it for?

  • Freelancers and agencies: run a professional audit for a new or prospective client and hand over a scored report with a clear fix list. Add your own logo in the white-label spot.
  • Small business owners: find out why your business isn't showing up on Google Maps, and get a step-by-step list of what to fix first.
  • Marketers: use one repeatable process for every client, and re-run it later to show progress.

What's inside

  • About 65 local SEO checks, each with a short how-to-check hint
  • Google Business Profile audit: categories, NAP, photos, posts, reviews
  • Citation tracker: Yelp, Apple Maps, Bing Places, Facebook, BBB and more, with automatic mismatch count
  • On-page SEO: title and meta length checker, city-in-title check, schema and alt text
  • Technical SEO: HTTPS, mobile, PageSpeed, sitemap, broken links
  • Reviews and competitor comparison for the top 3 map pack rivals
  • Keyword and ranking tracker, organic and map pack
  • Auto-scored dashboard with section scores, overall score and chart
  • Top 10 priority fixes pulled in automatically
  • Action plan that sorts every fix by priority
  • White-label logo spot for agencies and freelancers

You only buy once

Make a fresh copy of the sheet for every client you audit. White cells are for your input, gray cells fill in by themselves.

Buy Now - $14.99

Take a look inside

How it works

1

Buy and download

Pay securely with Stripe. You go straight to your download page for the PDF guide.

2

Make your copy

Click the link inside the guide to make your own copy in Google Sheets.

3

Audit and score

Fill in the checks and watch the scores, dashboard and action plan update.

Please note: this is a digital download, nothing physical ships. The template comes blank, with no client data. Because it's a digital product, refunds aren't offered, but contact us with any question and we'll help.

Start your next local SEO audit today

One Google Sheet, 65+ checks, a scored report your clients will understand.

Buy Now - $14.99