FreeA spreadsheetAbout 20 min
Lock Your NAP and Build a Master Sheet
NAP stands for Name, Address, Phone. Before you list your business anywhere, pick the one exact format you'll use everywhere. Save it in a master sheet. This hour of setup saves days of cleanup later.
Why This Matters
Every directory must show the same info. Mixed NAP confuses Google, like 'Ste' on one site, 'Suite' on another, or two phone numbers. It weakens the trust each listing is meant to build. Old listings are also slow to fix, so getting the format right before you start is far cheaper.
✓ How To Do It
- Open a spreadsheet and lock the exact spelling and format of each field below.
- Use your real legal or trading name. Don't add keywords or a city to the name unless that is what your business is truly called.
- Decide once on www or non-www, (951) or 951-, Suite or Ste. Never vary it.
- Add the extras you'll paste again and again, like hours, categories, a short description and your logo file.
- Paste this master data into every listing from now on.
- Keep the sheet handy. You'll reuse it dozens of times this phase. Add a column for each listing's address and login.
Done WhenThe master NAP sheet is filled in and shared with everyone who will build listings.
Tools For This StepGoogle Sheets
Reference List
Standardize and save one master copy of
- Business name (exact brand form)
- Address (one consistent format)
- Phone (one primary local number)
- Website URL (www or not, pick one)
- Primary + secondary categories
- Hours of operation
- Short + long description
- Logo and cover photo
How we run this step at Clickflame
Our rule is that the Google Business Profile is the master copy of the name, address and phone, not the client's old website. When the two disagree we don't guess. We ask the owner which number is right, fix the profile if needed, and only then start listing.
Tips & Pitfalls
- Use a phone number you plan to keep. Changing it later means updating every listing again.
- Work from home and don't show your address? Most directories let you hide it and list a service area. Never make up a street address.
- Share the sheet with anyone who helps you, so one person can't quietly start a second format.
Email Me The Free Course
Get your course link in your inbox so you can pick it up on any device. It's free, with no card.