How to Migrate From a Spreadsheet to Cap Table Software

Migrating from a spreadsheet to cap table software means transferring your ownership data, equity grants, convertible instruments, and vesting schedules from Excel or Google Sheets into a dedicated platform that automates calculations, maintains an audit trail, and keeps your cap table investor-ready at all times.

Most startups begin with a spreadsheet — and that works fine for a two-founder company with one share class. But spreadsheets break down fast once you add option grants, SAFEs, multiple investors, and vesting schedules. This guide walks you through exactly how to migrate, what to watch out for, and how to avoid the most common mistakes.

When to Move Off Spreadsheets

There's no universal trigger, but if any of these apply, you've outgrown your spreadsheet:

• •You have more than 5 stakeholders. Once you add employees with option grants, advisors, and investors beyond the founders, a single sheet becomes unwieldy and error-prone.
• •You're about to raise a priced round. Investors will ask for a fully diluted cap table with SAFE conversion modeling. Spreadsheet formulas can't reliably handle multiple SAFEs converting at different caps.
• •You've issued stock options. Tracking vesting schedules, exercise windows, cliff dates, and 409A strike prices across dozens of grants in a spreadsheet is where most errors happen.
• •You need an audit trail. Spreadsheets have no version history that tracks who changed what. When a number changes and nobody knows why, you have a governance problem.
• •You're spending more than 30 minutes per month maintaining it. That time compounds. Cap table software eliminates the manual work entirely.

Step 1: Audit Your Current Spreadsheet

Before you migrate anything, clean up what you have. Garbage in, garbage out — migrating bad data into good software just gives you well-organized bad data.

Verify Founder Shares

• •Confirm total authorized shares match your Certificate of Incorporation
• •Check that founder share counts add up to the correct issued amount
• •Verify vesting start dates and cliff dates for each founder
• •Confirm 83(b) election filing dates if applicable

Verify Option Grants

For every option grant, confirm:

Verify Convertible Instruments

For each SAFE or convertible note:

• •Investment amount
• •Valuation cap
• •Discount rate (if any)
• •Pro rata rights or MFN clauses
• •Interest rate and maturity date (for convertible notes)
• •Whether it's pre-money or post-money (critical for post-money SAFEs)

Check the Math

Run these sanity checks:

1. Total issued shares = founder shares + exercised options + any other common stock issued
2. Total outstanding options = all granted options minus exercised minus cancelled/forfeited
3. Fully diluted shares = issued shares + outstanding options + shares reserved in the option pool + SAFE conversion shares (estimated)
4. Ownership percentages should sum to 100% on both an issued and fully diluted basis

If any of these don't add up, fix them before migrating. Document every discrepancy you find and how you resolved it.

Step 2: Gather Your Legal Documents

Your spreadsheet is a summary — the legal documents are the source of truth. Collect these before starting the migration:

• •Certificate of Incorporation (and any amendments or restated certificates) — confirms authorized shares, par value, and share classes
• •Stock purchase agreements — for each founder and early shareholder
• •Option grant agreements — individual agreements for every option holder
• •Equity incentive plan (EIP) — the board-approved plan document with the total share reserve
• •Board resolutions — approving each equity issuance, option pool creation, and 409A valuation
• •SAFE agreements — each SAFE with its specific terms
• •Convertible note agreements — including any amendments
• •409A valuation reports — every valuation you've obtained, with effective dates
• •83(b) election copies — filed copies for anyone who received restricted stock

If you can't find a document, that's a problem to fix now — not after migration. Missing documentation creates legal exposure during due diligence.

Step 3: Choose Your Cap Table Software

The right platform depends on your stage, budget, and complexity. Here's what to evaluate:

Must-Have Features

• •Automatic vesting calculations — the software should track every grant's vesting schedule and show vested vs. unvested shares in real time
• •SAFE and convertible note modeling — you should be able to model how instruments convert at different valuations
• •Fully diluted waterfall analysis — see ownership on both an issued and fully diluted basis
• •409A valuation integration — keep strike prices current without manual updates
• •Export and reporting — generate investor-ready cap tables, board reports, and due diligence packages
• •Audit trail — every change logged with who made it and when

Comparing Options

OpenCap Stack is open source, so your data is never locked in. You can export everything, inspect the code, and extend the platform however you need.

Step 4: Enter Your Data

Once you've audited your spreadsheet and gathered your documents, it's time to enter the data into your chosen platform. The order matters — dependencies flow downward:

Entry Order

1. Company details — name, incorporation date, state of incorporation, authorized shares
2. Share classes — common stock, and any preferred classes if you've done a priced round
3. Founders and stakeholders — add each person with their role (founder, employee, advisor, investor)
4. Founder share issuances — record each founder's shares with purchase date, price per share, and vesting terms
5. Equity incentive plan — enter the board-approved option pool with total reserved shares
6. Option grants — add each grant with grant date, shares, strike price, vesting schedule, and option type (ISO/NSO)
7. SAFEs and convertible notes — enter each instrument with its specific terms
8. Exercise history — record any options that have been exercised

Common Migration Mistakes

• •Entering fully diluted shares as issued shares. These are different numbers. Issued shares are what's actually been purchased or granted. Fully diluted includes all options and conversion estimates.
• •Using the wrong 409A valuation for a grant. Each option grant's strike price must match the 409A valuation that was in effect on the grant date — not today's valuation.
• •Forgetting cancelled or forfeited options. These go back into the option pool. If you don't record them, your available pool will be wrong.
• •Entering pre-money SAFEs as post-money (or vice versa). These convert differently. Pre-money SAFEs dilute existing shareholders including other SAFE holders. Post-money SAFEs have a fixed ownership percentage at conversion. Getting this wrong will produce wildly incorrect conversion modeling.
• •Skipping the vesting start date. If a founder started vesting 18 months ago, you need the original start date — not today's date. Otherwise the cliff calculation will be wrong.

Step 5: Validate the Migration

After entering all data, run these validation checks:

Cross-Reference With Your Spreadsheet

• •Total issued shares should match
• •Fully diluted share count should match (within rounding)
• •Each stakeholder's ownership percentage should match
• •Option pool available shares should match

Cross-Reference With Legal Documents

• •Each founder's share count matches their stock purchase agreement
• •Each option grant matches its grant agreement
• •Each SAFE matches its signed agreement
• •Authorized shares match the Certificate of Incorporation

Run a Test Scenario

Model a hypothetical funding round at a realistic valuation. Check that:

• •SAFEs convert at the correct share prices based on their caps
• •The option pool shows the correct number of available shares
• •The dilution waterfall produces reasonable ownership percentages
• •The fully diluted share count is internally consistent

If anything doesn't match, trace the discrepancy back to the source document and fix it before relying on the new system.

Step 6: Retire the Spreadsheet

Once validation is complete:

1. Archive the spreadsheet — don't delete it. Save a final copy with a date stamp. You may need it for historical reference.
2. Stop updating the spreadsheet. This is the hard part. If you maintain both systems, they will diverge, and you'll end up trusting neither.
3. Communicate the change. Let your co-founders, CFO, and legal counsel know that the cap table now lives in the new system. Share access credentials.
4. Set up regular reviews. Check your cap table quarterly — after every board meeting, equity grant, or financing event.

How OpenCap Stack Helps

OpenCap Stack makes migration straightforward:

• •Guided data entry — step-by-step flows for adding stakeholders, share classes, and equity grants
• •Automatic vesting tracking — enter the schedule once and the platform calculates vested shares daily
• •SAFE conversion modeling — see exactly what your cap table looks like at any valuation
• •Dilution calculator — model funding rounds before they happen
• •Full data portability — export your entire cap table anytime, in standard formats
• •MCP integration — manage your cap table through AI agents in Claude Code or Cursor

Start migrating for free at opencapstack.com/register.

FAQ

How long does it take to migrate from a spreadsheet to cap table software?

For a typical seed-stage startup with 2-3 founders, an option pool, and a few SAFEs, the migration takes 2-4 hours. Most of that time is spent auditing your existing spreadsheet and gathering legal documents — the actual data entry is fast.

Will I lose any data during migration?

No, if you follow the validation steps. The key is cross-referencing every number against both your spreadsheet and your legal documents before retiring the spreadsheet. Keep the original spreadsheet archived as a backup.

Can I migrate if my spreadsheet has errors?

You should fix the errors first. Migrating incorrect data into cap table software doesn't fix the underlying problems — it just makes them harder to find. Use the audit checklist in Step 1 to identify and resolve discrepancies before you start.

Do I need a lawyer to help with the migration?

Not for the migration itself, but if you discover discrepancies between your spreadsheet and your legal documents — like option grants that were never board-approved, or shares that don't match purchase agreements — you should involve legal counsel to resolve those issues.

What if I have multiple spreadsheets tracking different things?

This is common — one sheet for the cap table, another for vesting schedules, a third for SAFEs. Consolidate them into a single source of truth during the audit phase. Cap table software replaces all of these with one integrated system.

Is it worth migrating if I only have 2 founders and no employees yet?

If you're about to hire your first employee or raise your first round, yes. Setting up cap table software now — while the data is simple — is much easier than migrating after you have 20 option grants and 5 SAFEs. The cost of starting early is nearly zero; the cost of migrating late is hours of cleanup.