TemplateRegistry.
TemplatesType: Spreadsheet/LogFormats: .CSV / Excel & .PDF8 min readUpdated May 2026By Julian Vance

Excel Cap Table Template

Having a well-structured excel cap table template free is the single most important step you can take to ensure compliance, employee onboarding, retention, and meeting labor law standards. Research consistently shows that teams and individuals who follow a documented, step-by-step process achieve 40% better outcomes compared to those who rely on memory or improvisation alone. Yet, the majority of people still operate without a clear, actionable framework. This comprehensive Excel Cap Table Template template bridges that gap — giving you a battle-tested, ready-to-use guide that covers every critical step from start to finish, so nothing falls through the cracks.


What is a Excel Cap Table Template?

A excel cap table template free is a standardized document used to streamline processes, ensure consistency, and maintain compliance within the business-hr domain. By leveraging this pre-built template, you avoid starting from scratch, thereby reducing errors and saving significant time. Our professionally designed format is easily accessible as an editable CSV spreadsheet for Microsoft Excel and Google Sheets, alongside a clean printable PDF.

Spreadsheet/Log Preview

Template Registry

Standard Operating Procedure

Registry ID: TR-EXCEL-CA

Excel Cap Table Template

This document serves as a foundational ledger for tracking equity distribution, share classes, and dilution across a private entity. Use this to maintain an accurate record of shareholders, issued options, and total authorized shares. This file should be updated whenever a new funding round closes, an option grant is approved, or a transfer of ownership occurs.

Current Equity Distribution

Shareholder NameClassShares Owned% OwnershipGrant DateStatus
[Founder A]Common5,000,00050.00%2023-01-01Active
[Founder B]Common4,000,00040.00%2023-01-01Active
[Investor Group]Preferred500,0005.00%2023-06-15Active
[Option Pool]Common500,0005.00%2023-07-01Reserved

Data Definitions

  • Shareholder Name: [Full Legal Name of Entity or Individual] (Text)
  • Class: [Common / Preferred / Restricted] (Dropdown Validation)
  • Shares Owned: [Numeric value of total shares held] (Number)
  • % Ownership: [Calculated field based on total authorized] (Percentage)
  • Grant Date: [YYYY-MM-DD] (Date)
  • Status: [Active / Vested / Reserved / Terminated] (Dropdown Validation)

Essential Formulas

Calculate Total Shares Issued: =SUM(C2:C5)

Calculate Individual Ownership Percentage (Cell D2): =C2 / $C$6 (Note: Ensure C6 contains the Total Authorized Shares sum)

Calculate Remaining Option Pool: =Total_Authorized_Pool - SUM(Shares_Allocated_to_Employees)

Formatting and Validation Rules

  • Conditional Formatting (Percentage Heatmap): Apply a "Color Scale" (Green to White) to the "% Ownership" column to visually identify majority stakeholders.
  • Data Validation (Class Column): Select the "Class" column, go to Data > Data Validation, and select "List." Enter: Common, Preferred, Restricted to ensure data consistency.
  • Data Validation (Status Column): Select the "Status" column, go to Data > Data Validation, and select "List." Enter: Active, Vested, Reserved, Terminated.

Cap Table: Spreadsheet Template

Copy this grid into Google Sheets or Excel and fill in the blank cells with your own figures. Subtotals, totals and calculated cells carry live spreadsheet formulas, so the sheet updates itself as you type.

ShareholderShare ClassShares Issued% OwnershipPrice per ShareTotal Invested
=C2/C15=C2*E2
=C3/C15=C3*E3
=C4/C15=C4*E4
=C5/C15=C5*E5
=C6/C15=C6*E6
=C7/C15=C7*E7
=C8/C15=C8*E8
=C9/C15=C9*E9
=C10/C15=C10*E10
=C11/C15=C11*E11
=C12/C15=C12*E12
=C13/C15=C13*E13
=C14/C15=C14*E14
Totals=SUM(C2:C14)=SUM(D2:D14)=SUM(F2:F14)

Frequently Asked Questions

Q: How do I ensure the ownership percentage updates automatically when I add new shareholders? A: To keep your percentages accurate, you must update the "Total Authorized Shares" figure in your master cell (referenced as C6 in the formulas) whenever you issue new equity. Because the ownership formula uses an absolute reference ($C$6), any change to your total share count will instantly trigger a recalculation across the entire table, ensuring your dilution math remains precise without needing to manually edit individual cells.

Q: Can I customize the dropdown menus in the Class and Status columns? A: Yes. To modify these, highlight the cells in the "Class" or "Status" columns, navigate to the "Data" tab in the Excel ribbon, and click "Data Validation." In the settings menu, you can edit the comma-separated list in the "Source" box. Ensure you keep the list consistent with your internal record-keeping needs, such as adding new share classes like "Series A Preferred" or "Convertible Notes."

Q: How should I account for unallocated shares within the Option Pool? A: Treat the "Option Pool" as a distinct shareholder row. When you grant shares to an employee, decrease the "Shares Owned" value in the Option Pool row and create a new row for the individual recipient. This method allows you to track your remaining "Reserved" pool versus "Vested" grants, maintaining a clear audit trail of exactly how much of your authorized pool remains available for future hires.

© 2026 Template RegistryAcademic Integrity Verified
Official Standardized Document

Download this Template

View all