Free Construction Submittal Template (Excel)

What's in the Construction Submittal template

The Submittal Log sheet holds one row per submittal, up to 80, with submittal number, spec section, description, supplier/sub, date submitted, date returned, and status.

Two calculated columns track turnaround from opposite ends: Days pending shows today minus the submission date for items still open (no return date entered), and Turnaround days shows the return date minus the submission date once an item closes.

The summary below the table counts submittals by status - Pending, Approved, Revise & Resubmit, Rejected - plus closed submittals and the average turnaround days across everything that's been resolved.

Tracking both open and closed items in one column pair

A submittal log needs to answer two different questions depending on whether an item is still open or already resolved: 'how long has this been sitting?' versus 'how long did that one actually take?'

This template answers both with a single pair of columns that never overlap - Days pending is blank once an item closes, and Turnaround days is blank while an item is still open - so the average turnaround in the summary only reflects genuinely closed items, not skewed by open ones still accumulating days.

Status is a dropdown, so every status rollup in the summary stays accurate as submittals move through Pending, get Approved or Rejected, or come back needing revision.

Who this template is for

General contractors and project managers on commercial or residential construction jobs who need to track shop drawings, product data, and material samples through the approval process.

It's a tracking log, not a submittal-review workflow tool - use it alongside your existing review and approval process to keep a running record of who has the ball on each item.