Brand Systems By Soluna Foundry · Published Sep 26, 2026 · 6 min read

Customer Data Everywhere? Three Steps to Consolidate It

Before you buy a CRM, learn the three-step process - audit, normalize, connect - that turns a messy spreadsheet into an actual business asset.

Key takeaways

A messy spreadsheet usually isn't a tooling problem - it's a process that was never designed in the first place, and jumping straight to CRM just moves the mess into a more expensive system.
The audit takes one sheet and a day or two: list every place customer data lives, with volume and format for each. If you can't explain your current state in five minutes, you're not done.
Standardize names, phone number formatting, and lead source at minimum - get the data accurate first, don't try to fill every field on day one.
Team size decides whether you need a CRM at all: solo operators and small teams are fine with a spreadsheet and reminders; a real system is only worth evaluating once 10+ people across departments need to share the same data.

You've got customer names in a Google Sheet someone started two years ago, more in your point-of-sale system, a few hundred in a WhatsApp Business inbox nobody checks, and an Excel file your old marketing hire left behind before she quit. Someone in a meeting asks 'how many of our customers came back this quarter?' and the honest answer is: nobody knows. This is the moment most founders decide they need a CRM.

That instinct is usually wrong, or at least premature.

Don't reach for a CRM first

A CRM doesn't fix messy customer data - it just gives your mess a monthly subscription fee.

We've watched this pattern play out with our own team and with brands we've advised: a founder gets frustrated with a messy spreadsheet, buys a RM 300/month CRM, spends two weekends importing everything, and six months later the CRM has the exact same duplicate names, inconsistent phone formats, and blank source fields the spreadsheet had. The tool didn't create the mess and it won't clean it up either. If your process for capturing and updating customer data is broken, migrating that process into new software just breaks it in a fancier place.

Before you shop for software, do three things in order: audit, normalize, then decide if a system is even necessary.

Step 1: Audit - one sheet, one to two days

This step is boring and that's exactly why most people skip it, which is also why their customer data management stays messy for years. Open a blank spreadsheet and log every single place customer information currently lives.

Where the data lives (POS, Google Sheet, WhatsApp, email inbox, paper forms, Instagram DMs)
Roughly how many records are in each place
What format each source uses (full name vs. first name only, phone with or without country code, etc.)
Who currently owns or updates each source, if anyone
Whether the source is still being actively added to, or frozen in time

The test for whether you're actually done: can you explain your entire current state to a new hire in five minutes, using only this sheet? If you're still saying 'oh, and there's also that file on my laptop,' you haven't finished the audit. This step alone, done honestly, already tells you more than most businesses know about their own customer base.

Step 2: Normalize - get the basics accurate, not complete

Normalizing means picking one format for the fields that matter most and applying it everywhere, before you worry about anything fancy like tags or lifetime value. At minimum, standardize three things:

Name - one column, consistent capitalization, no 'Mr. Tan' in one sheet and 'tan ah kow' in another
Phone number - pick one format (we use +60 with no spaces) and convert everything to it, since this is usually your primary matching key
Source or channel - where did this person actually come from (referral, Facebook ad, walk-in, KOL post), even if it's a rough guess for older records

Notice what's not on that list: purchase history, tags, notes, birthday, preferences. Resist the urge to backfill everything at once - it's the fastest way to turn a two-day project into a three-month one that never finishes. Get name, phone, and source accurate for 80% of your records first. Everything else can be added gradually once the foundation is solid.

Step 3: Decide if you actually need a system

This is where most advice online skips straight to recommending software, and it's where we think honesty matters more than a sale. If you're a solo operator or a team of two to three people, a well-maintained spreadsheet plus a recurring calendar reminder to update it is genuinely enough. You don't need Notion automations or a CRM subscription to manage a few hundred contacts that only you touch.

The calculation changes once you have 10 or more people who need to read and write to the same customer data - sales looking up a lead history, ops checking appointment records, marketing pulling a segment for a campaign. That's when a shared, permissioned system earns its cost, because the real problem shifts from 'the data is messy' to 'five people are editing five different copies of the truth at the same time.'

We built our own CRM and automation stack this way, on our clinic brand, after running spreadsheets for the first stretch of growth. The system came after the process was already clean, not before. That order is the whole point.

Frequently asked questions

How do I clean up a messy customer database or spreadsheet?

Start with an audit before touching any tool: list every place customer data currently lives, how many records are in each, and what format they're in. Then normalize just three fields - name, phone number, and source - across all of them. Only after that should you decide whether a CRM is worth adopting. Skipping the audit is why most CRM migrations just relocate the mess.

Do I need a CRM if I only have a few hundred customers?

Probably not. A clean, well-maintained spreadsheet with consistent formatting and a recurring update habit handles a few hundred contacts fine, especially if only one or two people touch the data. CRMs earn their cost when multiple people across departments need to read and write to the same customer records at the same time, which usually starts mattering around a team of 10 or more.

How much does it cost to hire someone to organize customer data or set up a CRM?

Pricing varies widely depending on data volume and how messy the source is, but the real cost driver is the audit and normalization work, not the software itself - CRM tools like HubSpot or Zoho typically run from free to a few hundred ringgit per month. If a vendor quotes you a CRM setup fee without first asking to see your existing data sources, that's a sign they're skipping the step that actually matters.

What's the difference between using a spreadsheet and a CRM for customer data?

A spreadsheet is a static record that one or two people maintain manually; a CRM adds permissions, automation, and real-time shared access across a team. Neither one fixes bad data on its own - a disorganized CRM is just an expensive disorganized spreadsheet. Choose based on how many people need simultaneous access to the same customer information, not on which tool sounds more professional.