HVAC Takeoff Excel Template and Ductwork Spreadsheet
Most HVAC estimators live in Excel, and a clean takeoff spreadsheet is the backbone of a fast bid. This page gives you a real, downloadable HVAC takeoff Excel template — the same structured workbook DuctIQ produces — so you can see exactly how a ductwork takeoff should be organised, and use it as a starting point whether you fill it in by hand or let DuctIQ export it for you.
Below: what columns the template includes, how to use it, when a spreadsheet is enough on its own, and when reading the drawings by hand becomes the bottleneck that software removes.
Start your free takeoffSee pricing
Download the HVAC takeoff template
Grab the spreadsheet in Excel or CSV. It is a clearly-labelled sample on a fictional project, structured the way a mechanical estimator prices a job — use it as a template for your own takeoffs or as a preview of what DuctIQ exports.
Download Excel template (.xlsx)Download CSV version
What columns the template includes
The template is organised into a ductwork takeoff and a fittings/equipment section, with the columns an estimator actually prices against:
- Line — a takeoff line ID so every quantity is traceable back to the drawing.
- System — SA, RA, EA so supply, return, and exhaust stay separated.
- Shape — rectangular or round, because they buy and fabricate differently.
- Size — duct dimensions (e.g. 24x12) or round diameter.
- Gauge — sheet metal gauge for material cost (SMACNA minimum labelled when not specified).
- Insulation — liner or wrap callout where it applies.
- Qty, Unit, and LF / EA — quantity with linear feet for runs and each-counts for fittings and equipment.
- Review Status — "Reviewed" or "Needs review", so an estimator can see what still needs a second look.
How to use the template
Used by hand, the template is a discipline: work the drawing system by system, log each run with its size and length, count fittings, and pull equipment from the schedule into the same sheet. Keeping the columns consistent means your formulas — unit material cost, labour hours per LF, insulation — attach cleanly and the same bid sheet works job after job.
Used as a DuctIQ export, the same structure fills itself in. DuctIQ reads the drawing, measures the duct, and writes these exact columns, so the file you download is already populated and reviewed rather than blank.
When a template is enough
For a small, single-system job — a rooftop unit and a short run of duct, a quick service change-out, a one-zone fit-out — a spreadsheet template is genuinely all you need. The drawing is simple, the count is short, and the time to scale it by hand is minutes. Reaching for software there is overkill, and we will happily say so.
When software saves the re-keying
The template stops scaling the moment the job does. A multi-storey set with repeated cores, dozens of branch runs, and a full equipment schedule turns a hand takeoff into an evening of scaling and tallying — and every manual measurement is a chance to transpose a size or miss a run.
That is where DuctIQ earns its place: it reads the mechanical PDF, measures the ductwork at scale, counts fittings, lists equipment from the schedules, and exports the populated template — so you review instead of re-key. The spreadsheet stays the same; the way it gets filled in changes.
How DuctIQ exports reviewable takeoffs
DuctIQ's export is not a black box. Every line in the workbook corresponds to a quantity you reviewed on screen, with a status column showing what was flagged for a second look. The columns are structured for formulas, the systems are separated, and the file is standard Excel/CSV — so it drops into your pricing workbook exactly like the template you would have built by hand, only already filled in.
Run your first takeoff free
Upload a mechanical PDF and get a reviewable ductwork, fittings, and equipment takeoff you can export to Excel. No credit card to try your first drawing.
Start your free takeoff See pricingRelated HVAC takeoff guides
Frequently asked questions
Is the HVAC takeoff Excel template free to download?
Yes. You can download the Excel (.xlsx) and CSV versions directly from this page with no account. It is a clearly-labelled sample on a fictional project that doubles as a reusable template.
What columns are in the ductwork takeoff spreadsheet?
Line ID, system (SA/RA/EA), shape (rect/round), size, gauge, insulation, quantity, unit, linear feet or each-count, and a review status — the fields an estimator prices a mechanical job against.
Can I use the template by hand without the software?
Absolutely. The spreadsheet is a usable HVAC takeoff template on its own. Software helps when the job gets large enough that hand-scaling every run becomes the bottleneck.
How does DuctIQ fill in the template?
DuctIQ reads your mechanical PDF, measures the ductwork at scale, counts fittings, and pulls equipment from the schedules, then exports these exact columns already populated and reviewed — so you check the numbers instead of re-keying them.
Does the export work with my existing bid sheet?
Yes. Because the output is standard Excel/CSV with structured columns, it drops into the pricing workbook or estimating system you already use, and your formulas attach to the columns directly.