BOQ & Tender Documents Updated 6 Nov 2026
3 min read · 258 words

How to Fill a BOQ Excel Sheet Properly Without Validation Errors on e-Tender Portals

One wrong keystroke, renamed file, or broken Excel formula can block your upload 10 minutes before deadline. Master safe NIC & CPPP BOQ entry rules.

Screenshot guide highlighting safe editable cells inside a standard NIC BOQ Excel sheet
By Suresh Menon Reviewed by SCL Procurement Editorial Desk
Portal Coverage
GeM, CPPP & State Portals
Section
BOQ & Docs
Access
Free Open Guide
Standards Status
Verified 2026 Rules
In This Guide (Quick Navigation)

NIC e-Procurement BOQ files (BOQ_xxxx.xls) use Excel-protected macro templates so the server can read quoted figures automatically upon Financial Opening.

Meaning & Definition

Depending on the tender, a BOQ works either as an Item-Rate BOQ (enter exact rupee price per line item) or a Percentage BOQ (choose Excess (+) or Less (-) % vs. buyer Department Schedule of Rates).

Why It Matters for Bidders & Suppliers

Editing protected headers, converting .xls to .xlsx, leaving empty mandatory rows without 0, or failing macro validation stops financial encryption cold.

Step-by-Step Process

  1. 1 Enable Macros cleanly when opening in Microsoft Excel (Options -> Enable Content).
  2. 2 Type your Legal Firm Name accurately in the top "Bidder Name" field (never insert special symbols like / \ < > &).
  3. 3 Fill ONLY the colored/unprotected entry columns (Rate In Figures, GST %/Amount if unlocked, Freight if separate).
  4. 4 Verify Total Amount In Figures AND Automatically Generated Words match expectations.
  5. 5 If there is a "Validate" macro button in the sheet, click it—ensure zero red validation warnings.
  6. 6 Save using Ctrl+S keeping exact original .xls filename (BOQ_12345.xls, NOT BOQ_12345 (1).xls!).

Common Mistakes to Avoid

  • ⚠Downloading the BOQ twice in browser so Windows names it BOQ_12345 (1).xls—portals reject filenames containing (1)!
  • ⚠Entering rates INCLUDING GST in a "Basic Rate Excluding GST" column—double-taxing your own bid by 18%!

Frequently Asked Questions

What do I type if I offer a specific line item free of cost or bundled?

Read the NIT rule carefully: in Item-Rate BOQs, leaving a cell completely blank sometimes treats the quote as incomplete/disqualified or invalid! Follow explicit NIC instructions (0 vs valid positive rate).

Official References & Government Sources

Editorial Verification & Publishing Metadata
Published: 17 Sept 2026 · Last Reviewed: 6 Nov 2026
Author: Suresh Menon · Compliance Review: SCL Procurement Editorial Desk
WhatsApp LinkedIn

Related Procurement Guides

More in BOQ & Tender Documents →