Divisions 30 through 39 (Earthwork, exterior improvements, utilities, transportation)
Divisions 02–19 (e.g., Openings, Finishes, Specialties).
Directly copy numbers and titles into Excel-based estimating software, Revit tagging systems, or MS Project schedules.
Rough carpentry, architectural woodwork, structural plastics Thermal and Moisture Protection Waterproofing, insulation, roofing, joint sealants Division 08 Doors, hardware, windows, curtain walls, skylights Division 09 Drywall, tiling, flooring, acoustic ceilings, painting Division 21 Fire Suppression Sprinkler systems, fire pumps, clean-agent suppression Division 22 Piping, commercial fixtures, water heaters Division 23 Air distribution, boilers, chillers, controls Division 26 Electrical Power distribution, lighting, wiring, transformers Division 31 Excavation, soil stabilization, shoring, grading How to Structure Your MasterFormat Excel Document
Create consistent, organized, and reliable cost estimates. csi masterformat 2020 excel download
Use color-coding to separate Level 1 Divisions from Level 2 and 3 sections. This creates a clean visual hierarchy that makes scanning large spreadsheets much faster.
: Offers an updated construction estimation spreadsheet that utilizes MasterFormat codes for unit costing.
By consistently archiving completed project data in a standardized Excel format, construction firms build a valuable database of historical costs. Over time, you can analyze your Division 22 (Plumbing) or Division 26 (Electrical) historical averages to create faster, more accurate conceptual estimates for future clients. Key Divisions to Look For in a 2020 Template
Format Code columns as "Text" instead of "Number" so Excel does not drop the leading zeros (e.g., changing 03 00 00 to 30000 ). Use color-coding to separate Level 1 Divisions from
Highly specific items (e.g., 03 31 00 for Structural Concrete). Why You Need a MasterFormat Excel Template
The safest and most compliant route is through the official CSI website. Members often receive access to digital tools, look-up tables, and licensing formats designed for corporate integration. Industry Templates and Estimating Blogs
Tender documents, contracts.
While the foundational structure remains, the 2020 edition introduced several critical updates, particularly in electrical and security sectors: By consistently archiving completed project data in a
Revisions were made to distinguish between power systems and lightning protection systems, moving early streamer emission lightning protection to Division 13.
Specific topics such as 03 30 00 Cast-in-Place Concrete .
The Specifications Group is further broken down into specific subgroups to help teams navigate different engineering and architectural disciplines:
Add a simple checkmark or "Yes/No" column to flag the specific codes active on your current project. You can then filter the sheet to only display relevant line items, saving time during client reviews. If you need help setting up this spreadsheet, let me know: