How to Create a Simple CRM with Spreadsheets and Email Folders

A customer relationship management system does not need to begin with expensive software. For a small business, a well-designed spreadsheet paired with consistent email folders can provide a clear view of prospects, customers, follow-ups, quotes and sales. The real value comes from using the system regularly, rather than from choosing a complicated platform.

This approach suits Australian sole traders, family businesses, consultants and growing teams that need a practical way to manage relationships. A Melbourne web designer, a Brisbane bookkeeper or a tradie serving suburbs around Perth can all start with the tools already available in Microsoft Excel, Google Sheets and their email account.

A basic CRM also creates useful habits. It helps you remember who asked for a quote, when a customer expects a call, which lead came through a local networking event and whether an invoice is still awaiting payment. With a few clear fields and routines, your customer information becomes easier to manage and act on.

Decide What Your CRM Needs to Track

Start by listing the customer information you genuinely use. Avoid collecting every possible detail. A small business CRM should answer practical questions: Who is this person? What do they need? What did we promise? When should we contact them again? What is the next action?

Create one row for each contact or organisation. Useful spreadsheet columns include:

• Contact name and business
• Phone number and email address
• Lead source
• Customer or prospect status
• Product, service or job requested
• Last contact date
• Next follow-up date
• Notes and next action

Use plain language in the status field. “New enquiry”, “Quote sent”, “Negotiating”, “Won”, “On hold” and “Lost” are easier to understand than internal abbreviations. If you work with government, construction or larger corporate buyers, you may also need fields for purchase order details, tender deadlines or key decision-makers.

Keep sensitive information to a minimum. A spreadsheet is not the right place for passwords, complete payment card details or unnecessary personal data. Follow the Australian Privacy Principles when storing customer information, particularly if you collect health, financial or other sensitive details.

Build a Spreadsheet That Stays Useful

Use the first row for headings and freeze it so the labels remain visible while you scroll. Turn on filters, use consistent date formats such as 15/03/2025, and keep phone numbers as text so leading zeroes are not removed. A separate tab can hold a simple list of allowed statuses, lead sources and sales stages.

Conditional formatting can make urgent work visible. For example, highlight follow-ups due today in amber and overdue actions in red. A filter for “next follow-up date” gives you a daily call list without searching through old messages. Keep notes short and factual, such as “Sent revised quote after site visit” rather than writing a full conversation transcript.

For Australian businesses, include fields that match local operations. Record whether a price includes GST, note the state or territory where the customer is based, and capture the relevant time zone when dealing with clients across Australia. A business in Adelaide contacting a customer in Sydney may need to account for different working hours during daylight saving.

Protect the file with a strong password and restrict editing access to people who need it. Google Sheets provides sharing controls and version history, while Excel can be stored in a business cloud account with regular backups. Review access when a contractor or employee leaves.

Organise Email Around Customer Actions

Email folders should support the spreadsheet, not replace it. Create a small number of folders that match the stages of your work. Too many folders can make messages harder to find, especially when a customer moves from an enquiry to a quote and then to an active project.

A practical structure might include “New Enquiries”, “Quotes Sent”, “Active Customers”, “Waiting For Reply” and “Completed”. Apply labels or categories if your email service supports them. Use rules to move messages from web forms or known enquiry addresses into the correct folder automatically.

When a new enquiry arrives, add it to the spreadsheet before filing the email. Include the date, source and promised next step. Then use the email folder to store the detailed conversation. The spreadsheet remains your overview; the email thread holds the context.

Create a standard subject line for outgoing messages, such as “Quote – Smith Renovations – Kitchen Joinery”. This makes searches faster and helps anyone else handling the account. For shared mailboxes, agree on a naming convention and use flags or stars only for genuine actions that need attention.

Create A Reliable Follow-Up Routine

A CRM only works when every open opportunity has a next action. When you speak with a prospect, finish by recording what happens next and when it will happen. “Follow up next week” is less useful than “Email revised scope on Tuesday 18 March”.

Set aside a short block each morning or afternoon to review due follow-ups. Sort the spreadsheet by date, contact customers, then update the row immediately. If you are running a business in Australia, factor in public holidays, school holiday periods and end-of-financial-year activity when setting expectations. A customer in regional Queensland may also need a different schedule from a city-based client.

Use a simple rule for unanswered messages. For example, send one polite reminder after three business days, a second message a week later, then move the lead to “On hold” if there is no response. This prevents prospects from disappearing into an endless list while keeping your communication professional.

Make notes about outcomes rather than every detail. “Customer comparing two suppliers; call 28 March” is enough to guide the next conversation. If a lead is not suitable, record why, such as budget, timing or service area. This information can improve future marketing and qualification.

Keep Your Contacts Accurate And Secure

Schedule a weekly maintenance session to remove duplicate records, correct spelling and update contact details. Search by email address before creating a new row, as the same person may contact you from a personal address and a business address. Where appropriate, link both addresses to one organisation rather than creating two unrelated customer records.

Ask for permission before adding people to marketing lists. A person who requests a quote has not automatically agreed to receive every newsletter or promotional message. Keep transactional communication separate from marketing, and provide a clear way to unsubscribe. Australian spam rules require businesses to handle commercial electronic messages carefully.

You can also learn from structured approaches to reviewing people’s capabilities and responsibilities, such as these volunteer assessment tools. The same thinking can help a small business identify who owns each customer relationship, who is authorised to approve discounts and who should handle complex enquiries.

If several people use the CRM, define access levels. A salesperson may update leads, while an administrator manages contact details and a bookkeeper checks payment status. Keep a backup outside the main file and test that the backup can actually be restored.

Review The System And Improve It Gradually

At the end of each week, review a few basic figures: new enquiries, quotes sent, sales won, overdue follow-ups and leads that went cold. You do not need sophisticated dashboards at first. A filtered view and a few spreadsheet formulas can reveal whether enquiries are being answered promptly.

Look for bottlenecks. If many rows sit at “Quote sent”, perhaps your proposals need clearer pricing or a faster approval process. If leads arrive without a source, update your website forms and enquiry scripts. If completed customers keep receiving sales reminders, improve your status rules and email permissions.

Use learning opportunities to strengthen the wider system. SCORE Nashville offers business workshops covering practical topics that can support planning, marketing and management. Although your business operates in Australia, the underlying disciplines—knowing your numbers, understanding your customers and following a repeatable process—apply across markets.

Add automation only when the manual process is stable. A calendar reminder, a form connected to the spreadsheet or an email template may save time. Do not automate unclear stages, because a faster confusing process still produces poor customer service.

A Practical Setup Checklist

Spreadsheet essentials

• One row per contact or organisation
• Clear sales stages and lead sources
• Last contact and next action dates
• Filters, backups and restricted access

Email essentials

• A small set of action-based folders
• Consistent subject lines
• Rules for routine enquiries
• Flags for tasks with real deadlines

Set up the first version in an hour, then test it with five real contacts. Enter a recent enquiry, a current customer, an unanswered quote, a completed job and a dormant lead. Check that each record tells you what happened and what should happen next.

The system will become more valuable as your team uses the same terms and updates information at the same time. Make the spreadsheet the source of truth for status and follow-up dates, while email folders preserve the conversation history.

Start with the contacts already in your inbox, create the five or six fields you will use every day, and schedule a weekly review. That small step can give your Australian business a clearer pipeline, quicker follow-up and a more dependable way to turn enquiries into lasting customer relationships.