Case logic

Excel to web app: when your spreadsheet should become software

Most small businesses run on a spreadsheet at some point. The question isn't whether Excel is bad. It's when the spreadsheet started costing you more than it saves.

Diagram: a spreadsheet with copies and versions on one side, a single web app on the other

Five signs your spreadsheet should be a web app

  1. There are copies. "Quotes_final_v3_REAL.xlsx" on two laptops and one in email.
  2. A wrong formula has cost you money. A discount applied twice, an area calculated in the wrong units.
  3. One person understands it. When they're on vacation, quotes wait.
  4. You can't find last month's work. Searching means opening files one by one.
  5. Prices change and nobody is sure every sheet got the update.

If two of those sound familiar, the spreadsheet has become a system. It just doesn't behave like one.

A real case: quoting for an installation company

Mallas Trujillo installs safety nets. Before, each quote was done by hand: measure on site, calculate the area, apply the right discount, build the document. Each quote was effectively its own spreadsheet, and arithmetic mistakes meant either losing money or an annoyed customer.

I built them a quoting tool that turns that process into a form and a printable quote. Three decisions mattered most:

  • Prices live in a table the owner edits, not in code. The price per square meter and three area-based discount tiers change without calling a developer.
  • The server recalculates everything on save. The form shows live totals, but the saved quote is computed again from the stored items, in one transaction. A tampered or stale screen can't produce a wrong quote.
  • History is searchable by name and phone, and any past quote can be reused as a template.

The quote prints to PDF straight from the browser, with no extra library to maintain.

What changes when Excel becomes a web app

  • There is one version. Everyone opens the same thing, from a phone or a laptop.
  • The rules are enforced. Nobody can type over a formula.
  • Every record has a date and an author.
  • Access is per person, and can be removed when someone leaves.

How the move happens, step by step

  1. Map the spreadsheet. Every column, every formula, every rule that lives in someone's head ("we never discount below 20 square meters").
  2. Write the rules down and agree on them before any code. This step alone often fixes two or three mistakes the sheet had for years.
  3. Import the existing data, so the history isn't lost.
  4. Run both in parallel for a week or two. Same quote in the sheet and in the app; if the numbers differ, one of them is wrong and now you know which.
  5. Retire the spreadsheet for data entry, and keep it for analysis if you like.

What to keep in Excel

Analysis. Excel is excellent for looking at numbers, trying scenarios and building a report for yourself. The web app should export to Excel, not replace it for everything. Moving the data entry and the rules out of the spreadsheet is usually enough.

What it costs

A focused web app like a quoting tool or an order tracker starts at $1,200 with me, at a fixed price agreed before starting. What moves the price is the number of screens and rules, not the hours.

The honest part: if your spreadsheet has one user and no copies, you probably don't need this yet. Lock the formula cells, keep one shared file and revisit when one of the five signs shows up.

FAQ

When should I replace Excel with a web app?

When several people edit copies, when a wrong formula has cost you money, or when only one person understands the file.

How much does it cost to turn a spreadsheet into a web app?

A focused tool like a quoting system or order tracker starts at $1,200 with me, at a fixed price agreed before starting.

Will I lose my data when moving from Excel?

No. Existing rows are imported, and the app can export back to Excel for analysis.

Can a web app work on a phone?

Yes. That's one of the main reasons to move: the same tool from the site visit, the office or home.

Should I use a no-code tool instead?

Sometimes. If your rules are simple and you're happy paying per user each month, a no-code tool can be enough. Custom makes sense when the rules are yours.

What now?

If this was useful, let's talk.

Web apps and internal tools start at $1,200, at a fixed price. I look at your spreadsheet first and tell you if it really needs to become software.

Message me on WhatsApp → See contact options