# How to replace a spreadsheet with an app Claude builds

When a shared spreadsheet has become the team's tracker, Claude can turn it into an app: the columns become a Postgres table, the formulas become rules, the tabs become views, and only invited people get in. Steps for Claude chat and Claude Code.

Canonical URL: https://getfloo.com/blog/how-to-replace-a-spreadsheet-with-an-app-claude-builds

## TL;DR

**To replace a spreadsheet with an app, show Claude the columns and explain who edits what. Claude turns the columns into a Postgres table, the formulas into rules, and the tabs into views. floo runs it with invite-only sign-in, and a CSV export brings the old rows along.**

- Replace a sheet when several people edit the same rows and mistakes cost something.
- Columns become a table, dropdowns become fixed choices, formulas become code, tabs become filtered views.
- Run the app next to the sheet for a week, then retire the sheet.

Every company has one: the spreadsheet that started as a list and became the system. Five people edit it, nobody trusts the totals, and one tab is labeled "DO NOT TOUCH." That sheet is a spec for an app, and Claude can build it.

## 1. Decide if it should be an app

Replace the sheet when:

- **Several people edit the same rows.** And someone has overwritten someone else's work.
- **There are rules.** Only finance marks an invoice paid. A status can only move forward.
- **Someone copies data out every week.** For a report, an email, or another system.
- **It needs a history.** Who changed this, and when.

Keep the sheet when one person uses it, or when it is analysis that changes shape every week.

## 2. Show Claude the sheet

Give Claude the column headers, three or four example rows, and the rules nobody wrote down:

> This is our renewals tracker. Columns: customer, plan, renewal date, owner, status (open, contacted, renewed, lost), notes. Only the owner or a manager can change the status. I want a page with renewals due in the next 30 days, grouped by owner, and a weekly email to each owner with their list.

Claude maps it:

| In the sheet | In the app |
| --- | --- |
| Columns | A table in Postgres |
| Dropdowns | Fixed choices the form enforces |
| Formulas | Code that computes the value |
| Tabs and filters | Views, like "due in 30 days" |
| Shared edit link | Invite-only sign-in |
| "Someone sends the list Monday" | A scheduled job |

## 3. Build it

**In Claude chat:** connect [floo in Claude's directory](https://claude.ai/directory/connectors/floo) and paste your description. Claude creates the app with sign-in and a Postgres database, builds the pages, deploys, and sends the link.

**In Claude Code:** paste the description to build the app, then `Read https://getfloo.com/docs/introduction.md and deploy this app to floo.` Invite-only sign-in and the database are a few lines in `floo.app.toml`:

```toml floo.app.toml
[app]
name = "renewals"
access_mode = "accounts"

[managed.default]
type = "postgres"
```

## 4. Bring the rows over

Export the sheet as CSV. In Claude Code, ask Claude for an import script, then run it against the app's dev database from your machine:

```bash
floo run --service web -- node scripts/import-renewals.js renewals.csv
```

`floo run` gives the script the app's `DATABASE_URL` without putting the credentials in your shell history. In Claude chat, ask Claude to add an import page you can upload the CSV to.

## 5. Switch over

Run the app next to the sheet for a week. Check the totals match, then make the sheet read-only and link it to the app. Invite everyone who edited the sheet: "Invite the account managers," or `floo apps invite`.

The weekly email that used to be someone's Monday job is now a [cron job](https://getfloo.com/docs/guides/cron-jobs) in the app. For the general version of this, see [how to automate an internal process with Claude](https://getfloo.com/blog/how-to-automate-an-internal-process-with-claude).

## FAQ

### Can Claude turn a spreadsheet into an app?

Yes. Give Claude the column headers and a few example rows, and describe who edits what. Claude designs the table, the form, and the views. On floo the data lives in Postgres and only invited people can sign in.

### How do I move the existing rows into the app?

Export the sheet as CSV. In Claude Code, have Claude write an import script and run it against the app's database with floo run. In Claude chat, ask Claude to add an import page or a one-time import step.

### When should a spreadsheet stay a spreadsheet?

When one person uses it, the shape changes every week, or the work is analysis rather than a process. Replace it when several people edit the same rows, when it needs rules about who can change what, or when someone copies data out of it by hand every week.
