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

# 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: 1. **Fundraising clarity.** Investors will ask for your cap table before writing a check. A messy or inaccurate table signals operational risk. 2. **Legal compliance.** Equity grants, 409A valuations, and tax filings all depend on accurate ownership records. 3. **Decision-making.** Founders need to understand dilution before issuing new shares, creating an option pool, or converting a SAFE. 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()

Check your site's AX Score

Free scan, 6 categories, under 60 seconds. See how your site ranks on the agentic web.

Run a free audit →