How-to guides
A CRM template for Excel you can build in an hour
A spreadsheet works as a CRM while you have a few dozen customers and one person updating it. Here is the exact layout, the formulas worth keeping, and the point where it stops working.
What should a CRM spreadsheet contain?
It answers three morning questions: who are my customers, what is each deal worth, and who do I contact today. That gives you three sheets:
- Contacts — the people and companies you deal with.
- Pipeline — the deals you are trying to win, one row each.
- Activity log — calls, emails, meetings and quotes, with dates.
One rule from the start: one row, one thing. Never put two phone numbers or two deals in a cell, and never merge cells; sorting, filtering and importing all break on them.
Sheet 1: the customer list (columns to copy)
Create a sheet named Contacts and put these headings in row 1. Text in [brackets] is a placeholder for you to replace.
| Column | What goes in it | Tip |
|---|---|---|
| ID | C001, C002, C003… | A short code you can use in the other sheets |
| Full name | [First and last name] | One person per row |
| Company | [Company name] | Spell it the same way every time |
| [name@example.com] | Lowercase, one address | |
| Phone | [+1 555 0100] | One number, with country code |
| Source | [Website, referral, trade show, cold call] | Pick from a dropdown list |
| Status | [Lead, Customer, Past customer, Not interested] | Dropdown |
| Owner | [Who on your team handles them] | Dropdown of names |
| First contact date | [date] | Format the column as Date |
| Last contact date | [date] | Update after every touch |
| Next contact date | [date] | The most important column |
| Next step | [Send quote, call back after the 15th] | Short and specific |
| Notes | [anything useful] | Keep long history in the log sheet |
Use dropdowns (Data → Data Validation → List) for Source, Status and Owner, so you never get "Referral", "referral" and "refered". Turn the range into a table (Insert → Table) so new rows inherit formulas.
Sheet 2: the pipeline sheet for deals
A contact can have several deals over the years, so deals get their own sheet. Name it Pipeline.
| Column | What goes in it |
|---|---|
| Deal ID | D001, D002… |
| Contact ID | The code from the Contacts sheet |
| Deal name | [Kitchen remodel, annual support plan] |
| Stage | New, Contacted, Quote sent, Negotiation, Won, Lost |
| Value | [amount in your currency] |
| Probability | [10%, 25%, 50%, 75%, 100%, 0%] |
| Weighted value | formula, see below |
| Expected close date | [date] |
| Next step | [what happens next] |
| Next step date | [date] |
| Reason lost | [price, timing, chose a competitor] |
Keep the stages to five or six. If you cannot say what moves a deal to the next stage, the stage is not real; sales pipeline management covers how to define them.
Sheet 3: the activity log
The log is where you stop trusting memory. One row each time you talk to someone.
| Column | What goes in it |
|---|---|
| Date | [date] |
| Contact ID | C001 |
| Deal ID | D001, or blank |
| Type | Call, Email, Meeting, Message, Note |
| Summary | [what was said, what was promised] |
| Outcome | [Interested, No answer, Needs quote] |
| Next step and date | [Call Thursday] |
Add rows at the bottom and never edit old ones.
Which formulas are worth using?
You do not need macros. Adjust the column letters to your sheet.
- Days since last contact:
=TODAY()-J2(J is the Last contact date). Format it as Number, not Date. Sort by this column to see who has been ignored longest. - Overdue flag:
=IF(AND(K2<>"",K2<TODAY()),"OVERDUE","")placed next to the Next contact date. Add conditional formatting (Home → Conditional Formatting) so the word turns red. - Weighted value:
=E2*F2on the Pipeline sheet (value times probability). - Open pipeline total:
=SUMIFS(E:E,D:D,"<>Won",D:D,"<>Lost")adds up every deal that is still open. - Win rate:
=IFERROR(COUNTIF(D:D,"Won")/(COUNTIF(D:D,"Won")+COUNTIF(D:D,"Lost")),"")— the share of closed deals you won. - Customer name next to a deal:
=VLOOKUP(B2,Contacts!A:C,2,FALSE)pulls the name from the Contacts sheet using the Contact ID.
A pivot table (Insert → PivotTable) on the Pipeline sheet gives value by stage or owner.
Variants: sales tracker, client tracker and intake sheet
Sales tracker. Use only the Pipeline sheet, add Product and Month closed, and put a pivot table on top.
Client or project tracker. After a deal is won, add a fourth sheet linked by Deal ID: Start date, Deadline, Status (Not started, In progress, Waiting on client, Done), Responsible, Amount invoiced.
New-client intake sheet. An intake sheet records what you need to know about a new client before work starts. Use one row per new client with these columns:
| Column | Example content |
|---|---|
| Date received | [date] |
| Client name and company | [name] |
| How they found you | [source] |
| What they need | [one or two sentences] |
| Budget range | [amount or "not discussed"] |
| Deadline or desired start | [date] |
| Preferred way to be contacted | [phone, email, messenger] |
| Decision maker | [who signs off] |
| Documents received | [yes/no and which] |
| Consent to store details | [yes/no, date] |
For a full question list with consent wording, see the client intake form template; if you collect personal data, check the requirements that apply in your country.
How do you keep the sheet from rotting?
A spreadsheet CRM usually fails quietly: it is full at the start and then stops being opened. Open the file at the same time every day and filter Next contact date to today or earlier. Never end a conversation without a next step and a date. Give one person ownership, and keep a copy before every bulk edit.
What a CRM database holds shows how the same information is organized once you outgrow a file.
Signs you have outgrown the spreadsheet
- Two or more people edit it. Someone overwrites a note, or emailed copies diverge.
- Follow-ups depend on you remembering to look. A sheet cannot nudge a colleague when a deal has been quiet for two weeks.
- Customers write from several places. Email, a website form, WhatsApp and calls each need someone to copy details into a row.
- You need a customer's whole history. The log sheet is always behind.
- The list keeps growing. Scrolling past old rows wastes time, and one bad paste or a sort on a single column can scramble it.
None of these is a failure; it is the usual moment to switch. What a CRM is explains what changes.
How do you move an Excel CRM into NeuroCRM?
The steps in NeuroCRM:
- Clean the sheet first. One person per row, one email and one phone per cell, no merged cells or blank rows.
- Import the contacts. Open Contacts and use Import. The dialog accepts CSV, TSV, XLSX, XLS and ODS files. It shows the first five rows and lets you match each column to a field. A column with no matching field can be saved as a custom field, and Company can be matched too. At least one column must be marked as Name. Columns such as Owner, Status or the contact dates have no built-in field here; map them to custom fields, or leave them out. Naming the import also creates a list of those contacts, tagged with the same name.
- Check duplicates. If an imported row has an email or phone number that already exists, NeuroCRM updates that contact instead of creating a second one. Fields already filled on the existing card are not overwritten, and the import points out the rows where the file differs. For duplicates already in your list, select two or more contacts and use Merge, or open Settings → Duplicates & merge. Merging moves messages, deals and tasks into one contact and cannot be undone.
- Set up the stages first. In NeuroCRM, create a pipeline whose stage names match the Stage column exactly (New, Contacted, Quote sent…). The deal import puts each row into the stage with the same name; a row whose stage is not found goes to the first stage of the first pipeline. After import, each deal is a card you drag between stages. The Forecast view on the deals page works from stage probability, much like Weighted value.
- Import the deals. Open Settings → Import / Export. It handles contacts and deals from CSV or XLSX files up to 20 MB, and only admins can use it. Save older .xls files as .xlsx or CSV first, because this screen refuses .xls. It reads columns by their headings: for deals it takes title (or Deal name), amount (or Value), currency, stage, tags, won and the contact's email, phone or name (head that column "Contact name"; a plain "Name" column is read as the deal title). Before the import, add the customer's email or phone to each Pipeline row (a lookup from the Contacts sheet does it); the Contact ID alone does not link a deal to a contact. Probability, close dates and next steps are not imported; keep them in the spreadsheet or re-enter them as tasks.
- Turn Next step into tasks. Tasks have a due date and an assignee, and can repeat daily, weekly or monthly. A task with an assignee sends a bell reminder as the due time approaches and again when it is overdue.
Two things to know before you import. If you use Contacts → Import, look at the date columns in its five-row preview before you confirm, and keep dates in one format throughout the sheet. And if you have switched on automations that react to a new contact or a new deal, an import triggers them for every contact or deal it creates. Leave automations off until the import is checked.
A seat costs $13 per month, or $10.40 billed yearly, and the 14-day trial has every feature with no limit on users. See the pricing section.
What NeuroCRM does not do for a spreadsheet user
- No separate company import. Import covers contacts and deals. A company is created, or found, by the company name in the contact's row.
- No free plan. When the trial ends, the workspace turns read-only until you subscribe.
- Direct transfer only from Bitrix24. Data from any other CRM comes in as a file, the same way as your spreadsheet.
If you are weighing it against other tools, see the comparison pages.
FAQ
Is Excel good enough as a CRM?
Yes, for one person or a very small team with a modest number of customers. It stops working when several people edit it or contacts arrive from several channels.
Can I build a CRM template in Excel myself?
Yes: the three sheets above take about an hour.
What columns should a CRM spreadsheet have?
At minimum: name, company, email, phone, source, status, owner, last contact date, next contact date and next step. For deals add stage, value, probability and expected close date.
What is the difference between a sales tracker and a CRM?
A sales tracker follows deals through stages and totals their value. A CRM also keeps each customer's history and collects incoming messages from your channels.
How do I get my spreadsheet into a CRM without losing data?
Give each row one person with one email and one phone, and keep the headings in row 1. Contacts → Import lets you match columns and shows a preview; for deals, create the matching stages first.
How this article was made: written by the NeuroCRM team with AI assistance; product claims were checked against NeuroCRM code and help docs; prices are from the published pricing as of the update date.