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?
| Sheet | What it is for |
|---|---|
| Instructions | The steps on this page and what each column means |
| RFI log | The 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.
| Column | What to enter | Why it matters |
|---|---|---|
| RFI no., Date sent | A running number and the day it went out | The clock for the answer starts here. |
| Subject, Question | One question per RFI, in plain words | AIA 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 section | Where the conflict is, for example S-101 detail 4 and 03 30 00 | Lets the reviewer find it in seconds, and shows you checked the documents first. |
| Proposed answer | Your suggested solution | Reviewers answer faster when they only need to agree or correct. |
| Sent to, Days allowed, Response due | The reviewer, the days your contract or Division 01 allows, and the calculated due date | A201 Section 4.2.11 asks the architect to respond with reasonable promptness; many contracts set a fixed number of days. |
| Date answered, Answer summary, Status | When and what came back | A closed RFI is part of the project record; keep the answer short and searchable. |
| Ball in court, Days open, Flag | Who has it, how long it has been out, and OVERDUE when late | A 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 started | An 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.
| RFI | Sent | Due | Days open | Ball in court | Impact | Flag |
|---|---|---|---|---|---|---|
| RFI-012 Footing depth at grid C4 | Oct 19, 2026 | Oct 26, 2026 | 4 | General contractor | cost | |
| RFI-015 Door hardware set 6 | Oct 27, 2026 | Nov 3, 2026 | 17 | Architect | TBD | OVERDUE |
| RFI-016 Duct routing at corridor 104 | Oct 29, 2026 | Nov 5, 2026 | 7 | General contractor | none | |
| RFI-017 Roof drain size | Nov 2, 2026 | Nov 9, 2026 | 11 | Engineer | TBD | OVERDUE |
| RFI-018 Fire rating at stair 2 | Nov 6, 2026 | Nov 13, 2026 | 7 | Architect | cost | |
| RFI-019 Slab edge at curtain wall | Nov 10, 2026 | Nov 17, 2026 | 3 | Engineer | schedule | |
| RFI-020 Paint finish in lobby | Nov 12, 2026 | Nov 19, 2026 | 1 | Architect | none |
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?
- 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.
- Write one question per RFI. Name the sheet, detail and spec section, and add a proposed answer. Set Days allowed from your contract.
- Log it the day it goes out. Enter the date sent and who it went to; the response due date calculates itself.
- 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.
- Close the loop. When the answer arrives, enter the date and a one-line summary, update the status and send it to the field.
- 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.