How to track leads in Excel comes down to one sheet, one row per lead and a fixed set of columns that everyone fills the same way. This article answers two practical questions: how to lay out a spreadsheet that still works when several people use it, and how to tell when it has outgrown itself and should move into a CRM. If you are asking how to track sales leads in Excel because a proper system feels like too big a step, you can start today and still keep the option of importing everything cleanly later.
When a spreadsheet is the right tool
A spreadsheet is a sensible lead tracker for a small team with a modest number of open leads and one person who owns the file. It costs nothing extra, everyone already knows how to use it, and it forces you to decide what you want to record before you buy anything.
It stops working when three things happen together: more than one person edits it at the same time, leads arrive from several routes, and someone needs to be reminded to follow up. A spreadsheet has no memory of who changed what, cannot capture a web enquiry on its own and will never tell anyone that a lead has gone quiet.
The columns that matter
Keep the sheet narrow. Each extra column is another thing people leave blank. These columns cover what most firms need.
- Date created
- Name, company, email and phone, each in its own column
- Source, chosen from a fixed list
- Owner, chosen from a fixed list of salespeople
- Status, chosen from a fixed list such as new, contacted, qualified, proposal, won, lost
- Estimated value
- Next action and next action date
- Last contact date
- Loss reason, filled only when status is lost
- Notes, kept short
Put each fixed list on a separate tab and turn those columns into dropdowns, so people pick a value rather than typing one. Free-typed status and source values are the single biggest reason a lead spreadsheet becomes unusable.
Before you start
- Agree the fixed values for source, owner and status, and write them on the lists tab.
- Choose one person who owns the file and is allowed to change its structure.
- Store it somewhere shared with version history, not as an email attachment.
- Decide which day each week the owner will review it.
How to set it up
- Create a new workbook with one tab for leads and one tab for lists.
- Enter your source, owner and status values in separate columns on the lists tab.
- Type the column headings on the leads tab in the order given above.
- Turn the source, owner and status columns into dropdowns fed by the lists tab.
- Format the date columns as dates so they sort and filter correctly.
- Add a highlight rule that colours any row whose next action date has passed.
- Freeze the header row and turn on filters.
- Enter ten existing leads and check that filtering by owner and status works.
- Share the file with edit access for the sales team and view access for everyone else.
Moving the sheet into the platform
When the spreadsheet starts to strain, the same columns import directly. That is the payoff from keeping the values consistent: the move takes an hour rather than a week.
- Save the leads tab as a CSV file.
- Create any custom fields the platform lacks, such as loss reason, before you import.
- Go to Contacts, click the Smart Lists tab, then click Import Contacts.
- Choose Contacts and Opportunities if the sheet has pipeline and stage columns, or Contacts only if it does not.
- Click Next, upload the CSV and choose to add the rows as new contacts.
- Map each spreadsheet column to its field, and leave columns you do not need unmapped.
- In the import preferences, add a tag naming the spreadsheet so you can find the batch later.
- Start the import, then open Bulk Actions and click Show Stats to check for rejected rows.
Picture a sheet with 600 rows after two years and three negotiators editing it daily. In a busy month, two valuations could be booked twice and four enquiries never called back because their rows were sorted out of view. Importing the sheet, setting an owner on every open lead and letting the platform remind each negotiator of overdue follow-ups closes both gaps.
What the spreadsheet costs you in time
A well-kept lead sheet takes the owner about half an hour a week to tidy: fixing typed values, chasing blank owners and archiving closed rows. Each salesperson spends a few minutes a day updating their rows. The hidden cost is the work done outside the sheet, such as copying form enquiries in by hand and checking the inbox for replies. Once that copying takes more than an hour a week, a CRM pays back the effort of moving.
The mistake most people make
Letting everyone add their own columns. Within months the sheet has three status columns, two note fields and a colour code only one person understands. Lock the structure, give one person the right to change it, and put anything extra in the notes column.
When not to use a spreadsheet at all
Skip the spreadsheet stage if leads already arrive through web forms, chat or calls in meaningful volume. Copying them in by hand guarantees gaps, and you lose the source data that tells you which channel works. In that case go straight to a CRM, where capture from forms and chat creates the record for you. Skip it too if several people need to follow up the same leads, because nothing in a spreadsheet will remind them.
Troubleshooting
Filters return the wrong rows
Someone has typed a value instead of picking from the list, often with a trailing space. Filter the column, look for near-duplicates and correct them.
Dates sort in the wrong order
Some cells are stored as text. Reformat the column as a date and re-enter the affected values.
Two people overwrote each other's changes
The file is being edited as separate copies. Keep one shared copy with live co-editing and version history.
The import into the platform creates duplicates
The sheet contains the same person twice with different email spellings. Clean duplicates in the sheet before you import, or match on email during import.
Frequently asked questions
Is there a free lead tracking template for Excel?
You can build one in fifteen minutes from the column list above, which will suit your process better than a downloaded template. The important part is the dropdowns on source, owner and status.
How do I get reminders from a spreadsheet?
You cannot, beyond highlighting overdue rows when someone opens the file. If reminders matter, that is the signal to move. The method for keeping every lead owned and followed up covers what replaces them.
Can I track lead source accurately in a spreadsheet?
Only for leads you enter yourself, and only if people ask and record it. Automatic capture needs forms with hidden fields; see capturing where leads come from.
Should I keep the spreadsheet after moving to a CRM?
Archive it, read-only, for reference. Running both in parallel splits the team between two versions of the truth within a fortnight.