work / internal app / spreadsheet-to-database migration

Fragile spreadsheets, moved into a real database.

Key business tools lived in Google Sheets and AppSheet. I moved them into a Postgres database behind the staff portal, with proper access control.

role
Developer
client
US multi-entity services group
status
Done (~5 tools)

Languages

SQLTypeScript

Tools & platforms

PostgreSQLSupabaseDatabase migrationsGoogle SheetsAppSheet

AI & LLM

to build it
ClaudeChatGPTPerplexity

Skills

Data modelingData migrationAccess controlData cleaning
01// how I approached it

The thinking behind it

  1. 01 · What I noticed

    The tools worked, but the foundation didn't: shared sheets break when anyone edits them.

  2. 02 · What I decided

    Move one tool at a time into real database tables with access by role, without stopping daily work.

  3. 03 · What I delivered

    About five tools moved onto a database that holds up.

02// old vs new

Old system vs new system

Old systempeople as the glue
  1. Edit a shared sheet
  2. A formula breaks
  3. Find who changed it
  4. Fix it by hand
New systemthe system does the work
  1. Data in real tables
  2. Access by role
  3. Changes logged
  4. Tools rebuilt as modules
03// how it works

Watch it run

Click through the four steps. In step 3, click any box to see what it does.

synthetic data · no client screens
Reconstruction with synthetic data · no client screens
04// the hard part

Moving the foundation while people still stand on it.

The spreadsheet tools were in daily use, so they could not simply be switched off. Each tool was mapped to real tables and moved one at a time, with access by role from day one.

05// key decisions

Why it's built this way

decision 1

One tool at a time

Each move is small enough to check and roll back.

Trade-off: a longer overall migration.
decision 2

Access rules from day one

Every table protected by role, not by who has the link.

Trade-off: more setup per table.
decision 3

Rebuild as portal modules

Migrated tools land inside the staff platform, not as new islands.

Trade-off: tied to the platform's structure.
06// lessons

What made it work

  1. 01

    Map before you move

    Understanding the old sheet saves weeks of surprises.

  2. 02

    Small moves beat big launches

    One tool at a time keeps daily work running.

  3. 03

    Permissions are part of the data

    Moving data without access rules just moves the risk.