A Simple Customer Tracker: Your First CRM Template
Keep customer enquiries, follow-ups and sales in one spreadsheet. Copy the template into Google Sheets or Excel and start with the contacts you already have.
Who is this for
For shop owners, service businesses and freelancers who rely on messages and memory to keep track of potential customers.
What you'll get
- A ready-to-copy spreadsheet with consistent fields for every enquiry.
- A clear follow-up list showing who needs a reply and what to do next.
- A simple way to see which enquiry sources lead to completed sales.
1. Copy your starter template
Open a blank Google Sheets or Excel spreadsheet and paste the text below into cell A1. The fields are separated by tabs. If everything lands in one column, use the text-to-columns feature and choose a tab separator. The sample business is fictional; replace it with a real enquiry.
Enquiry ID Customer or business Contact details Source Product or service Stage Last contact date Next action Follow-up date Owner Sale amount (your currency) Short note E001 Example Coffee Shop Existing business email Referral Monthly content service Proposal sent 2026-04-06 Ask whether they have questions about the proposal 2026-04-09 Sam Interested in a one-month trial
- Use one row per enquiry. A returning customer with a new order gets a new row and a new ID.
- Record the contact detail you actually use, such as a business email, phone number or profile link.
- Source means where the customer found you. Use simple labels such as search, referral, social media or walk-in.
- Enter the sale amount once the order is confirmed. Leave it blank while the enquiry is still open, and use one currency throughout.
2. Make the sheet easy to maintain
- Freeze the header row and turn on filters. A filter lets you show only the rows you need, such as open enquiries.
- Create a dropdown for Stage: New enquiry, In discussion, Proposal sent, Sale completed, Closed without sale.
- Format both date columns as dates. Use a consistent display such as 2026-04-09 so the team reads them the same way.
- Enter ten recent enquiries. Assign a specific next action, a due date and one owner to each open row. If you work alone, use your own name.
- Share the sheet with the people who need it for their work. Give editing access to those responsible for updating it.
Keep notes relevant to the enquiry. Do not store identity documents, payment card details or personal observations in this sheet. If someone asks you to stop contacting them, record that request and remove their follow-up.
3. Turn the tracker into a daily habit
- At the start of the day, filter for open enquiries with a follow-up date of today or earlier.
- After each conversation, update the last contact date, stage and next action. Write 'Confirm delivery address' instead of 'Follow up'.
- When a sale closes, enter its value and clear the completed follow-up. For an unsuccessful enquiry, note the reason only if you know it.
- Once a week, check for open rows without an owner or a due date. Compare enquiry counts and completed sales by source before deciding where to spend more effort.
For example, a customer asks a homeware shop whether a lamp is available in blue. The next action is 'Check blue stock and reply', with one person responsible. A useful CRM row tells someone what to do without rereading the entire conversation.
Google Sheets and Excel work well for a basic shared tracker. This template does not automatically capture messages or send reminders. Consider dedicated CRM software when manual updates and handing enquiries between colleagues become a recurring problem.
Go further with the AI Builders community
Visit the Azerbaijani AI Builders community at https://abcommunity.org/resurslar for real examples, peer feedback and discussion. Share a version of your tracker with customer details removed and fictional entries added. Explain what worked in your first week and ask how others handle follow-ups.
FAQ
Should I import every past customer first?
Start with active conversations and ten recent enquiries. Use the sheet for a week before importing older records. That gives you time to fix confusing fields before creating more work.
Does every message need its own row?
Keep messages about the same purchase in the existing row. Create a new row for a separate order or service request. Search by email, phone number or profile link before adding an enquiry to avoid duplicates.
What should I do when a customer stops replying?
Record your last contact and note that no reply arrived. Set another follow-up only if it makes sense for that conversation. If you close the enquiry, use 'Closed without sale' and 'No reply'. Silence does not tell you whether price was the problem.
More resources
A workbook combining audience research, a 30-day plan, budget/KPI, a simple business plan and an AI ROI calculator.
Build a simple pricing worksheet, check what each sale contributes and calculate how many orders you need to cover your monthly costs.
A working checklist for choosing a customer, testing a paid offer and reviewing your first month. Includes simple templates for tracking conversations, orders and spending.