Open Excel in a clean workbook. Step 2: Go to Data > Get Data > From File > From Text/CSV (or just open the file directly). Step 3: Select your downloaded MasterFormat_2020.csv . Step 4: Ensure delimiter is set to "Comma" and Encoding to "UTF-8." Step 5: Load to Table. Step 6: Add a Custom Column for "Search Keywords." Use this formula:
=IF(ISNUMBER(SEARCH("foundation",[Title])), "Foundation", "Other") csi masterformat 2020 excel download
This allows you to tag sections for quick filtering. Open Excel in a clean workbook
If you are a spec writer, estimator, project manager, or BIM coordinator, you have likely searched for the holy grail of organization: Step 4: Ensure delimiter is set to "Comma"
New sections in Division 01 for climate adaptation and Division 33 for flood barriers.
You need a sortable, searchable, and editable spreadsheet, not just a static PDF. You need the power of Excel to filter, map cost codes, and build your project manuals.
Visit the official CSI store or your Procore/Bluebeam portal today. Your future self—the one not staying up late chasing misnumbered specs—will thank you. Disclaimer: This article is for informational purposes. CSI MasterFormat is a registered trademark of the Construction Specifications Institute. Always refer to CSI for the most current and official version.