Free construction submittal log template (Excel)
This free submittal log template is an Excel workbook for tracking every shop drawing, product data sheet and sample on a job. It works each due date back from the date the material is needed on site, minus lead time and review time, and flags anything late or overdue with the reviewer. No email, no macros.
Download the template
No sign-up, no email. 3 sheets, no macros, 17 KB. Opens in Excel or Google Sheets. The example sheet uses illustrative Texas project data; the blank sheet is ready to use.
What is in the workbook?
| Sheet | What it is for |
|---|---|
| Instructions | The steps on this page and what each column means |
| Submittal log | The blank working log: dropdowns for type, status and ball-in-court, formulas for due date, days out and flags |
| Example (Texas) | Seven filled rows from an illustrative Austin, TX medical office building |
What do the columns mean?
Each column answers a question someone asks in the OAC meeting. The "why" column names the contract clause or spec section behind it, so the log matches what your contract requires.
| Column | What to enter | Why it matters |
|---|---|---|
| Submittal no., Spec section | A number per submittal and its CSI MasterFormat section, for example 08 44 13 | The spec book is the source of the register: each section lists its required submittals, usually in Part 1. Section 01 33 00 sets the procedure. |
| Description, Type | What it is, and whether it is shop drawings, product data, samples, a mockup or closeout | AIA A201-2017 Section 3.12 defines shop drawings, product data and samples as different things with different reviews. |
| Subcontractor | Who prepares it | Tells you who to chase when the date slips. |
| Required on site | The date the material must be on site, from the schedule | Everything else is worked back from this date. |
| Lead time, Review days | Fabrication and delivery time in weeks; the review time agreed in the contract or Division 01 | A201 Section 3.10.2 asks for a submittal schedule that allows the architect reasonable time to review. |
| Due to architect | Calculated: required on site minus lead time minus review days | The last safe day to send it. Miss it and the material arrives late. |
| Sent, Returned, Status, Revision | Dates and the action the reviewer took | A201 Section 4.2.7 has the architect review for conformance with the design intent; "revise and resubmit" starts a new cycle. |
| Ball in court | Who has it now | The one column everyone reads first in the meeting. |
| Days out, Flag | Calculated: days with the reviewer; LATE or OVERDUE | LATE means it should already have gone out; OVERDUE means the reviewer is past the agreed review days. |
What does the example look like?
Seven rows from the Example sheet, as the formulas compute them on November 13, 2026. Illustrative data, not a real project.
| Submittal | On site | Lead (wks) | Due to architect | Status, ball in court | Flag |
|---|---|---|---|---|---|
| 05-001 05 12 00 Structural steel shop drawings, Level 2 framing | Feb 15, 2027 | 8 | Dec 7, 2026 | With architect, architect | |
| 08-004 08 44 13 Curtain wall system, north elevation | Apr 5, 2027 | 14 | Dec 14, 2026 | Revise and resubmit, subcontractor | |
| 26-002 26 24 13 Main switchboard | Mar 1, 2027 | 16 | Oct 30, 2026 | Not started, subcontractor | LATE |
| 14-001 14 21 00 Machine-room-less elevator | Apr 19, 2027 | 20 | Nov 16, 2026 | In GC review, general contractor | |
| 09-007 09 51 13 Acoustical ceiling panels | May 10, 2027 | 4 | Apr 2, 2027 | Approved as noted, general contractor | |
| 07-003 07 92 00 Joint sealants | Mar 22, 2027 | 2 | Feb 26, 2027 | Not started, subcontractor | |
| 23-005 23 73 13 Air handling units AHU-1 to AHU-3 | Feb 22, 2027 | 12 | Nov 16, 2026 | With architect, engineer | OVERDUE |
IllustrativeThe switchboard needs 16 weeks of lead time, so its submittal was due to the architect on Oct 30, 2026 and has not gone out: flagged LATE before anyone notices on site. The air handlers have been with the engineer for 30 days against 14 agreed: OVERDUE.
How do you use the template?
- Build the register from the spec book. Go section by section through the specifications and add one row for every submittal listed, usually in Part 1 of each section. Do it in the first weeks of the job, not when each trade mobilizes.
- Set the dates from the schedule. For each row, enter the date the material must be on site, the lead time in weeks and the review days from your contract or Division 01. The due date calculates itself.
- Start the long-lead items first. Sort by Due to architect. Switchgear, elevators, curtain wall and structural steel usually come first.
- Review before you send. Check each submittal against its spec section, dimensions and the other trades before it goes out, as A201 Section 3.12.5 requires of the contractor. Return incomplete ones to the subcontractor.
- Log every move. Enter the sent and returned dates, the status and the revision number, and update ball-in-court each time it changes hands.
- Review the flags weekly. Filter the Flag column for LATE and OVERDUE and walk the list in every OAC meeting.
For how submittals move between the subcontractor, the general contractor and the architect, read the submittal process for general contractors.
When does a spreadsheet stop being enough?
A log works when someone keeps it current. It gets hard when a spec book has 400 required submittals, when they arrive by email from 30 subcontractors, and when checking each one against its spec section takes longer than the review time. Colin, BAU AI's communication agent, builds the register from the spec book, checks incoming submittals against their sections, keeps ball-in-court current and chases what is late; your team stamps and sends. Colin is offered to the founding cohort and is not part of the published plans.
Frequently asked questions
Is the submittal log template free?
Yes. Download it without an email address and adapt it for your own projects. A credit line to BAU AI sits at the bottom of each sheet.
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets. The formulas use standard functions (IF, AND, TODAY) and the dropdowns carry over. There are no macros.
How is the due date calculated?
Due to architect equals the date required on site, minus the lead time in weeks, minus the review days. Change any of the three and the due date moves.
What is the difference between a submittal log and a submittal register?
The register is the list of every submittal the specs require; the log tracks each one's dates and status. This template does both in one sheet.
See Colin build a submittal register from your spec book
Bring one spec book to a 15-minute call. We build the register with you, each line tied to its section.