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 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:
[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:
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 in the app. For the general version of this, see how to automate an internal process with Claude.
Frequently asked questions
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.