How to migrate your cap table from spreadsheets to software

If you are reading this, your spreadsheet probably still works, but it has started to feel fragile: a tab per round, formulas no one wants to touch, and a growing gap between what the sheet says and what the signed paperwork says. Moving to dedicated software fixes that, but the migration itself is where mistakes get baked in if you rush it. This guide walks through the migration as an ordered workflow, framed for a German GmbH, so the version you go live with is one you can trust at your next round.

When is it time to move your cap table off spreadsheets?

A spreadsheet is a perfectly good cap table for a founding team with a handful of shareholders and no incentive plan. The case to move is about complexity and risk, not company size for its own sake.

The usual triggers are a first or second financing round, the launch of an employee incentive plan (a VSOP, ESOP, or § 19a-qualifying EIP), and the point at which more than one person needs to read or change the cap table. Each of these multiplies the number of instruments that have to reconcile: convertibles and SAFEs that convert at different valuations, option grants vesting on different schedules, and a fully-diluted picture that a single spreadsheet error can quietly distort. The cost of an error also rises: a mistake that was invisible at seed becomes a diligence finding at Series A, one of the 10 legal hurdles after Series A that catch growing companies.

What makes a spreadsheet migration risky if you rush it?

The risk is not moving the numbers; any platform can ingest a spreadsheet. The risk is migrating an inaccuracy you did not know you had.

For a German company there is a specific nuance worth understanding before you start. The notarized Gesellschafterliste filed at the commercial register is the authoritative record of who legally holds shares, and share transfers update it through a notary. So unlike the US or UK framing, your problem is rarely "we don't know who owns what" at the legal level. The real gap a spreadsheet leaves is the fully-diluted picture: combining the registered share ownership with all the outstanding instruments that have not yet converted into shares (the option pool, granted but unvested options, convertibles, and SAFEs), plus the version control and audit trail around it. A migration that copies the spreadsheet's fully-diluted view without checking it against the underlying documents simply moves any error into a more authoritative-looking system. The whole point of the steps below is to catch that before go-live.

How to migrate your cap table, step by step

Before you call the migration done, run a short validation pass. Confirm the registered ownership in the platform matches the Gesellschafterliste exactly. Confirm the fully-diluted totals reconcile to your cleaned source file. Spot-check a few employee grants end to end, from grant date through vesting to the current vested amount. Confirm convertibles and SAFEs carry the correct conversion terms. Confirm access permissions are set so the right people can see and edit, and no one else. Only when all of these tie out should the spreadsheet become an archive rather than a live document.

If your move is not from spreadsheets but from another platform, the data-quality logic is the same but the source record differs.