Free download, submittals

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?

SheetWhat it is for
InstructionsThe steps on this page and what each column means
Submittal logThe 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.

ColumnWhat to enterWhy it matters
Submittal no., Spec sectionA number per submittal and its CSI MasterFormat section, for example 08 44 13The 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, TypeWhat it is, and whether it is shop drawings, product data, samples, a mockup or closeoutAIA A201-2017 Section 3.12 defines shop drawings, product data and samples as different things with different reviews.
SubcontractorWho prepares itTells you who to chase when the date slips.
Required on siteThe date the material must be on site, from the scheduleEverything else is worked back from this date.
Lead time, Review daysFabrication and delivery time in weeks; the review time agreed in the contract or Division 01A201 Section 3.10.2 asks for a submittal schedule that allows the architect reasonable time to review.
Due to architectCalculated: required on site minus lead time minus review daysThe last safe day to send it. Miss it and the material arrives late.
Sent, Returned, Status, RevisionDates and the action the reviewer tookA201 Section 4.2.7 has the architect review for conformance with the design intent; "revise and resubmit" starts a new cycle.
Ball in courtWho has it nowThe one column everyone reads first in the meeting.
Days out, FlagCalculated: days with the reviewer; LATE or OVERDUELATE 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.

SubmittalOn siteLead (wks)Due to architectStatus, ball in courtFlag
05-001 05 12 00 Structural steel shop drawings, Level 2 framingFeb 15, 20278Dec 7, 2026With architect, architect
08-004 08 44 13 Curtain wall system, north elevationApr 5, 202714Dec 14, 2026Revise and resubmit, subcontractor
26-002 26 24 13 Main switchboardMar 1, 202716Oct 30, 2026Not started, subcontractorLATE
14-001 14 21 00 Machine-room-less elevatorApr 19, 202720Nov 16, 2026In GC review, general contractor
09-007 09 51 13 Acoustical ceiling panelsMay 10, 20274Apr 2, 2027Approved as noted, general contractor
07-003 07 92 00 Joint sealantsMar 22, 20272Feb 26, 2027Not started, subcontractor
23-005 23 73 13 Air handling units AHU-1 to AHU-3Feb 22, 202712Nov 16, 2026With architect, engineerOVERDUE

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?

  1. 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.
  2. 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.
  3. Start the long-lead items first. Sort by Due to architect. Switchgear, elevators, curtain wall and structural steel usually come first.
  4. 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.
  5. 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.
  6. 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.