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.
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.
✓ How to do it
- Open a spreadsheet and lock the exact spelling and format of each field below.
- Decide once: www or non-www, (951) or 951-, Suite or Ste. Never vary it.
- Paste this master data into every listing from now on.
- Keep the sheet handy. You'll reuse it dozens of times this phase.
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.