Objective

Today’s mission is to bring order to the chaos.
You’re going to make sure every field across your datasets - names, dates, currencies, job titles, and more - follows one consistent format.
Standardisation is the bridge between human understanding and machine precision.
It’s what makes automation possible and what turns scattered data into clean, connected intelligence.

Why This Matters

Inconsistent data is one of the biggest blockers to automation and reporting accuracy.
When one system says “John Smith” and another says “Smith, John”, your automations can’t tell they’re the same person. 👥
When one sheet uses DD/MM/YYYY and another uses MM/DD/YY, you’ll spend forever reconciling errors instead of scaling. 📊
Standardisation isn’t glamorous, but it’s the difference between systems that sync and systems that stall.

The Exercise

Step 1 - Identify Core Fields (5 mins)

Look across your key datasets and note down recurring fields that appear in multiple places, such as:

• 👤 Name
• 📧 Email
• 📱 Phone number
• 🏢 Company name
• 📅 Date
• 💷 Currency
• 🏷️ Status
• 🗂️ Department / Category / Region

These are your “alignment anchors.”

Step 2 - Choose a Standard Format (10 mins)

For each field, define a single, universal format that all systems should follow.

Examples:

• 📅 Dates: YYYY-MM-DD
• 📱 Phone Numbers: +44 7XXX XXX XXX (country code first)
• 💷 Currency: GBP (symbol + 2 decimal places)
• 👤 Names: First Name + Last Name (Title Case)
• 🏷️ Status fields: Controlled vocabulary (e.g., Active, Inactive, Pending)

Document these rules in your Data Standards Guide (or a Notion/Airtable table). 📘

Step 3 - Apply Standardisation (10–15 mins)

Start with the datasets that are most visible or most shared.

• 🔎 Use find/replace or formatting functions in Sheets/Excel to align field styles.
• 🛡️ Use data validation rules (dropdowns, date pickers, etc.) to prevent variation.
• ⚙️ Update form fields and automations to enforce your standards going forward.

Don’t fix everything today - focus on one dataset or one field type per session.
Consistency compounds. 📈

Step 4 - Create a “Single Source of Truth” Reference (Optional)

Pick one master dataset (e.g., your CRM or Airtable base) to be your reference point. 📘
This becomes the source of truth for field names, spellings, and formats - and all other systems must match it.
Mark it clearly in your documentation.