Local citation auditevery listing in one list.
Record every directory listing for each location, whether its name, address and phone match, and what needs fixing, then download one clean CSV to work through.
Local Citation Audit
Try the template with up to 3 listings
What You'll Collect
Location
StringThe store code or location name, the same way on every row.
Directory
StringGoogle, Apple Maps, Bing Places, Yelp, Facebook or any other directory.
Listing URL
URLThe full link to the listing, including https://.
Listed Name, Address & Phone
StringExactly as the directory shows them. Phones are checked as phone numbers.
Name, Address & Phone Matches
BooleanYes or no for each, against the official details.
Status
EnumCorrect, Needs update, Duplicate, Not listed or Update submitted.
Need more than three listings?
Collect up to a thousand listings instead.
The free template is limited to three rows so you can try the workflow. Create your own form when you're auditing every location for a client, or want the client's team to record listings for you.
Create your own formUp to 1,000 rows
Room for every location across every directory you track, in one file.
Your own directories
Turn Directory into a dropdown of the sites you track, so names are always spelled the same.
Checked as they type
Bad links, phone numbers and missing statuses are flagged before you get the file.
Share with the client
Send one link and let their team add listings you couldn't find.
How it works
From scattered listings to a fix list in three steps.
01
Collect
Search each directory for every location and add a row for each listing you find, or send the form to the client's team.
02
Complete
Links, phones and statuses are checked on every row, so the list is complete before you start fixing.
03
Download
Download the CSV, sort by status, and work through Needs update and Duplicate first.
Why use a form?
Citation audits fall apart in spreadsheets.
An audit spreadsheet passes between people and gets messy: one person writes Google, another GBP; links are missing; statuses are made up as you go. By the time you fix listings, nobody's sure which were checked.
A form keeps every row in the same shape, so the audit is something you can act on and repeat next quarter.
Directory names spelled five ways
Use a dropdown of the directories you track, so filtering and counting just works.
Missing links and statuses
Every listing needs a status, and links must be complete web addresses.
Phones that can't be compared
Listed phone numbers are checked as phone numbers, so typos stand out.
Local citation audit template
Running a local citation audit
A local citation is any online mention of a business's name, address and phone number (NAP), such as its Google Business Profile, Apple Maps place card, Bing Places listing, Yelp page or a local directory entry. A citation audit lists every one for each location and checks that the details match the business's official version.
Mismatches creep in when a business moves, changes phone numbers or rebrands, and when directories copy old data from each other. Search engines and customers both see the conflicting details, so agencies usually start local SEO work with an audit and fix the listings that matter most first.
This template records one row per listing: where it is, the link, the name, address and phone exactly as listed, whether each matches, and a status. Sorting by status gives you a fix list: listings that need updating, duplicates to remove or merge, and directories where the business isn't listed yet.
Use it yourself while auditing, or send the form to a client's location managers so they can add listings they know about. When you're done, download the CSV and repeat the audit every few months to catch new mismatches early.
How-To Guides
Related Templates
New to NAP? Read the NAP consistency guide, or see the tools for local SEO agencies.
Need a CSV form of your own?
Create a custom Import Builder form with your own fields, validation and row limits.
Get started