Skip to content
Free template

A lead tracker that forces the next step.

A free CSV template for Excel, Google Sheets or Numbers — with a next-action column on every row, so no lead is left without a plan.

What’s in it

Thirteen columns and one example row. The first ten match AutoSalesPilot.ai’s lead import fields, so the same file can be imported later without remapping.

ColumnWhat to put in itExample
Full NameThe lead’s name. The only required column.EXAMPLE — delete this row
EmailUsed to spot duplicates.[email protected]
PhoneAlso used to spot duplicates.+1 555 0100
CompanyThe organisation they buy for.Example Co
SourceWhere the lead came from: website, referral, event, ad…Website form
Lead Status / StageOne of the stages below.Qualified
OwnerWho is responsible for the next step.Alex
Deal ValueEstimated value, numbers only.12000
Lead Score0–100: how likely and how valuable. Your best judgement is fine.70
NotesContext that will matter in the next conversation.Asked for pricing for 10 seats
Last Contact DateYYYY-MM-DD.2026-01-15
Next ActionThe single next step, written as a verb: “Send revised quote”.Send pricing and book a demo
Next Action DateYYYY-MM-DD. Every open lead should have one.2026-01-16

Stage definitions

Agree these as a team. A stage only means something if everyone moves leads for the same reason.

Stage 1
New
Move a lead here when: the lead has arrived but nobody has spoken to them yet.
Stage 2
Contacted
Move a lead here when: you’ve reached out; no real conversation yet.
Stage 3
Qualified
Move a lead here when: there is a real need, budget or timeline, and a decision-maker you can reach.
Stage 4
Proposal
Move a lead here when: a quote or proposal has been sent.
Stage 5
Negotiation
Move a lead here when: terms, scope or price are being discussed.
Stage 6
Won
Move a lead here when: they said yes.
Stage 7
Lost
Move a lead here when: they said no or went silent. Record why in Notes.

Three rules that keep it useful

  1. Every open lead has a Next Action and a Next Action Date. Filter by date each morning.
  2. Update the row the moment something happens, not at the end of the week.
  3. When a lead is Lost, write down why. The pattern is worth more than any single deal.
Want this done for you?
Outgrowing the spreadsheet? Import this file into AutoSalesPilot.ai and every lead gets scored, a next best action and a drafted follow-up.
Start free trial