Why HVAC Manufacturers Are Still Using Spreadsheets for Product Selection (And What It's Costing Them)

The Spreadsheet Habit Is Hard to Break

Walk into most HVAC manufacturers' sales offices and you'll find the same thing: a shared drive full of Excel files, each one a minor engineering feat in its own right. Formulas referencing other formulas. Hidden tabs. Macros that nobody touches because the person who wrote them left in 2019.

It's not that these teams don't know spreadsheets have limitations. They do. But spreadsheets are familiar, they're free, and they technically work — until they don't.

Why Manufacturers Keep Coming Back to Excel

The reasons are understandable. Spreadsheets are flexible. An engineer can modify one to match a new product range without waiting on a software vendor. They can be emailed. They don't require logins or licences. For a small team doing occasional custom selections, a well-built spreadsheet can handle the job.

The problem is that most HVAC manufacturers aren't small teams doing occasional selections. They're running dozens of project quotes a week, across multiple product lines, with varying input conditions — and they're doing it with tools that were never designed for that volume or complexity.

What It's Actually Costing You

The costs rarely show up as a line item. They're buried in time and errors:

Version control failures. A salesperson sends a quote based on last month's spreadsheet. The pricing has since changed. The job gets won — at the wrong margin.

Input errors. Airflow entered in the wrong units. A decimal in the wrong place. These aren't hypothetical — they happen regularly, and they create rework that can blow out a project timeline.

Speed to quote. A competitor with a proper selection tool can turn around a quote in minutes. If your team is manually working through a spreadsheet, you're slower — and in a competitive market, that matters.

Knowledge lock-in. When your most experienced engineer leaves, they take the spreadsheet know-how with them. Whoever inherits it spends months figuring out what half the formulas actually do.

The Transition Point

Most manufacturers hit a tipping point — usually after a costly error or a lost deal — where the spreadsheet system stops being “good enough.” The question is whether you want to reach that point reactively or get ahead of it.

Purpose-built product selection software doesn't just eliminate spreadsheet risk. It standardises the selection process, makes it auditable, speeds up quoting, and gives sales teams confidence they're specifying correctly every time.