Why garment exporters are quietly leaving Excel
Excel costing templates have run the merchandising desk for two decades. Here is why they are being replaced, and what comes next.
There is a particular Excel file that lives on every export-house shared drive in India. It usually has a name like StyleCosting_v17_FINAL_FINAL.xlsx. It has fourteen tabs. It is, depending on the day, the most important asset the company owns.
We were one of those export houses. We built that file. We patched it for ten years.
And we just stopped using it.
This is a short account of why.
What the spreadsheet was actually doing
If you have ever opened one of these files, you know the shape. The first tab is Style Info, with the style number, article name, buyer, order quantity, currency. The second is Fabric, with rows for shell, lining, pocket bag, each with GSM, width, rate, consumption, wastage. The third and fourth are Materials and Trims: thread, fusing, lace, buttons, embroidery, zipper, plus custom rows the merchandiser added for one buyer and never deleted. Then four tabs for CMT: cutting, stitching, finishing, quantity-based. Then Cost Summary, where the formulas finally compound: subtotal, overhead %, wastage %, markup %, bill discount. Then a tab nobody touches called FX, with the day’s exchange rate hard-coded into a cell.
It works. We costed hundreds of styles in it.
What it did not do is everything else.
Where the spreadsheet stops
The costing is the easy part. The hard parts come after.
The pitch. Buyers do not read spreadsheets. They look at PPTs. So once the costing is done, somebody (usually the senior-most merchandiser) opens PowerPoint, picks a template, copies in five style photos one at a time, retypes the prices from the spreadsheet, sets the table in something approximating a serif, exports it as .pptx. Thirty minutes per PPT. Five buyers a week. Two and a half hours.
The email. PowerPoint exported, attach to Outlook, type the buyer’s address (was it the procurement head or the design director?), CC the internal merch list (which one of the four was it?), type a polite paragraph, hit send. Ten minutes if everything is in muscle memory. Twenty if the buyer has just changed.
The hunt, three months later. A sample arrives in the studio. Nobody is sure which costing it matches. The merchandiser who built it has moved companies. Twenty minutes of opening sheets. Maybe an hour.
The currency math. The exchange rate that was in the FX tab was right last Tuesday. Today it is not. The buyer was quoted at the old number. The margin moved. Nobody noticed.
None of these are Excel’s problem. Excel was never trying to solve them. We were just pretending it was.
The thing we built instead
After enough Tuesdays of this we built a tool. It is not particularly innovative. It is just specific.
- The costing form is one screen. Fabric, materials, trims, CMT in four cards, a live cost summary on the right. The markup math runs in the right order automatically.
- Each style auto-generates a CODE128 barcode. We print it on the sample sheet. The studio scans it later. The costing opens.
- “Generate PPT” is a button. The PPT is one slide per style, in Georgia on cream paper, with photos placed by an algorithm that knows whether there are zero, one, or two of them.
- “Send enquiry” is a button. The email is the same Georgia-on-cream layout we’d been faking in Outlook for years, but now actually composed correctly. The PPT attaches itself. Internal CC auto-includes.
- The exchange rate auto-fetches every time we open a style. A buffer % is editable. We never quote at the spot rate again.
- Every style is searchable. By style number, article, quality, buyer, anything. Forever.
It took the merchandising team from two hours a style to twenty minutes. We started using the saved time on actual quality questions: shade variation, fabric substitution, MOQ. Quietly, the spreadsheet stopped opening.
Why we’re writing this
When peer exporters in Tirupur and Delhi started asking what we were using, we realised something. It was not just us. Every export house we know is doing some version of this same handoff dance between three tools, every day, for every style. Half the merchandising department’s time is spent on the handoff, not the actual merchandising.
Excel did not get worse. The work just got more demanding, and the spreadsheet has not been keeping up.
We made the tool a product. It’s called TextileCost. It costs less than the time it saves on the first week of use. There is a 14-day free trial and no credit card, because we’re pretty sure you’ll know in the first week whether it’s for you. Sign up here.
The Excel file is still on our shared drive. We open it about once a quarter, mostly out of nostalgia. Nobody has typed into it in months.
