Free Cap Table Template for Excel and Google Sheets (2026 Download)

Every startup begins with a simple question: who owns what? Whether you are splitting equity between co-founders in a garage or closing your first priced round, a capitalization table is the single most important financial document your company will maintain. The good news is that you do not need expensive software to get started. A well-structured cap table template in Excel or Google Sheets can carry you through your earliest stages.

This guide walks you through exactly what your cap table spreadsheet should include, how to set one up from scratch, and when it makes sense to graduate to purpose-built tools.

What Is a Cap Table and Why Does It Matter?

A capitalization table — cap table for short — is a ledger that records every equity stake in your company. It lists every shareholder, the type and number of shares they hold, and what percentage of the company each stake represents on both an issued and fully diluted basis.

Cap tables matter for three reasons:

Getting this right early saves you thousands of dollars in legal cleanup later.

What a Startup Cap Table Template Should Include

A comprehensive cap table template needs to capture more than just names and share counts. Here are the essential components.

Founders and Common Shareholders

Every cap table starts with the founders. Record each founder's name, the number of common shares issued, the price per share (typically the par value at incorporation, often $0.0001), and the vesting schedule attached to each grant. Most startups use a four-year vesting schedule with a one-year cliff.

Share Classes

Startups typically have at least two share classes: Common Stock and Preferred Stock. Common shares go to founders and employees. Preferred shares go to investors in priced rounds and carry special rights like liquidation preferences and anti-dilution protection. Your template should track each class separately because they have different economic terms.

Option Pool (ESOP)

The employee stock option pool is a block of authorized but unissued shares reserved for future hires. Most seed-stage companies set aside 10 to 20 percent of their fully diluted shares for the option pool. Your template should show the total pool size, shares granted, shares exercised, and the remaining available pool.

Convertible Notes and SAFEs

Before a priced round, many startups raise capital through convertible notes or Simple Agreements for Future Equity (SAFEs). These instruments do not represent shares yet — they convert into equity at a future qualifying event. Your cap table template should have a separate section that tracks each note or SAFE, its principal amount, valuation cap, discount rate, and conversion terms. When modeling ownership on a fully diluted basis, you will need to estimate the shares these instruments will convert into.

Warrants

Some investors or lenders receive warrants — the right to purchase shares at a set price in the future. Track the holder, number of warrant shares, exercise price, and expiration date.

Cap Table Template: Column Structure

Below is the recommended column layout for a startup cap table spreadsheet. This structure works in both Excel and Google Sheets.

Shareholder Summary Table

| Shareholder | Type | Share Class | Shares Issued | Price/Share | Investment ($) | Ownership (%) | Fully Diluted (%) |

|---|---|---|---|---|---|---|---|

| Alice Chen | Founder | Common | 4,000,000 | $0.0001 | $400 | 40.00% | 33.33% |

| Bob Martinez | Founder | Common | 4,000,000 | $0.0001 | $400 | 40.00% | 33.33% |

| Seed Fund I | Investor | Series Seed Preferred | 2,000,000 | $0.50 | $1,000,000 | 20.00% | 16.67% |

| Option Pool | ESOP | Common (Reserved) | 2,000,000 | — | — | — | 16.67% |

| Total | | | 12,000,000 | | $1,000,800 | 100.00% | 100.00% |

SAFE and Convertible Note Tracker

| Investor | Instrument | Amount ($) | Valuation Cap ($) | Discount (%) | Date | Status |

|---|---|---|---|---|---|---|

| Angel Group A | SAFE (Post-Money) | $250,000 | $5,000,000 | — | 2026-01-15 | Unconverted |

| Jane Doe | Convertible Note | $100,000 | $6,000,000 | 20% | 2025-11-01 | Unconverted |

Option Grant Ledger

| Employee | Grant Date | Shares Granted | Exercise Price | Vesting Start | Cliff Date | Shares Vested | Shares Exercised |

|---|---|---|---|---|---|---|---|

| Carlos Rivera | 2026-03-01 | 100,000 | $0.10 | 2026-03-01 | 2027-03-01 | 0 | 0 |

| Diana Park | 2026-04-15 | 75,000 | $0.10 | 2026-04-15 | 2027-04-15 | 0 | 0 |

How to Set Up a Cap Table in Excel: Step by Step

Step 1: Create the Shareholder Sheet

Open a new workbook. Name the first sheet "Cap Table." In Row 1, add the column headers from the Shareholder Summary Table above: Shareholder, Type, Share Class, Shares Issued, Price/Share, Investment, Ownership (%), and Fully Diluted (%).

Enter your founders first. If you incorporated in Delaware through a standard formation, you likely authorized 10,000,000 shares of Common Stock at $0.0001 par value. Split the issued shares according to your founders' agreement.

Step 2: Add the Ownership Formula

Ownership percentage on an issued basis is straightforward. In the Ownership (%) column, use this formula:

= Shares Issued / SUM(all Shares Issued excluding the option pool)

For cell G2, assuming shares are in column D and your data runs from rows 2 through 5:

=D2/SUMIF(B2:B5,"<>ESOP",D2:D5)

Step 3: Calculate Fully Diluted Ownership

Fully diluted ownership includes all issued shares plus the option pool and any shares that convertible instruments would create upon conversion. The formula for the Fully Diluted (%) column:

=D2/SUM($D$2:$D$5)

This divides each holder's shares by the total of all shares including the reserved option pool.

Step 4: Add the SAFE and Convertible Note Tracker

Create a second sheet named "Convertibles." Add columns for Investor, Instrument Type, Amount, Valuation Cap, Discount, Date, and Status. This sheet is a reference tracker — it does not feed into ownership calculations until conversion happens.

To estimate post-conversion dilution, add a helper column that calculates the number of shares each instrument would convert into:

=Amount / (Valuation Cap / Pre-Money Fully Diluted Shares)

This gives you the conversion share count at the cap. Compare this against conversion at the discount to determine which is more favorable to the investor (they typically get the better deal).

Step 5: Build the Option Grant Ledger

Create a third sheet named "Options." Track each individual grant with the columns shown in the Option Grant Ledger table above. Add a formula to calculate vested shares based on time elapsed:

=IF(TODAY()<Cliff Date, 0, MIN(Shares Granted, FLOOR((TODAY()-Vesting Start)/365.25*Shares Granted/4, 1)))

This formula returns zero before the cliff, then calculates monthly vesting over a four-year schedule.

Step 6: Add a Summary Dashboard

Create a final sheet named "Summary" that pulls totals from each sheet. Include:

Use SUMIF and SUMPRODUCT formulas to aggregate data across sheets.

Common Mistakes in Spreadsheet Cap Tables

Even a well-designed template can lead you astray. Watch out for these frequent errors:

Confusing authorized vs. issued shares. Your certificate of incorporation authorizes a maximum number of shares. Issued shares are the subset actually granted to shareholders. These are different numbers and mixing them up inflates or deflates ownership percentages.

Forgetting to model SAFE conversion. SAFEs are not free money — they will dilute existing shareholders when they convert. Many founders are shocked at their post-conversion ownership because they never modeled the math.

Ignoring vesting. A founder who has been vesting for six months does not own the same stake as one who is fully vested. Track vested vs. unvested shares separately, especially for departure scenarios.

Using outdated share counts. If multiple people edit the spreadsheet without version discipline, you end up with conflicting numbers. This is one of the most dangerous failure modes of spreadsheet-based cap tables.

When to Move Beyond Spreadsheets

A cap table template in Excel or Google Sheets works well for a two-founder company with a single SAFE and a small option pool. But spreadsheets have real limitations that compound as your company grows.

No audit trail. Spreadsheets do not automatically log who changed what and when. If a cell gets overwritten, the previous value is gone. During due diligence, investors and their lawyers want to see a complete history of every equity transaction.

Version control nightmares. When your lawyer, CFO, and co-founder each have their own copy of the cap table, reconciling differences becomes a recurring headache. Google Sheets helps with simultaneous editing, but it does not solve the problem of competing assumptions in different scenario models.

Scenario modeling is manual and error-prone. What happens to everyone's ownership if you raise a $3M Series A at a $15M pre-money valuation? What if it is $12M instead? In a spreadsheet, you have to manually build each scenario, and a single broken formula can cascade errors through the entire model.

Compliance gaps. 409A valuations, 83(b) election tracking, and securities law compliance require structured data that spreadsheets were never designed to enforce. As your cap table grows beyond a handful of stakeholders, the risk of a compliance error increases.

Scale. Once you have more than 15 to 20 stakeholders, multiple share classes, and several rounds of financing, a spreadsheet becomes unwieldy. Formulas break, tabs proliferate, and the cognitive load of maintaining accuracy becomes a real cost.

If you are hitting these walls, it is worth looking at dedicated cap table management tools. Open-source platforms like OpenCap Stack give you the structure of enterprise equity management — audit trails, scenario modeling, SAFE conversion tracking, and OCTA-compliant data schemas — without the per-seat licensing fees of commercial alternatives. It is a natural upgrade path from spreadsheets, and because it is open source, you retain full control over your data.

Best Practices for Maintaining Your Cap Table

Regardless of whether you use a spreadsheet or dedicated software, these habits will keep your cap table reliable:

Frequently Asked Questions

What is the difference between a cap table and a stock ledger?

A cap table is a summary view showing current ownership percentages and share counts. A stock ledger is a detailed legal record of every share issuance, transfer, cancellation, and exercise. Think of the cap table as the dashboard and the stock ledger as the underlying transaction log. Both are important, but investors typically ask for the cap table first.

Should I use Excel or Google Sheets for my cap table?

Google Sheets is generally better for early-stage startups because it supports real-time collaboration and automatic saving. Excel is more powerful for complex financial modeling with large datasets. Either works — the important thing is to pick one and maintain it consistently. Avoid keeping copies in both formats, as they will inevitably drift apart.

How often should I update my cap table?

Update it after every equity event: new share issuances, option grants, SAFE conversions, share transfers, or cancellations. At minimum, review it quarterly. If you are in active fundraising or hiring, you may need to update it weekly.

What is fully diluted ownership and why does it matter?

Fully diluted ownership shows each stakeholder's percentage assuming all convertible instruments (options, warrants, SAFEs, convertible notes) have converted into shares. This is the number investors care about because it reflects the true economic picture. Issued-only ownership can be misleading because it ignores the dilutive effect of outstanding instruments.

When should I stop using a spreadsheet for my cap table?

Consider moving to dedicated software when any of these conditions apply: you have more than 15 equity holders, you have completed more than one priced round, you need to run scenario models for fundraising, you are preparing for a 409A valuation, or your lawyers have flagged discrepancies in your records. The cost of getting it wrong — in legal fees, investor trust, or compliance penalties — far exceeds the cost of a proper tool.

---

Managing a cap table does not have to be complicated, but it does have to be accurate. Start with a template, follow the structure outlined above, and upgrade your tooling as your company grows.