Why a photo log matters more than the photos
Every superintendent takes hundreds of photos a month. The problem is almost never too few photos. The problem is finding the right one eighteen months later, when the owner's attorney says the conduit was never installed before the ceiling went up, or the neighbor says your pile driver cracked their wall. A camera roll with 11,000 unlabeled pictures is not documentation. A construction photo log is: each photo has a number, a date, a location, the direction you were facing, what it shows, and which RFI, change order or punch item it backs up.
The free Excel template above gives you that index, plus a printable photo sheet with two framed photos per page for owner reports, pay-app backup and claim packages. Type a photo number above each box and the caption, date, location and file name fill in from the log.
What goes in each column
| Column | What to enter |
|---|---|
| Photo # | A sequential number for the job. Never reuse a number. It also goes in the file name. |
| Date / Time | When the photo was taken — from the phone's metadata, not the day you uploaded it. |
| Area / Location | Level, room, area or site feature: "Level 1 – Corridor 110", "North lot duct bank". |
| Grid / Station / Elev. | Grid lines, station, or elevation so the photo can be placed on the drawings. |
| Direction Faced | Dropdown: N, NE, E, SE, S, SW, W, NW, Up (overhead), Down (floor or slab). |
| Category | Progress, Pre-Cover / Concealed, Existing Condition, Deficiency / Punch, Delivery / Material, Damage, Weather / Site, Safety, Inspection, As-Built. |
| Description | What it shows and why it matters. "Duct conflicts with tray at D/4 — neither can install as drawn" beats "ductwork". |
| Taken By | The person who can testify to when and where the photo was taken. |
| File Name / Link | The renamed file or a link to SharePoint, Google Drive, Box or your project platform. Highlights red when a logged photo has no link. |
| Related RFI / CO / Punch # | The document this photo supports. Filter this column to build an RFI or change-order package in seconds. |
A summary block at the top counts photos logged, the most recent photo date, pre-cover photos, deficiency photos, photos tied to an RFI/CO/punch item, and photos still missing a file link.
The photos that win arguments
1. Before it gets covered
In-wall and above-ceiling rough-in, underground and under-slab utilities, rebar and embeds before the pour, firestopping, insulation, waterproofing, grounding and bonding. Once drywall or concrete goes on, the photo is the only proof the work was done right. On a claim, "pre-cover" photos are the most valuable pictures you have. Take a wide shot for context, then close-ups with a tape measure in the frame.
2. Existing conditions before you start
Walk the site, the access route and the neighbors before mobilization: curbs, sidewalks, paving, adjacent building walls, landscaping, finished spaces in a renovation. Pre-existing damage you didn't photograph becomes damage you caused. For work near adjacent structures, a dated photo with a crack gauge in the frame is worth more than any pre-con survey narrative.
3. Deliveries
Photograph material on the truck and at the tailgate, before anyone signs the bill of lading — especially switchgear, transformers, AHUs, glazing and anything crated. Carriers deny freight claims that weren't noted at delivery.
4. Problems and conflicts
Every RFI and most change orders start with a photo. Conflicts between trades, work by others out of tolerance, areas not ready for your crew, and stop-work conditions all belong in the log with the RFI or CO number next to them.
5. Weather and site conditions
Standing water in an excavation, mud, snow and frozen ground on days you lose production. Pair them with a weather & delay log — photos plus daily weather records plus NOAA data is the package that gets time extensions approved.
6. Weekly progress from fixed points
Pick four to eight vantage points and shoot them from the same spot, in the same direction, every week. Side-by-side weekly photos are the clearest schedule record there is, and owners love them in monthly reports.
How to take a photo that holds up
- Leave the metadata alone. Keep date/time and location services on. Never edit, crop or re-save the original — make a copy for markups.
- Add scale. A tape measure, hard hat, crack gauge or person in the frame turns "it was small" into a measurement.
- Include a fixed reference. A column tag, grid marker, room number or door lets anyone locate the photo on the drawings.
- Log the direction. "Looking north at grid C" makes the photo useful to someone who wasn't there.
- Upload daily. Photos that live only on a phone disappear with the phone.
- Use a naming rule. The template uses
YYYY-MM-DD_###_Area_Direction.jpg. Sorted by name, the files line up by date and match the log.
Using the printable photo sheet
The Photo Sheet tab has twelve framed boxes, two per printed page. For each box, type a photo number in the yellow cell; the date, direction, area and grid, photographer, caption, related item and file name pull from the Photo Log with INDEX/MATCH. Then insert the picture (Insert → Pictures → Place over cells) and drag it to fit the frame. It's built for the things supers actually get asked for: photo pages in the monthly owner report, backup for a pay application or T&M ticket, and the exhibit pages in a change-order or claim package.
Common photo-documentation mistakes
- No pre-cover photos. The day drywall starts is the day you lose the chance forever.
- Only close-ups. A close-up of a crack with no context can't be placed. Always take the wide shot first.
- Photos on personal phones only. When a foreman leaves the company, his photos leave with him.
- No link to the issue. A photo that supports RFI-027 but isn't tagged to it won't be found when RFI-027 turns into a change order.
- Editing originals. Cropping or marking up the original file wipes or changes metadata and invites a challenge. Mark up copies.
Related templates
- Daily field report template — reference photo numbers in each day's report
- Punch list template — the Photo / Ref column links back to this log
- RFI template — attach logged photos to the question
- Change order template — photo backup for extra work
- Weather & delay log — pair weather photos with daily weather records
- Browse all free construction templates
When the spreadsheet stops keeping up
A spreadsheet photo log works until the job produces more photos than anyone has time to rename and index. Field PM attaches photos straight from the phone to the daily report, RFI, change order or punch item they belong to — with the date, project and author captured automatically — so the log builds itself. Start a free 30-day trial — no credit card required.
