Migrating a cap table from spreadsheets to software is mostly a data-quality exercise, not a technical one. The work that actually protects you happens before the import: reconcile your spreadsheet against the official record (for a German GmbH, the notarized Gesellschafterliste and the signed agreements behind it), gather every document that affects ownership, and clean the data into a consistent structure. Then choose a platform that fits your frame, import, and reconcile the totals on both the legal and the fully-diluted view before you retire the spreadsheet. Done in that order, a migration is a structured handover that usually takes days, not weeks.
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.
FAQ
How long does it take to migrate a cap table from spreadsheets to software?
For a typical early-stage German company, the move itself is usually a matter of days once the data is clean, and many providers run the import and reconciliation with you as part of onboarding. The variable is preparation: a spreadsheet that already reconciles to the Gesellschafterliste migrates quickly, while one with unresolved discrepancies takes longer because those have to be fixed first.
What is the most common mistake when migrating a cap table?
Importing an inaccuracy you did not know you had. Spreadsheets drift from the signed documents and the register over time, so copying the sheet into a new system can move an error into a more authoritative-looking place. Reconciling against the Gesellschafterliste and the underlying agreements before importing is what prevents it.
Do I need to involve a notary to move my cap table to software?
No. The software records and manages the cap table; it does not change legal ownership, so moving to a platform does not itself require notarization. A notary is involved when shares actually transfer, which updates the Gesellschafterliste, and the platform should reflect that record rather than replace it.
Can I migrate employee option grants as well as shares?
Yes, and this is often the main reason to move, because grants with vesting schedules, cliffs, and leaver terms are where spreadsheets are hardest to keep accurate. Load each grant with its full terms and confirm the vesting math, and if the plan is meant to qualify for §19a, confirm the structure is documented correctly during the migration rather than later.
Should I keep the spreadsheet after migrating?
Keep it as a frozen archive for historical reference, but stop editing it once you go live. Running an active spreadsheet alongside the platform is how the two versions start to diverge again, which is the problem you migrated to solve.
