Free Excel Estimate Template

Price the job without fixing formulas

Skip spreadsheet setup and formula work in Excel. Accurate totals keep the work and likely price easy to check, helping customers choose you for the job.

Prefer to work in Excel? Use a free XLSX template below.

Create Estimate Online

14-day free trial. No credit card required.

Create an estimate online without checking Excel formulas

Price the job. Send the estimate. Get back to work.

Download an Excel Estimate Layout for the Job

Choose Download XLSX to save a workbook. Keep a blank original and use a customer or job copy for your estimate. Create Estimate Online opens Docelf separately.

See the other six Excel layouts for purchase-order references, discounts, tax and projects.

Choose the Excel Estimate That Fits the Pricing

A good starting workbook already has the rows and summary fields your estimate needs. Choose the closest match before changing formulas or adding sections.

TemplateGood starting point for
FreeA standard itemized estimate for products, services or mixed work
SimpleA small job with a few line items and one clear total
BlankA flexible workbook when you need to change the structure
P.O. numberWork connected to a customer purchase order or reference number
DiscountAn estimate that shows the discount before the likely total
Sales taxAn estimate with space to show sales tax separately
JobLabor, materials and other costs for one job
ConstructionA project with phases, materials and site-related costs
ContractorA detailed project with scope, timing, assumptions and terms

How to Fill In an Excel Estimate

Save the downloaded XLSX under a name such as Estimate-1042-Customer.xlsx. Check its currency and formula cells before you enter the job. The illustration shows the main estimate fields; your chosen workbook may arrange them differently.

Estimate field guide showing business, logo, customer, number and dates, items, totals and terms
  1. Your Business: Enter your business name and the contact details for estimate questions.
  2. Your Logo: Add your logo without covering the business details.
  3. The Customer: Enter the customer and the job address when it differs.
  4. Number and Dates: Use a unique estimate number, an issue date and a response deadline when needed.
  5. Work and Prices: Enter numeric quantities and unit prices. Put units such as hours in the description.
  6. Estimated Total: Check line amounts, subtotal and any tax or discount formulas.
  7. Terms and Review: Explain the scope, assumptions and timing. Check the finished estimate before exporting a PDF.

Check the Excel Calculation With a Simple Estimate

A line amount is the expected quantity multiplied by its unit price. Add the line amounts for the subtotal, then include any applicable tax. Keep the units in the descriptions so the quantity cells hold numbers.

This fictional estimate covers fitting three shelves. It uses US dollars and an illustrative 8% tax on the whole subtotal. These are expected costs, not charges for work already completed.

QTY Description Unit Price Amount
6Shelf cutting and fitting — estimated hours $65.00$390.00
3Timber shelf boards — each $42.00$126.00
6Shelf brackets — each $12.00$72.00
Subtotal$588.00
Sales Tax (8% illustrative)$47.04
Estimated Total $635.04

The six labor hours account for $390.00. As a check in a spare copy, changing six hours to seven should raise the subtotal to $653.00 and the estimated total to $705.24 at this example tax rate. Restore the intended quantity before sending. Use the tax treatment that applies to your job.

Explain the Assumptions Behind the Excel Total

A formula calculates the price from the numbers you enter. The customer also needs to know what those numbers assume. Put that explanation in the estimate itself, within the area you will print or export.

Use the wording below as a starting point for the shelving example. Replace [date] and include only the timing and payment terms your business uses. In Docelf, the field is called Terms and Conditions.

Example: Terms and Conditions

  • Fit three timber shelves using six brackets, based on an estimated six hours of cutting and installation.
  • Price assumes suitable existing walls. Wall repairs and painting are not included.
  • Please respond by [date]. We will confirm the installation date with you.
  • We will discuss any additional work and agree on its price before proceeding.
Create an estimate online without checking Excel formulas

Use the Job Details Without Building a Workbook

Enter the quantities and prices in Docelf, and it calculates the line amounts and total. Reuse saved customers and items for the next job. Review the estimate, then email it or download a PDF.

Create Free Estimate

Keep the Workbook Useful as the Job Changes

Excel is a practical choice for several rates or repeated calculations. Keep your internal costing notes separate from the estimate you send; the customer needs to understand the work and likely price, not your margin calculations.

Check Each Added Row

Insert new items within the item area and copy the neighboring formula and formatting where needed. Confirm that the copied amount uses the new row’s quantity and price, and that the subtotal includes it. Avoid typing a replacement number over a formula.

Save the Version You Sent

Keep the checked PDF with its working XLSX. If the scope changes, save a revised copy and identify the revision in the filename and your message. That makes it easier to see which estimate the customer accepted.

Print the Estimate, Not the Whole Workbook

In desktop Excel for Windows, select the estimate cells and choose Page Layout, Print Area, then Set Print Area. Include the business details, every item, the estimated total and the terms.

Preview before you print or export a PDF. Check the right-hand amounts, the last item row and any text carried onto a second page. Open the exported file once more so you can send the version you have checked.

More Excel Estimate Layouts

Choose the layout that leaves room for your job details. Each preview below keeps its own XLSX download.

Need a general work layout? Excel Work Estimate Template is also available.

Keep the Customer’s Response With the Estimate

For an estimate sent from Excel, keep the reply with the PDF it refers to. If the customer asks for a change, update the workbook and send a revised estimate with a short explanation.

If you create the estimate in Docelf, you can email it and see when it is delivered or opened. Customers can accept or decline online, and Docelf emails you when they respond.

Choose Another Estimate Format

Choose Google Sheets for shared spreadsheet editing, or use Word or Google Docs when wording and page layout matter most.

Excel Estimate Template FAQs

Ready to Price the Job Without Fixing Formulas?

Create an estimate online without checking Excel formulas

Keep future estimates with your other business documents in Docelf.

  • Reuse saved customer and item details
  • Calculate line amounts, tax and totals automatically
  • Email the estimate or download a PDF
Create Estimate Online

Free Templates from Docelf

Create free business documents like invoices, estimates, quotes and receipts from these blank, printable and downloadable templates

Try Docelf Free for 14 Days

Docelf

Create and send unlimited documents. Every feature is included.

Create and send unlimited documents.

Every feature is included.

Start Free Trial

No credit card required.

After 14 days, continue for $12.99/month only if you choose to upgrade.