Windows & Doors Estimate Template — Excel & Google Sheets — Price Replacements Per Opening
STOP pricing window jobs window-by-window on the back of a business card.
Count the openings once — get a costed estimate with units, trim, foam and
labor per opening, a client-ready quote that hides your margin, and a
signed change order when the count changes. Built for replacement pros.
⭐ HOW IT WORKS
1. Setup — your business info, tax rate, profit margin, waste % (set once)
2. Rooms — log each room and opening; quantities roll up automatically
3. Estimate — add line items or copy from the built-in Item Library: vinyl
double-hungs, casements, picture windows, patio and entry doors, trim,
casing, flashing tape, sill pans, locksets and per-opening labor.
4. Quote — fills itself: margin added silently (clients never see your costs),
discount and deposit lines included. Print or save as PDF.
5. Change Order — two more windows, a door swap? Document and price it
with signatures before you order a single unit.
⭐ WHAT'S INSIDE
(1 Excel .xlsx file, 9 tabs)
- Estimate sheet — line items by category, priced per opening
- Item Library — 20 window & door lines with typical costs: vinyl
double-hung, casement and picture windows, 6 ft sliding patio door,
fiberglass entry door, storm door, pre-hung interior doors, exterior
trim and interior casing, flashing tape, sill pans, door hardware,
Low-E + argon upgrade, install labor per opening, disposal, permit
- Example project — a fully priced 12-window whole-house vinyl
replacement (about $14,000–$15,500 with 20% profit + tax)
- Quote sheet — print-ready: discount line, deposit split, timeline,
Included / Not-included scope block, signatures, tax on/off toggle
- Change Order form — price and sign every scope change
- Bid Summary — your costs, profit dollars, and margin (contractor eyes only)
- Start Here guide + Setup + Openings sheets
⭐ MADE FOR
Window & door replacement contractors • remodelers • handymen who
install doors • GCs • anyone who prices jobs by the opening
⭐ WORKS IN
Microsoft Excel AND Google Sheets (upload to Drive → Open with Google Sheets).
All formulas open — nothing locked. You only type in the yellow cells.
⭐ PAIRS WITH
Our Siding estimate template — openings and walls priced in the same
system, with matching tools.
⭐ INSTANT DOWNLOAD
No physical item will be shipped. For the purchaser's business use; resale
or redistribution prohibited.
❓ FAQ
Q: Will the client see my costs or margin? — No. The Quote shows client prices only.
Q: Can I change the currency? — Yes, one cell in Setup changes the symbol everywhere.
Q: Does it handle sales tax? — Yes: set your rate and toggle it on/off per quote.
Q: I'm not good with spreadsheets — is this for me? — Yes. You only type into
the yellow cells; everything else is automatic, and the example project shows the flow.
Q: How do I send the quote? — Open the Quote tab → File → Download/Export as PDF.