Quoting in Excel vs a quoting system: when to make the move
Almost every company starts out quoting in Excel, and that is fine. This guide is for the moment the spreadsheet starts costing more than it saves: how to recognize it, and how to move on without stopping sales.
Excel is a good first quoting tool
A sheet with your price list, a few formulas and a print layout solves a lot, costs next to nothing and anyone can follow it. For one person quoting a handful of products, nothing needs to change.
The problem is not Excel. It is that the sheet does not grow at the same pace as the company: more salespeople, more products, more exceptions, each one handled with another column or another copy of the file.
The signs it is no longer enough
- Every salesperson has their own version of the file, and not all of them have this month's prices.
- A broken formula or a typo has already cost you an order or a margin.
- Putting together the formal PDF takes longer than deciding the price.
- Quotes have no number and no history: nobody knows what was offered, to whom and when.
- Leadership asks for the pipeline report and someone has to build it by hand.
- Your product has options that depend on each other and the sheet cannot stop an impossible combination.
With two or three of these, the sheet is already costing your team hours every week, even if those hours never show up on a P&L.
What a quoting system changes
A quoting system is not a nicer spreadsheet. It is one source of prices and rules that everyone uses at the same time:
- A live catalog, with price and stock, updated in one place.
- Rules that stop anyone quoting what cannot be supplied or made.
- Discounts with limits, and approval when someone goes below margin.
- The PDF with your branding and terms, produced from the same record.
- A number, status and history for every quote, and the pipeline in view of leadership.
| Topic | Excel sheet | Quoting system |
|---|---|---|
| Prices | One copy per salesperson | One source, always current |
| Product rules | In the quoter's head | Inside the system |
| Formal PDF | Assembled and recalculated by hand | Produced from the same record |
| History | Search emails and folders | Number, status and date per quote |
| Leadership report | Someone builds it | Always in view |
Off-the-shelf software or a custom quoting tool?
If you sell products without options and your prices are a list with simple discounts, off-the-shelf quoting software is probably enough, and cheaper. Try it first.
A custom quoting tool makes sense when your rules are what sets you apart: configurable products, per-customer pricing, approvals of your own, or when the quote has to keep living afterwards (credit, contract, order, after-sales) in the same system.
What it looks like in production: a distributor in the Bajío
Zebretaro distributes Zebra equipment. Before, quotes came in over WhatsApp, phone and email; the catalog lived in an Excel file, and every formal PDF was assembled and recalculated by hand.
Today the customer builds their quote on the site, on a live catalog with price and stock. The request reaches the team with its own number, the advisor adjusts it, and the branded PDF comes out of the same record, with nothing re-keyed.
What changed most was not the look of the PDF. It was that the quote the customer starts is the same one the advisor finishes: nothing gets lost on the way.
How to move without stopping sales
- Gather every version of the sheet and decide which price list is the official one. It is usually the most revealing part of the project.
- Write down the rules each salesperson applies from memory today: discounts, combinations, exceptions.
- Start with one product line or one team, in production, while everyone else stays on Excel.
- Once that stage works, bring in the rest. Keep an Excel export for whoever needs it.
Frequently asked questions
Can I still export to Excel?
Yes. A good quoting system exports whatever you need; what changes is that Excel stops being the source of truth.
Can we quote from a phone?
Yes. The system runs in the browser, so a salesperson on a visit can quote and send the PDF from their phone.
Can my customers build quotes themselves?
If it suits you, yes: they build a request in the catalog and an advisor reviews it before it goes out, as at Zebretaro.
Has your operation outgrown spreadsheets?
Tell us how you sell, quote and serve today. We'll tell you what we would build, and in what order.