Interior BOQ format in Excel: free template
A free interior BOQ template in Excel with 41 common items in 9 trades, each line already written with its unit and how it is measured. Fill the values in brackets, add quantities and rates; the amount and total formulas are in place. Why there are no rates, and how to build them, is below.
Pujan Motiwala · Standards checked against the BIS catalogue on
Download
The columns, and why each is there
- S.No
- Line number, running through the whole BOQ.
- Description
- What the item is, what it is made of, its size and finish. Each line starts from the library wording; replace the values in [brackets].
- Unit
- What the line is priced in: sq ft, running ft, nos, point or lump sum. Keep one unit per item type across the BOQ, or quotes can't be compared.
- Measurement basis
- How the quantity was measured, e.g. “front elevation, loft excluded”. Modular work has no national measurement standard, so this column is where disputes are prevented.
- Qty
- From the drawings, in the line's unit.
- Rate
- Left empty: filled by whoever prices it.
- Amount
- Qty × rate, already a formula; the total row sums it.
- Item id
- The line's id in the item library (e.g. wardrobes.hinged), so a pasted BOQ can be matched back to it.
What it looks like
Two lines from each trade, as they appear in the file. The full list, with what each line must name and what quotes leave out, is in the item library.
| Description | Unit | Measurement basis |
|---|---|---|
| Civil and demolition Dismantling existing [flooring / partitions / fixtures] in [rooms], including stacking reusable material and carting debris to an approved dump. | lump sum | Priced as a lump sum for a defined scope, or by the area or volume broken out. Name what is removed and where the debris goes. |
| Providing and building [100] mm thick [AAC block / brick] partition in [cement mortar 1:4], including lintels over openings. | sq ft | By face area of wall built, openings deducted; thick walls are sometimes priced by volume. |
| False ceiling Providing and fixing false ceiling of [12.5] mm gypsum board on [GI] suspension framing, joints taped and finished; measured by plan area of the flat field, excluding coves and bands. | sq ft | The flat field by plan area. Coves, drops and bands are usually a separate running-ft line; say whether cut-outs are deducted. |
| Providing and making ceiling cove [300] mm wide × [150] mm drop in [12.5] mm gypsum board on [GI] framing; measured by running length. | running ft | By running length along the cove or band; state its girth (height plus width). |
| Flooring and wall tiling Providing and laying [600 × 1200] mm vitrified tile flooring of [make, series] on [tile adhesive / cement mortar] bed, joints filled with [epoxy / cementitious] grout. | sq ft | By finished floor area laid; skirting is a separate line. |
| Providing and laying [18] mm [marble / granite] flooring, [mirror polished], on [cement mortar] bed, including machine polishing after laying. | sq ft | By finished area laid. |
| Carpentry and joinery Providing and fixing wall panelling in [12] mm [IS 303 BWP] plywood on [batten] frame, finished in [1] mm laminate; measured by face area including frame. | sq ft | By face area of panelling; say whether framing and grooves are included. |
| Providing and making [TV] unit in [18] mm [IS 303 BWP] plywood carcass, [1] mm laminate outside, [0.8] mm laminate inside, [2] mm PVC edge band, [make] soft-close hinges and channels; measured by front elevation area. | sq ft | Usually by front elevation area (height × width); some quote per unit. State which. |
| Modular kitchen Providing and making kitchen base cabinets [600] mm deep in [18] mm [IS 303 BWP] plywood carcass, shutters in [acrylic / laminate], [2] mm PVC edge band, [make] soft-close hinges and channels; measured by running length along the wall, excluding countertop and accessories. | running ft | Usually by running length along the wall at counter height; corners counted once. State whether the plinth and back panels are included. |
| Providing and making kitchen wall cabinets [700] mm high × [350] mm deep in [18] mm [IS 303 BWP] plywood, shutters in [laminate / acrylic], [2] mm PVC edge band, [make] hinges; measured by running length. | running ft | By running length along the wall; state the height. |
| Wardrobes Providing and making hinged wardrobe in [18] mm [IS 303 BWP] plywood carcass, [1] mm laminate outside, [0.8] mm laminate inside, [2] mm PVC edge band, [make] soft-close hinges; measured by front elevation area, excluding loft and drawers. | sq ft | Usually by front elevation area (height × width). State whether the loft, side panels and internal drawers are included. |
| Providing and making sliding wardrobe in [18] mm [IS 303 BWP] plywood, shutters in [laminate / acrylic], [2] mm PVC edge band, [make, model] sliding system; measured by front elevation area, excluding loft. | sq ft | By front elevation area; state what's included. |
| Painting and polishing Applying [make, product] interior emulsion in [two] coats over [two] coats of wall putty and [one] coat of primer. | sq ft | By area painted; walls and ceilings are measured separately. |
| Applying [make, product] texture finish over prepared surface, as per approved sample. | sq ft | By area finished. |
| Electrical Wiring [light / 6 A socket / 16 A power] point with [1.5] sq mm FRLS copper wire in concealed PVC conduit, including [make] modular switch and plate; one point measured from the board to the outlet. | point | By point. State what one point includes: conduit, wire to the board, switch and plate. |
| Providing and fixing distribution board, [8]-way, of [make] with [MCBs and RCCB as per schedule]. | nos | By number, ways and protection stated. |
| Plumbing and bathrooms Providing concealed water supply piping in [CPVC / PPR] of [make], [20] mm, including fittings and pressure test; measured by point. | point | By point or by running length; state which, and what a point includes. |
| Waterproofing bathroom floor and walls up to [300] mm with [make, system] in [two] coats, including ponding test. | sq ft | By area treated, wall upturn included; state the upturn height. |
Why there are no rates
Rates for the same line differ by city, by month and by the specification in it: 18 mm BWP plywood with acrylic shutters and 16 mm MR plywood with laminate are both “kitchen base cabinets”. A template with rates filled in would be wrong for most readers the day they used it. Build a rate from its parts, material, labour, wastage, overheads and margin (a rate analysis), or have contractors price the same lines so their quotes can be compared.
After you fill it
Paste the filled sheet into the BOQ checker: it flags lines that leave the board grade, thickness, finish, hardware, unit or measurement basis open, then prints the BOQ as a GST quotation. How to write the lines in the first place is in how to make an interior BOQ, and how each trade is measured in measurement rules.
Paste a BOQ from Excel and see what each line leaves open, then print it as a quotation.
Designer Ops keeps your own BOQ library and every quote, turns an accepted quote's payment stages into invoices, then runs the project: orders, site visits and the workshop. Try the live demo · system for interior designers · what to require from one
Official sources
- Indian Standards catalogue (Know Your Standards). Bureau of Indian Standards, October 23, 2026.
What this page is not
A guide written by Ahrom Labs; not legal, tax or engineering advice. Indian Standards are cited by number and title from the BIS catalogue, not quoted; the standard governs wherever this page differs from it. No rates are given: they change with city and month. Last updated .
Talk to us about your systems.
Tell us what's held together with workarounds right now. We reply to every message ourselves.