The investor CRM spreadsheet: a template that actually works

You do not need a fancy tool to run a fundraise. You need a single spreadsheet that tells you, at a glance, who you have contacted, where each conversation stands, and what you owe each person next. Most founders either skip this entirely and lose track, or overbuild it with twenty columns they never fill in. The version that works sits in the middle: a small set of columns, kept honest, updated after every touch.

Here is the template, why each column earns its place, and how to run the pipeline through it.

The columns that matter

Keep it to these. Every column here answers a question you will actually ask during the raise.

• Name - the person, not just the firm. You email people.
• Firm - where they invest from, blank for independent angels.
• Email - the verified address you are actually sending to.
• Stage - the stage they invest at, so you can filter out mismatches fast.
• Sector - their focus, matched to your company.
• Status - where this conversation stands right now.
• Last touch - the date of your most recent contact.
• Next step - the single next action, and who owns it.
• Source - where the contact came from, so you can tell what is working.

That is the whole thing. Resist adding more until you have felt the lack of it. Nine columns you keep current beat twenty you abandon in week two.

A note on each of the less obvious ones. Status is the heartbeat of the sheet; more on it below. Last touch stops people from falling through the cracks, because a glance down that column tells you who has gone quiet. Next step is the most important column and the one most founders leave blank; if you cannot name the next action, the conversation is already stalling. Source tells you which channel is producing real meetings, so you double down on it and drop the rest.

A status column that means something

Status only helps if every value maps to a real stage of the funnel. Pick a fixed set and use nothing else. A clean set looks like this:

• To contact - on the list, not yet emailed.
• Contacted - first email sent, no reply yet.
• Replied - they wrote back, positive or negative.
• Meeting - a call is booked or has happened.
• Diligence - they are actively looking, asking for materials.
• Committed - soft or hard yes.
• Passed - a no, with a one-line reason if you have it.

The discipline is to update status the moment something changes, not at the end of the week. A CRM that is three days stale is worse than none, because you will trust it and it will be wrong. When you log a pass, write the reason next to it. Over a whole raise those one-line reasons form a pattern, and that pattern tells you whether the problem is your pitch, your stage, or your targeting. For reading those patterns, why investors pass is a useful companion.

Running the pipeline

The sheet is not a filing cabinet. It is a worklist. Here is the daily loop.

Sort by status and last touch. Every morning you are looking for two things: people in Contacted who have gone quiet and are due a follow-up, and anyone whose Next step is blank. Those blanks are stalled conversations pretending to be alive. Fill them or close them.

Work in waves, not all at once. Move a batch from To contact to Contacted, watch the replies come in over a few days, and learn from them before you send the next wave. This keeps your follow-ups manageable and lets your message improve as you go. For sizing how big the whole list should be, how many investors to contact walks through the funnel math.

Never let a live conversation sit without a next step. The single biggest reason deals die is not rejection, it is silence, and silence usually starts on your side. If someone met with you and you have not defined the next action, that is your problem to fix today.

Log every touch. When you send, reply, or meet, update Last touch and Next step immediately. It takes ten seconds and it is the difference between a pipeline you trust and a pile of half-remembered threads.

Seeding the sheet from a CSV

The slow, error-prone part of building this is filling the first six columns by hand: name, firm, email, stage, sector, and getting the emails right. Typing addresses from memory or scraping them one at a time is where bounces and wasted weeks come from.

The faster path is to seed the sheet from a verified export. A CSV export gives you name, firm, social links, email, sector, and stage as columns already, which maps almost exactly onto the template above. You paste it in, add your three workflow columns - status, last touch, next step - and you have a working CRM populated with verified contacts in a few minutes instead of a few days. The emails are already checked for deliverability, so your top-of-funnel does not collapse on bounces before you have sent a word.

You can export the full database or export any list, search, or firm as a CSV, which means you can build a focused sheet for exactly your stage and sector rather than importing thousands of names you will never contact. For the outreach side of this same workflow, see the CSV outreach workflow, and to build the underlying list first, build an investor list from scratch.

Keep it small and current

The best investor CRM is the one you actually update. Nine columns, a clean status set, a next step on every live row, and a source column so you know what is working. That is the entire system. Everything fancier is a way to avoid the real work, which is contacting people and following up.

To fill it fast, export a verified CSV with name, firm, email, sector, and stage already as columns, or start from the free curated lists to seed your first wave without any signup.