- A cap table spreadsheet is the right tool for the very earliest stage: two or three co-founders, no external investors, no option pool.
- Most free cap table templates have 4–5 columns and lump every security type into one flat list — that's where accuracy problems start.
- The fully diluted column is the most common silent failure: it's the number investors negotiate on, and it's almost always wrong once SAFEs are in the mix.
- Five concrete triggers signal it's time to stop using a spreadsheet; the most common is a cap table that's more than 60 days out of date.
- A spreadsheet is a good starting point, not a long-term solution.
A spreadsheet is the most popular cap table platform in the world. It's also the one that breaks the most fundraises.
At Cake, we migrate founders off spreadsheets every week. The patterns repeat. The same formulas are wrong in the same ways. The fully diluted column quietly rounds off 2%. The option pool gets counted twice. A SAFE from 18 months ago is still sitting as a row labelled "TBD."
None of that is a criticism of spreadsheets. Google Sheets and Excel are remarkable tools, and for the first handful of stakeholders in a company's life, a well-built cap table spreadsheet does the job. The problem is that "first handful of stakeholders" lasts a shorter time than most founders expect.
This guide covers what a cap table spreadsheet is, what it actually needs, how to build one that holds up for the first 12 months, and the honest signals that it's time to stop.
Download Cake's free template to see what a proper cap table looks like. Treat it as a reference, verify all formulas against your own equity documents before relying on any numbers. As always, we highly recommend working with experts to check your cap table maths.
What a cap table spreadsheet is
A cap table spreadsheet is a document that tracks who owns equity in a company, in what form, and in what quantity. It is the ownership record your company runs on.
At its simplest, it is a table: shareholders in rows, equity data in columns. Every share certificate, option grant, SAFE, convertible note, and warrant your company has issued should appear somewhere on it.
What makes a cap table a cap table, rather than just a list of shareholders, is that it shows the full picture of ownership: common shares, preferred shares, issued and unissued options, unconverted SAFEs, warrants, and the fully diluted total that accounts for everything that could become equity.
Getting this full picture right in a spreadsheet is straightforward at incorporation. It becomes progressively harder with every new instrument added.
The spreadsheet version and the software version are not fundamentally different things. They are the same ownership record at two different stages of a company. Most founders start on one and eventually move to the other. This guide is about understanding how to build the spreadsheet version correctly — and when that move makes sense.
What a cap table spreadsheet actually needs
A functional cap table spreadsheet needs eight core columns and a separate section for each share class. Most free templates circulating online have four or five columns and lump every security type into one flat list. That's where accuracy problems begin.
The eight columns that matter:
The distinction between issued and fully diluted is where founders get burned most often. Issued ownership tells you who owns what today. Fully diluted ownership tells you who owns what after every contingent security converts. Investors negotiate on fully diluted numbers. So do acquirers. So do employees once they understand their option grants.
Issued-only cap tables are the reason founders show up to a Series A pitch thinking they own 55% of the company and leave the meeting realizing, post-conversion, it's closer to 42%.
Alongside columns, the spreadsheet needs structural separation by share class:
- Founder common stock — usually issued at incorporation
- Preferred stock — one section per round (Seed Preferred, Series A, etc.) with liquidation preference and conversion notes
- Option pool — broken into granted options (to specific employees) and unissued reserved pool
- SAFEs and convertible notes — tracked as placeholders with valuation cap, discount, and MFN terms, not as equity
- Warrants — any contingent rights granted to lenders, advisors, or investors
Mixing these into one flat list is the single most common structural mistake we see when migrating founders off Excel. It makes the math unreliable and the document unreadable to anyone who didn't build it.
For a fuller list of the traps founders fall into, we've written a guide on the most common cap table mistakes startups make.
How to build the spreadsheet step by step
Build it in four steps, in this order. Trying to do them in parallel is how templates end up with broken formulas.
Step 1. Set up share classes as separate table sections.
Open a blank sheet. Create labeled blocks with subtotals for each share class: Founder Common, Preferred (one per round, if any), Options Granted, Options Reserved (unissued pool), SAFEs and Convertibles, Warrants. Each block has the same eight columns but its own subtotal row. A grand total row at the bottom reconciles everything to the fully diluted share count.
This structure looks more complex than a flat list. It's actually what makes the math more reliable.
Step 2. Enter stakeholders with security type and issue date.
For each holder, log the security type, the exact issue date, the share count, and the price paid. Add a notes column for vesting schedules, board approvals, 83(b) election filing dates, and agreement references. These feel like overkill at first. But they're the difference between a clean data room and a panicked weekend during diligence.
Issue date matters more than most founders realize. It drives vesting calculations, 83(b) election deadlines, and QSBS eligibility. A missing issue date is one of the first things a lawyer flags in a diligence review.
Step 3. Layer on the ownership math.
Issued ownership is straightforward: shares held divided by total issued shares.
Fully diluted ownership is where templates silently fail. The formula is:
Holder's shares ÷ (Total issued shares + Unissued option pool + SAFE conversion shares at assumed cap + Convertible note conversion shares + Warrants)
The SAFE placeholder math is the part that breaks. SAFEs don't convert into a fixed number of shares. They convert based on the next priced round's price, subject to the valuation cap and discount. Most spreadsheet templates either ignore SAFEs entirely, list them with a guess, or build a standalone "SAFE conversion" tab that no one updates when terms change.
We've written a detailed guide on managing SAFEs and convertible notes if you want to go deeper into the workflows.
Step 4. Stress-test with a dummy priced round.
Before you trust the spreadsheet, add a hypothetical priced round. $2M raised at an $8M pre-money valuation, with a 10% option pool top-up created pre-money. Watch what happens.
Existing SAFEs should convert to preferred at their cap or discount, whichever is better for the holder. New preferred should issue at the round price. The option pool expansion should dilute existing holders, not incoming investors. Your founder ownership should drop by the mathematically correct amount.
If your spreadsheet can't model this without manual patching, it may not survive a real round. Typically, real rounds have six SAFEs with different terms, a last-minute option pool negotiation, and an investor who wants to see the fully diluted table updated three times in one afternoon.
The most common spreadsheet error we see when migrating founders off Excel: double-counting the option pool. Once as reserved, once as issued. That single error overstates dilution by 3 to 5 percentage points, which is a meaningful amount of ownership to get wrong when an investor is reading the file.
Skip the sheets. Start free with Cake.
Cake's free tier covers up to 5 stakeholders and gives you everything a spreadsheet does, plus the things it can't.
- Auditable change history so every update is logged against board consents, not just "last edited by"
- Lawyer-reviewed SAFE templates with built-in conversion logic, so the fully diluted number is always right
- Built-in ownership math. Issued and fully diluted percentages recalculate automatically as you add stakeholders
- Stakeholder portal so investors and employees see their own holdings without emailing PDFs
- US compliance built in. 409A valuations, Form 3921 filing, and QSBS attestation are handled inside the same platform, not bolted on later
It takes about 10 minutes to set up, costs nothing until your 6th stakeholder, and the cap table you build on day one is the same one you'll show investors 12 months from now.
What a spreadsheet cap table can't do
Four things. All four show up in the first priced round.
1. Version control and a real audit trail.
Spreadsheets track who edited last. They don't track who approved what. When an investor or auditor asks for the board consent that authorized a specific share issuance, "Sarah edited this cell on March 14" is not the answer. A legitimate audit trail ties every change to the governing document — the board consent, the stock purchase agreement, the option grant agreement. Spreadsheets don't enforce that link. They can't.
2. SAFE-to-equity conversion modeling.
Every SAFE has some combination of a valuation cap, a discount, and an MFN clause. Modeling how six SAFEs with different terms convert in a $3M priced round with a 20% option pool top-up is a multi-hour exercise in most spreadsheet setups. And it's rarely right the first time. We've seen founders re-run the conversion math three or four times during a single fundraise negotiation, with the fully diluted table shifting each iteration.
3. Linking option grants to a current 409A.
Every option grant needs a strike price set at or above the fair market value of the common stock, as determined by a current 409A valuation. Spreadsheets can store the strike price as a number. They can't enforce the link to the underlying 409A report, flag when the 409A expires, or update strike prices on new grants when a fresh valuation comes in. That gap is the source of real tax exposure for employees. If the IRS later determines a strike price was below fair market value, the penalty falls on the option holder, not the company.
4. Board- and investor-ready reporting.
A clean PDF cap table for a board pack. A fully diluted summary in the format the VC wants. Each of these takes hours to format from a spreadsheet. And each is outdated the moment it's shared, because the spreadsheet keeps moving.
Founders usually discover these limits during due diligence, which is the worst possible moment.
5 honest signals it's time to switch to a cap table software
Five concrete triggers. If you've hit any two of them, the spreadsheet is already costing you more time than software would cost in money.
Trigger 1. You've issued your first option grant to an employee.
Option pools add vesting schedules, cliff dates, strike prices, and 83(b) filings. Each option grant is a document that needs to reconcile to the cap table. Tracking this in a spreadsheet is possible. Keeping it clean for more than a year is not.
Trigger 2. You've signed more than three SAFEs with different caps or discounts.
Conversion modeling compounds with each SAFE. At three, it's tedious. At five, it's error-prone. At seven, it's the reason your fundraise close slips by two weeks.
Trigger 3. You're preparing for a priced round.
Investors expect a clean, auditable cap table in a data room format. They expect fully diluted numbers that tie to the stock purchase agreement. They expect to be able to ask "what if we add a 15% option pool?" and see the answer in under a minute.
Trigger 4. You've hired anyone who needs visibility into their own equity.
Emailing option grant PDFs once a year is not equity communication. Employees who can't see their own holdings don't feel ownership. Founders who have to answer "what's my vesting schedule again?" in Slack five times a week eventually stop bothering to offer equity at all.
Trigger 5. Your last cap table update was more than 60 days ago.
Stale cap tables are the single most common cause of last-minute fundraise delays we see. The mental tax of "I need to update the spreadsheet before I share it" is what causes the 60-day gap in the first place. Live cap tables don't have that friction.
For founders at this point, the question shifts from "do I need software?" to "which software fits a company my size?" We've written a full comparison in our guide to the best cap table software for early-stage startups.
Frequently asked questions
What is a cap table spreadsheet?
A cap table spreadsheet is a document in Excel or Google Sheets that tracks the equity ownership of a company: who holds shares, in what form, and in what quantity. Almost every startup begins with one. The spreadsheet works well at the earliest stage and becomes harder to maintain accurately as equity complexity grows.
What should a cap table spreadsheet include?
At minimum: stakeholder legal name, security type (common, preferred, SAFE, option, warrant), share count, issue or grant date, price per share, amount paid, and ownership percentage calculated against both the issued total and the fully diluted total. It should also capture the option pool reserve and authorised but unissued shares. Each line should trace back to a signed legal document.
Is a spreadsheet cap table legally valid?
Yes. A cap table is an internal ownership record, and no regulator mandates a specific format. What matters is that it reconciles to your governing documents — board consents, stock purchase agreements, option grant agreements, SAFE notes. Most cap table disputes come from mismatches between the spreadsheet and the signed documents, not from the format itself.
What does "fully diluted" actually mean?
Fully diluted ownership assumes every option, SAFE, and convertible note has converted into common stock. It's the number investors use to negotiate valuation, the number acquirers use to structure deals, and the number employees should use to value their option grants. Issued-only percentages look higher, but they overstate real ownership. A founder with "55% issued ownership" and a full option pool plus five SAFEs outstanding typically has something closer to 42% fully diluted.
Can I use Google Sheets instead of Excel?
Yes, and most founders do. Sheets has better collaboration, cleaner sharing, and a version history that's more useful than Excel's. The structural limits are identical, though — no audit trail tied to board consents, no enforced link to 409A valuations, no automated SAFE conversion modeling, no stakeholder portal. The upgrade path isn't "switch from Excel to Sheets." It's to move off spreadsheets entirely once the company outgrows the format.
Is there a free cap table spreadsheet template?
Cake has a free template with all eight columns, pre-built ownership formulas, and example rows for every security type. Download it here. Take note that this is created for illustration purposes. Treat it as a reference, verify all formulas against your own equity documents before relying on any numbers. As always, we highly recommend working with experts to check your cap table maths. Templates are a reasonable starting point at the earliest stage; the limitation is what they cannot do as equity complexity grows.
When should a startup move from a spreadsheet to cap table software?
The clearest signal is hitting two or more of these: modeling a first priced round with SAFEs converting, issuing more than about five equity grants, receiving an investor request for an auditable cap table, preparing for a 409A valuation, or having employees who expect visibility into their own equity. Any one is a strong signal. Two is the point at which the operational cost of staying on a spreadsheet typically exceeds the cost of moving.
What are the most common cap table spreadsheet errors?
The three we see most often: double-counting the option pool (listed as both reserved and issued, which overstates dilution by 3–5 percentage points); SAFEs recorded as loans or not recorded at all, so the fully diluted column ignores them entirely; and multiple spreadsheet versions with no clear source of truth, so no one is certain which file is current. All three are fixable — but far easier to fix before a fundraise than during one.
A spreadsheet cap table is a good starting point, not a long-term solution
The founders who move off spreadsheets earliest tend to be the ones whose first priced round closes fastest — not because the software is magic, but because a clean, auditable cap table removes the single biggest source of diligence friction. When an investor asks for the cap table and you send a link instead of spending the weekend reconciling a spreadsheet to your SAFE folder, you close the round faster.
Whether you build a spreadsheet today or start fresh on Cake's free cap table tier, the standard is the same: accurate, auditable, and current. Get started free →
This article is designed and intended to provide general information in summary form on general topics. The material may not apply to all jurisdictions. The contents do not constitute legal, financial or tax advice. The contents is not intended to be a substitute for such advice and should not be relied upon as such. If you would like to chat with a lawyer, please get in touch and we can introduce you to one of our very friendly legal partners.
