Cap Table Template: Free Excel Downloads and How to Use Them

Your cap table is one of the most consequential documents your startup will ever produce. Investors scrutinize it before writing checks, lawyers reference it during due diligence, and founders lose sleep over it during every funding round. Yet a surprising number of early-stage companies manage this critical document in a disorganized spreadsheet — or worse, a napkin sketch that nobody has updated since the seed round.

If you're looking for a cap table Excel template to get your ownership structure documented properly, you're in the right place. This guide covers what to look for in a solid template, how to use one correctly, where to download them for free, and when to graduate to dedicated cap table software.

What Is a Cap Table and Why Does It Matter?

A capitalization table — universally shortened to "cap table" — is a spreadsheet or document that maps out who owns what percentage of your company. At its most basic level, it lists every shareholder, the type of securities they hold (common shares, preferred shares, options, warrants, convertible notes), and the percentage ownership each security represents on a fully diluted basis.

Fully diluted is the operative phrase. A cap table that only tracks currently issued shares is incomplete and potentially misleading. Investors want to see ownership as it would look if every option, warrant, and convertible instrument were exercised or converted — because that's the real picture of economic dilution.

A poorly maintained cap table creates real-world consequences:

• Delayed funding rounds — VCs won't close until the cap table is reconciled, and cleaning up a messy one takes weeks
• Legal liability — inaccurate records can expose founders to disputes with employees or early investors
• Founder surprises — many founders discover mid-Series A that they're far more diluted than they thought

What to Look for in a Cap Table Excel Template

Not all cap table templates are created equal. A basic template might get you through a friends-and-family round but fall apart by Series A. Here's what separates a functional template from a great one.

Core Data Structure

A solid cap table template XLS file should include, at minimum:

• Shareholder name and type (founder, investor, employee, advisor)
• Security class (common, Series Seed preferred, Series A preferred, etc.)
• Shares issued and shares authorized
• Option pool — both allocated and unallocated
• Convertible instruments — SAFEs, convertible notes with principal, interest rate, discount rate, and valuation cap
• Price per share at each funding round
• Ownership percentage on both an issued and fully diluted basis

Scenario Modeling

The best startup cap table templates include a scenario or waterfall model — sometimes called a pro forma tab — that lets you simulate the impact of a new funding round. This means you can input a proposed pre-money valuation and new investment amount and immediately see how it dilutes all existing shareholders.

Waterfall Analysis

A waterfall tab models what each shareholder receives in a liquidity event (acquisition or IPO) at various exit valuations. This is critical for understanding the economics of your preferred stock liquidation preferences. Without it, you're flying blind when negotiating term sheet economics.

Option Pool Schedule (ESOP)

Any template worth using should include an option schedule that tracks individual grants, vesting start dates, cliff periods, and fully vested share counts. This feeds into the fully diluted share count on the main cap table.

Where to Download Free Cap Table Templates

Several reputable sources offer free cap table templates in Excel or Google Sheets format.

1. Carta's Free Templates

Carta (formerly eShares), the leading cap table management software company, offers free downloadable templates aimed at pre-seed and seed-stage companies. Their templates are well-structured and include basic round modeling. The obvious caveat: Carta wants you to eventually migrate onto their platform, so the templates are deliberately limited.

2. Y Combinator's Resources

Y Combinator provides a simplified cap table template alongside their standard financing documents (SAFEs, etc.). Because YC's ecosystem is deeply familiar to VCs, their format is widely recognized and trusted in early fundraising conversations.

3. Visible.vc

Visible offers a startup cap table template that integrates with their investor reporting tools. Their template is particularly strong on the investor communication side, making it easy to share updates alongside ownership data.

4. VC Beast Free Template

We've built a straightforward cap table Excel template designed for pre-seed through Series A companies. It includes tabs for the main cap table, an option pool tracker, a round modeling scenario tool, and a basic waterfall analysis. You can download it directly from our tools page — no email required.

5. Google Sheets Alternatives

If you prefer working in Google Sheets for real-time collaboration, Slidesgo and Lightercapital both offer free Google Sheets-based templates that mirror Excel functionality with the added benefit of cloud sharing and edit history.

How to Set Up Your Cap Table Template Correctly

Downloading a template is the easy part. Populating it accurately is where most founders run into trouble.

Step 1: Start With Incorporation Documents

Pull your articles of incorporation and any shareholder agreements. Note the total authorized shares — commonly 10,000,000 for a Delaware C-Corp at formation. Enter this as your authorized share count before assigning anything.

Step 2: Enter Founder Shares

List each founder's share count and note whether shares are subject to vesting. Founders operating under a 4-year vesting schedule with a 1-year cliff — the industry standard — should have vested and unvested shares tracked separately.

Step 3: Create the Option Pool

Most companies set aside 10–20% of fully diluted shares for an employee stock option pool (ESOP) before or during a funding round. Enter the total option pool authorization and then break it down into granted (allocated to specific employees/advisors) and ungranted (reserved but unissued) buckets.

Step 4: Add Investor Securities

For each investment round, create a new row (or section) with the investor name, shares issued, share class, price per share, and any applicable liquidation preference multiple. Common structures include 1x non-participating preferred (founder-friendly) and 1x participating preferred (investor-friendly).

Step 5: Handle SAFEs and Convertible Notes

SAFEs and convertible notes don't convert to equity until a triggering event (usually a priced round). In your template, track these instruments in a separate tab and use a conversion model to calculate the shares they would produce at conversion. Include them in your fully diluted share count using a shadow series approach — estimate the shares they'd convert into based on current assumptions.

Step 6: Verify Your Math

Every ownership percentage should sum to exactly 100% on a fully diluted basis. Cross-check total issued shares against your share ledger or state filing records. Errors here compound badly when you add new rounds.

Common Mistakes to Avoid

Even with a strong template cap table, founders routinely make the same errors:

• Ignoring the option pool until it's too late — investors will demand an option pool top-up before investing, which dilutes founders, not investors
• Failing to update after every issuance — every new grant, exercise, or conversion should be logged immediately
• Mixing pre-money and post-money calculations — be explicit about which basis you're using in any investor communication
• Not accounting for anti-dilution provisions — weighted average anti-dilution on preferred stock adjusts conversion ratios in down rounds, which must be reflected in the cap table

When to Move Beyond Excel

A cap table Excel template is appropriate for companies with fewer than 20–30 stakeholders and no more than two or three financing rounds. Beyond that, the complexity and legal risk of managing equity in a spreadsheet typically outweigh the cost of dedicated software.

Platforms like Carta, Pulley, and Capshare start at roughly $500–$2,000 per year for early-stage companies and offer legally defensible electronic records, automated 409A valuations, and direct integration with law firms and transfer agents.

Key Takeaways

• A cap table tracks all securities on a fully diluted basis — always include options, warrants, and unconverted instruments
• Look for templates that include round modeling, a waterfall analysis tab, and an option pool tracker
• Populate your template starting from incorporation documents, not from memory
• Keep it updated after every issuance — a stale cap table is nearly as dangerous as no cap table
• Plan to migrate to dedicated software by the time you raise a Series A or exceed 25 stakeholders

The right template gets you moving. The discipline to maintain it accurately is what keeps your company out of trouble.