How to move your company from spreadsheets to a custom system

When spreadsheets stop coping

Spreadsheets are a great start: fast, free, everything is visible. Problems creep in quietly, usually when there are more than three or four employees or more than a dozen requests a day.

Signs it is time to move:

• The same data is entered into several spreadsheets — and drifts apart.
• The status of a request can only be learned by asking the person in charge.
• A spreadsheet gets deleted or overwritten by accident — and the history is gone.
• A monthly report takes half a day to assemble manually.
• A new employee spends weeks figuring out «where things live».

What a custom system gives you

A system differs from spreadsheets not by pretty buttons but by rules: data is entered once, statuses change explicitly, and everything that happened stays in the history.

What appears after the move:

• One entry point: requests, clients, contracts and payments are linked together.
• Roles and rights: everyone sees and edits only their own scope.
• Statuses and a journal: who changed what and when is always visible.
• Reports in minutes, not half a day — with Excel export still available.
• Search: any record is found in seconds.
• Reminders and notifications: the system itself flags overdue items.

The migration in five steps

The first step is an audit. All spreadsheets are listed and two questions are answered: what is actually used and what is duplicated. It usually turns out that only a third of the tables are active — good news: there is less to move.

The second step is structure and prototype. Sections, roles and statuses are designed, and screens are shown on examples from the real spreadsheets. This is also where you decide what stays in Excel: sometimes part of the reporting is more convenient the old way — and that is fine.

The third step is building the first stage. Start with the most-used section, usually requests or contracts, not everything at once. The fourth is data migration: spreadsheets are deduplicated and imported. The fifth is launch: the staff is trained, the old spreadsheets are switched to read-only and archived a month or two later.

Work does not stop: a new section goes live when it is ready, and the old tables are closed one by one.

What the migration costs

The first stage starts from ₽70,000: audit, structure, prototype and one working section with data migration. The price and deadline are fixed before work starts. Later stages are separate blocks: reports, reminders, integrations with the website and telephony.

The final budget depends on the number of sections and roles, data cleanliness, reports and document printing, integrations and the number of workstations. Clean source spreadsheets save a noticeable part of the migration stage.

Four mistakes when migrating

Almost every failed migration is not a technical problem but a planning one:

• Moving everything at once: starting with the full scope stretches the project for months. Stages work.
• Breaking the familiar process: the system should mirror the convenient workflows, not retrain people for its own sake.
• Skipping data cleanup: duplicates and stale rows migrate into the new system and spoil the statistics.
• Launching without training: two hours of training save a month of questions to the developer's messenger.