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

Cap Table Template Excel Download

Having a well-structured cap table template excel download 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 Cap Table Template Excel Download 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 Cap Table Template Excel Download?

A cap table template excel download 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-CAP-TABL

Cap Table Template Excel Download

This system provides a structured framework for tracking equity distribution, share classes, and dilution across funding rounds. It is designed for founders and CFOs to maintain accurate records for investor reporting and legal compliance.

Update Cadence: Update immediately upon any issuance, transfer, or conversion of shares.

Current Equity Distribution

Shareholder NameShare ClassShares Held% OwnershipGrant DateVesting Status
[Legal Name]Common500,00050.00%2023-01-01Fully Vested
[Legal Name]Common250,00025.00%2023-01-014-Year Vest
[Legal Name]Preferred150,00015.00%2023-06-15N/A
[Legal Name]Option Pool100,00010.00%2023-07-01Unallocated

Column Definitions

  • Shareholder Name: [Text] The legal name of the individual or entity.
  • Share Class: [Dropdown] Select from Common, Preferred, or Option Pool.
  • Shares Held: [Number] Total quantity of shares currently owned.
  • % Ownership: [Percentage] Calculated field based on total outstanding shares.
  • Grant Date: [Date] The date the equity was issued or authorized.
  • Vesting Status: [Text] Current status of vesting schedule (e.g., Fully Vested, 4-Year Vest, Cliff).

Essential Formulas

Calculate Total Shares Outstanding:

=SUM(C2:C5)

Calculate Individual Ownership Percentage (Place in D2):

=C2/SUM($C$2:$C$5)

Calculate Total Option Pool Remaining:

=SUMIF(B2:B5, "Option Pool", C2:C5) - [Total Granted Options]

Data Validation and Formatting

  1. Dropdown Menu: Select the "Share Class" column, go to Data Validation, and set criteria to "List" with the input: Common, Preferred, Option Pool.
  2. Ownership Alert: Apply conditional formatting to the "% Ownership" column. Set a rule: If cell value > 0.50, highlight in light red to flag potential control issues.
  3. Date Formatting: Ensure the "Grant Date" column is set to Date format YYYY-MM-DD to maintain consistency across fiscal reporting periods.

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 calculate the remaining available options in my pool after issuing grants? A: Use the provided SUMIF formula in your spreadsheet. You will need to subtract your total granted options from the total quantity listed under the "Option Pool" share class. By keeping this formula active, the template will automatically update your remaining unallocated pool balance whenever you add new rows or adjust share counts for employees or contractors.

Q: Why does the "% Ownership" column highlight in red for certain shareholders? A: This is an automated conditional formatting rule designed to flag potential control issues. If any individual shareholder exceeds 50% ownership, the cell will turn light red. This serves as a visual safeguard for founders and CFOs to quickly identify concentrated equity stakes that might require specific governance considerations or complicate future investor negotiations during funding rounds.

Q: Should I include unvested shares in the "Shares Held" column? A: Yes, you should include the total quantity of shares currently held or authorized for that shareholder, regardless of their current vesting status. Use the "Vesting Status" column to document the specific terms, such as "4-Year Vest" or "Cliff." This ensures your "Shares Held" column remains an accurate representation of your company's total issued equity while providing clear context for legal and reporting requirements.

© 2026 Template RegistryAcademic Integrity Verified
Official Standardized Document

Download this Template

View all