Custom Internal Tools Development vs Off-the-Shelf (Retool, Airtable, Spreadsheets): Which Should You Choose?
Buy off-the-shelf first. For most internal tools a spreadsheet, Airtable, or Retool covers the job for $0 to $30k/year and ships in days. Build custom only when the tool sits on your core workflow, needs deep integration or permissions logic the platform can't model, or when platform seat and usage fees at your scale cross roughly $40k to $80k/yearthe point where a one-time $60k to $150k custom build starts paying back within 18 to 24 months.
What is the honest default: buy, then build only where it hurts?
The mistake we watch teams make is treating this as a single decision for the whole company. It isn't. Each internal tool is its own build-vs-buy call, and the right portfolio is mixed. You run your ops dashboard on Retool, your content calendar in Airtable, your quick ad-hoc analysis in a spreadsheet, and you build exactly one or two custom tools where the workflow is genuinely yours and the volume is real.
Off-the-shelf wins on speed and cost at the start. Custom wins on fit, control, and cost at scale. The framework below tells you which side of that line any given tool sits on before you spend anything.
When is off-the-shelf genuinely the right call?
Reach for a spreadsheet, Airtable, or Retool when the tool is a supporting workflow, not the thing your business runs on. Signs you should buy:
- Fewer than ~15 people touch it and the process changes month to month. Platforms let a non-engineer reshape the tool the same afternoon the process changes.
- The data model is flat or lightly relational. Airtable handles records, views, and a few linked tables without a database migration.
- You need it live this week. Retool wires a CRUD admin panel onto an existing database in a day or two; a custom equivalent is weeks.
- The logic is standard. Approvals, task tracking, a lightweight CRM (Customer Relationship Management), an internal directory, someone has already solved this, and a custom rebuild buys you nothing but maintenance.
Being honest about this is the point: if a $20/user/month tool does the job, building your own version is a bad trade. You would be paying six figures to own a maintenance burden that a vendor carries for you.
When does custom internal tools development actually pay off?
Custom earns its cost in a narrow, high-value band. Build when:
- The tool is your core operational workflow. If the tool is how your team makes money, dispatch, underwriting, fulfillment, pricing, the fit gap in an off-the-shelf platform costs you real hours every day, and those hours compound.
- Integration depth exceeds what the platform models. Two-way sync across four internal systems, event-driven triggers, or logic that has to run server-side and audited is where low-code hits a wall.
- Permissions and compliance get granular. Row-level access, audit trails, SOC 2 or HIPAA scope, data that legally cannot sit on a third-party platform.
- Scale turns seat pricing hostile. Retool and Airtable price per user or per usage. Past a few hundred active users, that recurring bill crosses the cost of owning the code outright.
- The tool is a durable asset, not an experiment. Build things you will still run in three years, not things you are still validating.
Across 2,000+ projects, the pattern is consistent: the tools worth building are the ones a company would refuse to switch off. Everything else stays bought.
How do the options compare side by side?
| Factor | Spreadsheets | Airtable | Retool | Custom build |
|---|---|---|---|---|
| Upfront cost | $0 | $0 to low | Low setup | $60k to $150k typical |
| Ongoing cost | ~$0 | Per seat, scales with users | Per seat + usage, scales fast | Hosting + maintenance (you own it) |
| Time to value | Hours | Days | Days to weeks | 6 to 14 weeks |
| Fit to your workflow | Loose | Good for records | Good for CRUD/admin | Exact |
| Control | None | Limited | Moderate (bounded by platform) | Total |
| Integration depth | Manual | Shallow, via API/connectors | Moderate, DB and API friendly | Unlimited |
| Lock-in risk | Low | Moderate (data + views) | High (logic lives in platform) | None (code is yours) |
| Breaks at scale | ~5 to 10 users | Data volume + seat cost | Seat/usage cost, complex logic | Only if under-resourced |
What does total cost of ownership look like at scale?
Sticker price misleads because it ignores time. A spreadsheet is free until three people are editing it at once and someone overwrites the master. Retool is cheap at 10 users and painful at 400. The real comparison is three-year total cost of ownership at your actual headcount.
| Scenario | Off-the-shelf 3-yr TCO | Custom 3-yr TCO | Verdict |
|---|---|---|---|
| 15 users, standard workflow | ~$10k to $25k | ~$90k to $180k | Buy, custom never pays back |
| 75 users, moderate integration | ~$45k to $90k | ~$110k to $200k | Buy, but watch the trend line |
| 300+ users, core workflow, deep integration | ~$130k to $300k+ | ~$130k to $230k | Build, costs converge, control wins |
Custom TCO folds in hosting and maintenance, which is real and runs roughly 15 to 25 percent of the build cost per year. It is not free to own software. But an off-the-shelf bill that grows with every hire is the quieter, larger cost most teams underweight. The crossover typically lands where platform fees reach $40k to $80k/yearbeyond that, owning the code is cheaper and you stop renting your own workflow.
What is the committed recommendation by company stage?
- Pre-seed and seed: Buy everything. Spreadsheets and Airtable. Your workflows are still changing weekly, so you cannot afford to freeze one in custom code. Zero engineering time on internal tooling.
- Series A / early growth: Mostly buy, with Retool as the workhorse for admin panels and ops dashboards on your database. Build custom only if one tool is already the bottleneck on revenue and the process has stopped changing.
- Series B and scaling: Run a mixed portfolio. Keep buying for supporting workflows. Build the one or two tools that are your operational core, where seat pricing is climbing and the fit gap costs real hours daily.
- Enterprise: Build the core, buy the edges. At your scale, per-seat platform economics and compliance scope justify owning the critical tools outright, while off-the-shelf still wins for everything peripheral.
The default answer is buy. The exception, build, is real, valuable, and narrow. Get the exception right and you own the two tools that actually differentiate you while paying a vendor to carry everything else.
The evidence behind this guide
Independent findings on why this investment pays off. Every link goes to the primary source.
- Companies in the top quartile of McKinsey's Developer Velocity Index had 2014-18 revenue growth four to five times faster than bottom-quartile peers, showing that software-building capability is a driver of business performance, not just a support function. Source: McKinsey & Company (2020) →
- Only 16% of respondents said their organizations' digital transformations had successfully improved performance and equipped them to sustain gains over the long term; even in digitally savvy industries such as high tech, media, and telecom, self-reported success rates did not exceed 26%. Source: McKinsey & Company (2018) →
- The 2015 CHAOS data (based on the modern definition of success) reports that only about 29% of software projects succeed, 52% are challenged, and 19% fail, with the three most important success skills being executive sponsorship, emotional maturity, and user involvement. Source: The Standish Group (reported via InfoQ Q&A with Jennifer Lynch) (2015) →
- Deloitte's research found that digitally advanced small businesses experienced revenue growth nearly 4x as high as the prior year, were about 3x as likely to have exported, were nearly 3x as likely to have created new jobs, and were more than 3x as likely to have seen more sales inquiries in the last year. Source: Deloitte (research summarized by Google) (2017) →
Rohan advises mid-market and enterprise teams on ERP, CRM and custom software, and has led delivery on dozens of business-software builds.
Writes for Digital Heroes, shipping business software for 2,000+ brands across 55+ countries since 2017.
Frequently asked questions
Is Retool considered build or buy?
Retool is buy, a low-code platform you configure rather than code from scratch. It sits between a spreadsheet and a custom build: faster and cheaper than custom, but your logic lives inside the platform, so per-seat pricing and lock-in grow with usage. It is the right middle ground for admin panels and internal dashboards, and the wrong choice once seat costs cross the price of owning the code.
How much does custom internal tools development cost?
A focused custom internal tool typically runs $60k to $150k to build, depending on integration depth and permissions complexity, plus ongoing hosting and maintenance of roughly 15 to 25 percent of the build cost per year. Simple single-purpose tools land at the low end; multi-system, audited, role-based tools land higher. The number only makes sense when it is offset by off-the-shelf fees you would otherwise pay at scale.
When do spreadsheets stop being good enough?
Spreadsheets break around five to ten concurrent editors, or when the data becomes relational, when you need real permissions, or when one bad paste can corrupt the source of truth. At that point move to Airtable or a Retool app on a proper database. Spreadsheets stay excellent for one-off analysis and truly small teams; they fail as shared operational systems.
What is the biggest hidden cost of off-the-shelf tools?
Per-seat and per-usage pricing that scales with every new hire. A platform that costs $2k/year at 10 users can cost $60k+/year at 400, and that bill never stops. The second hidden cost is lock-in: when your logic lives inside the platform, migrating off later is its own project. Model the three-year cost at your projected headcount, not today's.
Should a growing startup build or buy internal tools?
Buy first, at nearly every stage. Pre-seed through Series A should run on spreadsheets, Airtable, and Retool so no engineering time goes to internal tooling. Build custom only when a specific tool is your operational core, the process has stabilized, and platform seat costs are climbing past roughly $40k to $80k/year. Build the one or two tools that differentiate you; buy the rest.