Have you got to the point where post-it notes and Excel don’t do the job, but you have avoided CRMs because they feel heavy, expensive or likely to eat your whole week, then this is for you. Over one weekend you can set up a simple, tidy CRM that keeps enquiries moving, nudges you to follow up, and gives you one place to find everything. No jargon, no huge migration project, and no pressure to automate your entire business at once. Think minimal viable setup that works on Monday, with room to refine later.
Simple six step plan
Below is a practical six step plan, timeboxed for a Friday to Sunday sprint. It answers the most common questions I hear and includes a printable checklist and a good enough data model to start now then improve as you go. If you want help with anything heavy, I am here to support a handover later.
Weekend overview, realistic timeboxes
- Friday evening, 45 to 60 minutes: pick a tool and create your account
- Saturday morning, 60 to 90 minutes: clean your spreadsheet and import
- Saturday afternoon, 45 minutes: set essential fields, tags and a simple pipeline
- Sunday morning, 45 minutes: switch on essential automations
- Sunday afternoon, 30 minutes: quick training for you (and your team)
- Optional buffer, 30 minutes: tidy your email signatures and forms to match
Adjust the timings to suit your energy, two 25 minute focus blocks also work well.
Step 1, choose a right fit tool
You want something you can learn in an hour and keep using without a steep learning curve.
- Free options in the UK: HubSpot Free CRM, Zoho CRM Free, or even Bigin Free CRM (powered by Zoho), Capsule CRM Free tier. All give contact companies, deals and basic tasks. HubSpot is generous on features, so potentially more to learn, but could help when scaling, Capsule shines for simplicity, Zoho suits those who like custom fields and modules, Bigin prides itself in how quickly you can get it set-up and get started.
- When to pay for your CRM: if you need built in email sequences beyond simple follow ups, custom permissions for a team, advanced reporting, or native integration with accounting. Start free, upgrade when the limits become real constraints.
- Core features to look for: contacts, companies, deals or opportunities, tasks with reminders, a Kanban board style pipeline, basic email logging, and simple automation. If your email provider can BCC to the CRM, even better.
Decision rule: if you cannot see contacts, deals and tasks on one screen, pick a different tool.
Step 2, clean and import your spreadsheet
A 60 to 90 minute tidy avoids a messy CRM later. Work on a copy of your data.
Quick data hygiene checklist, print and tick:
- Remove duplicates, keep the most complete row. Save a backup first.
- Split full names into First Name and Last Name where possible.
- Standardise email addresses to lowercase, trim spaces.
- Put phone numbers in one column with country code, e.g., +44 7xxx xxxxxx.
- Use a single column called Source, e.g., Website, Referral, Networking, Event Name.
- Add a Stage column for initial pipeline placement, e.g., New Enquiry, Discovery, Proposal.
- Tag column for simple segmentation, comma separated, e.g., client, warm, supplier.
- Notes column for context you need at a glance, one or two lines only.
Import tips:
- Map only the fields you will use in week one.
- If your CRM allows it, set your Stage or Pipeline column during import to pre place deals.
- Test with 20 rows first, check results, then import the full file.
If your sheet is very tangled and you want a hand with data hygiene and mapping, a one off tidy saves hours later.
Step 3, set basic fields and tags
Day one fields that cover most small businesses:
- Contact: First Name, Last Name, Email, Phone, Company, Job Title, Source, Tags.
- Company: Company Name, Website, Phone, Address, Notes.
- Deal or Opportunity: Deal Name, Company or Contact, Value, Close Date (estimate), Stage.
Keep tags simple and reusable:
- Relationship: lead, client, past client, supplier.
- Interest or service: product A, workshop, retainer.
- Region if useful: MK, Beds, online only.
Good enough data model to start:
- One contact can belong to one company.
- A deal links to a contact or company with a single current stage.
- Tags live on contacts, not deals, in week one.
You can always add custom fields later, such as GDPR consent, referral partner or renewal month.
Step 4, create a simple pipeline for enquiries
Keep it short; each stage should answer, what do I do next?
Suggested stages:
- New enquiry, capture and qualify.
- Discovery booked, call or meeting scheduled.
- Proposal sent, awaiting decision.
- Won, handover and onboarding.
- Lost, note reason.
Rules of thumb:
- Do not exceed seven stages, five is ideal.
- Only move a deal when the next action is clear.
- Use tasks with due dates to nudge follow ups, five minutes here prevents drift.
This is your answer to, what are the five steps of the CRM process for small businesses? Capture, qualify, propose, close, and follow up or onboard. Your pipeline mirrors those steps.
Step 5, essential automations for day one
You do not need a maze of workflows. Switch on the minimum that saves you from dropped balls.
- Welcome or confirmation email: when a web form creates a new contact or deal, send a short thank you with next steps, e.g., when we receive your enquiry we will reply within one business day; in the meantime, here is a link to book a quick chat.
- Follow up reminder: when a deal enters Proposal sent, create a task due in three days to follow up. If you prefer email alerts, set an email to yourself at the same time.
- Task reminder for new enquiries: when a new enquiry is created, set a same day task to qualify and reply.
- Optional, nurture: if a deal is marked Lost but the contact has consent for marketing, add a tag to include them in your next newsletter.
That list answers, what is the minimum automation I should turn on day one? A welcome confirmation, a proposal follow up task, and a same day reply task for new enquiries.
Step 6, train yourself (and your team) in 30 minutes
You do not need a full manual to start. Run a short session and record your screen for reference. If you want advice on tools to use for this, get in touch.
Agenda, 30 minutes total:
- 5 minutes, where to find contacts, companies and deals.
- 10 minutes, how to add a note, log an email, create a task and move a deal stage.
- 10 minutes, your pipeline rules, when to move stages, what triggers automations.
- 5 minutes, daily routine, open the Tasks view first, clear due items, then check New enquiry.
Tip, pin your CRM tab, add the task view to bookmarks, and set calendar reminders for pipeline reviews each Friday.
Printable weekend checklist
- Create free CRM account, confirm login
- Add company branding (and email BCC address if available)
- Clean spreadsheet on a copy, dedupe, fix emails and phones, add Source, Stage, Tags
- Import 20 test rows, verify mapping, then full import
- Create fields you need, keep it to the essentials
- Build a five stage pipeline
- Turn on, welcome email, proposal follow up task, new enquiry task
- Add three dashboard widgets, open deals, tasks due, new this week
- Do the 30 minute (team) walkthrough; record it
- Set a Friday 15 minute review to keep it tidy
Print this, tick as you go, and you will be done by Sunday.
FAQs answered quickly
- How do I set up a simple CRM fast? Choose a free, simple tool, clean your data on a copy, import only essential fields, build a five stage pipeline, switch on three small automations, and train in 30 minutes.
- Is there a free CRM I can start with in the UK? Yes, try HubSpot Free, Zoho Free, Bigin Free or Capsule Free; each supports contacts, deals and tasks.
- How do I clean and import my contacts without a mess? Back up, remove duplicates, standardise emails and phones, add Source and Stage columns, test import with 20 rows, then import all.
- What are the five steps of the CRM process for small businesses? Capture, qualify, propose, close, and follow up or onboard.
When to hand off
If your spreadsheet needs heavier work, you want custom fields mapped across multiple lists, or you need deeper integrations with email and calendars, this is a good point to get support. A short setup service can move you from good enough to robust in days without losing momentum. If you want a light, practical approach, my CRM setup service can pick up where you leave off.
Summary
You can build a small but mighty CRM in one weekend. Pick a tool, clean and import a tidy list, create a short pipeline, turn on three automations, and practise a daily task routine. That is enough to stop enquiries slipping, to follow up on time, and to feel in control by Monday morning. Start light, keep notes brief, and add fields when you need them. If you would like help making the import spotless or connecting email, I can handle that for you, so you stay focused on conversations and delivery.
If you prefer to delegate the list clean up entirely, my CRM system setup service supports data mapping, deduplication and a calm, documented handover.
If you already have a CRM and want to read more about making the most of it, please head to this previous blog post.
