Free download, RFIs

Free construction RFI log template (Excel)

This free RFI log template is an Excel workbook for tracking every request for information from the day it is sent to the day it is answered. It calculates the response due date and days open, flags overdue RFIs, and marks cost and schedule impact so an answer that changes scope becomes a change event. No email, no macros.

Download the template

No sign-up, no email. 3 sheets, no macros, 15 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
RFI logThe blank working log: dropdowns for recipient, status, ball-in-court and impact; formulas for due date, days open and the overdue flag
Example (Texas)Seven RFIs from an illustrative Austin, TX medical office building

What do the columns mean?

The columns follow what a good RFI needs and what the contract says about answering it.

ColumnWhat to enterWhy it matters
RFI no., Date sentA running number and the day it went outThe clock for the answer starts here.
Subject, QuestionOne question per RFI, in plain wordsAIA A201-2017 Section 3.2.2 asks the contractor to report errors, inconsistencies or omissions it finds as a request for information.
Sheet / detail, Spec sectionWhere the conflict is, for example S-101 detail 4 and 03 30 00Lets the reviewer find it in seconds, and shows you checked the documents first.
Proposed answerYour suggested solutionReviewers answer faster when they only need to agree or correct.
Sent to, Days allowed, Response dueThe reviewer, the days your contract or Division 01 allows, and the calculated due dateA201 Section 4.2.11 asks the architect to respond with reasonable promptness; many contracts set a fixed number of days.
Date answered, Answer summary, StatusWhen and what came backA closed RFI is part of the project record; keep the answer short and searchable.
Ball in court, Days open, FlagWho has it, how long it has been out, and OVERDUE when lateA study of 1,362 projects found a median reply time of 9.7 days (Navigant Construction Forum, 2013).
Cost impact, Schedule impact, Change event no.Y, N or TBD, and the change event the answer startedAn answer that changes scope is the start of a change order; written notice deadlines apply.

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.

RFISentDueDays openBall in courtImpactFlag
RFI-012 Footing depth at grid C4Oct 19, 2026Oct 26, 20264General contractorcost
RFI-015 Door hardware set 6Oct 27, 2026Nov 3, 202617ArchitectTBDOVERDUE
RFI-016 Duct routing at corridor 104Oct 29, 2026Nov 5, 20267General contractornone
RFI-017 Roof drain sizeNov 2, 2026Nov 9, 202611EngineerTBDOVERDUE
RFI-018 Fire rating at stair 2Nov 6, 2026Nov 13, 20267Architectcost
RFI-019 Slab edge at curtain wallNov 10, 2026Nov 17, 20263Engineerschedule
RFI-020 Paint finish in lobbyNov 12, 2026Nov 19, 20261Architectnone

Illustrative5 RFIs are open and 2 are past their 7-day response date. RFI-018 already has cost impact, so it carries change event CE-009 before anyone has answered it.

How do you use the template?

  1. Search the documents first. Before you write an RFI, check the drawings, specs and addenda. Many questions are already answered by a detail or a spec section.
  2. Write one question per RFI. Name the sheet, detail and spec section, and add a proposed answer. Set Days allowed from your contract.
  3. Log it the day it goes out. Enter the date sent and who it went to; the response due date calculates itself.
  4. Mark the impact early. Set cost and schedule impact to Y or TBD as soon as you suspect it, and open a change event so notice deadlines are not missed.
  5. Close the loop. When the answer arrives, enter the date and a one-line summary, update the status and send it to the field.
  6. Review the open list weekly. Filter Flag for OVERDUE and walk the open RFIs in every OAC meeting, ball-in-court first.

For the benchmarks and the habits that cut turnaround, read RFI response time: the 9.7-day benchmark.

When does a spreadsheet stop being enough?

A log tells you what is late; it does not stop the next unnecessary RFI. That takes someone checking the drawings and specs before each question goes out, on every job. Colin, BAU AI's communication agent, reads the project inbox, checks whether the documents already answer a question, drafts the RFI with its references and keeps this log and the reminders current. A person on your team approves anything that goes outside your company. Colin is offered to the founding cohort and is not part of the published plans.

Frequently asked questions

Is the RFI 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 IF, OR and TODAY, and the dropdowns carry over. There are no macros.

How many days should an RFI take?

Use the number in your contract or Division 01. As a benchmark, a 1,362-project study found a median reply time of 9.7 days.

When does an RFI become a change order?

When the answer changes scope, cost or time. Mark the impact in the log, open a change event and give written notice within the time your contract requires.

See Colin draft an RFI from your drawings

Bring one open question from a live job. In 15 minutes Colin checks the documents and drafts the RFI with its references.