Business Quote Template in Excel: Format and Download

Most freelancers build every quote from scratch. That’s 45 minutes of column widths and formula debugging you’re not billing for. Set the template up once with working formulas, and the next 50 quotes take ten minutes each.

Why Excel Works for Quotes

A calculator does math. Excel does your math, in the exact layout you set up, with every number flowing from every other automatically. Change a unit price and the subtotal, tax, and grand total all update without you touching them. That’s the part that saves time.

Excel also doubles as a simple quote archive. Save each file as Quote-[Client]-[Number].xlsx, and six months later you can open any of them, see exactly what you quoted and why, and duplicate it for a similar project. No app subscription, no cloud login. Just files.

The Ideal Layout Structure

To create a professional and clean business quote in Excel, you need a structured layout that fits neatly on a single page when exported to PDF. Below is the blueprint of a standard quote sheet, mapped out by rows and columns:

Row Range	Section	Details & Elements
Rows 1–6	Header Block	Company Name (large, bold), Contact Details (email, phone, address, website), and Logo placeholder in Column A or F.
Rows 8–12	Client Details (Left)	“Bill To:” block containing Client Name, Company Name, Address, and Email.
Rows 8–12	Quote Metadata (Right)	Quote Number (e.g., Q-2026-001), Quote Date, and Expiration Date (e.g., “Valid until June 30, 2026”).
Rows 14	Table Headers	Column headers: Item, Description, Qty, Unit, Unit Price, and Total.
Rows 15–29	Itemized Table	15 rows for project line items. Formulas in the Total column automatically multiply quantity by price.
Rows 31–35	Totals Section (Right)	Subtotal, Discount, Taxable Amount, Tax Rate, and Grand Total.
Rows 37–42	Footer & Signatures	Terms and Conditions, Payment Instructions (bank transfer details), and Signature sign-off line.

Copy-Pasteable Excel Formulas

To ensure your calculations are error-free, you must write clean, standardized formulas. Here are the core formulas you should copy and paste into your template.

1. Line Item Total

Enter this formula in the first data row of your Total column (for example, cell F15). It multiplies Quantity (cell C15) by Unit Price (cell E15).

2. Pricing Subtotal

Sum up the line item totals. This formula adds up the entire range of your itemized totals (from F15 to F29).

3. Discount Calculations (Optional)

If you offer discounts, use this formula to calculate the discount amount. It multiplies the Subtotal (cell F31) by your Discount Percentage (for example, defined in cell F32 as 0.10 for 10%).

4. Taxable Amount

To apply tax correctly, subtract any discount from your subtotal. This ensures you only calculate tax on the final net pricing.

5. Sales Tax Amount

Multiply the Taxable Amount (cell F34) by your Tax Rate percentage (for example, entered in cell E35 as 8.25% or 0.0825).

6. Grand Total

Add the taxable subtotal and the calculated tax together to find the final figure your client owes.

Free Excel Quote Templates to Download

If you’d rather start from a pre-built template than build from scratch, these sources have clean, free options:

• Microsoft Office templates — search “quotation” inside Excel via File > New, or browse templates.office.com. Look for “service quotation” rather than product-focused ones — service templates already use the right column structure for freelance work.
• Vertex42 — offers several free quote templates formatted to print cleanly on one page. The “Sales Quote Template” works well for service businesses with minimal tweaking.
• Smartsheet — their free Excel quote templates include a “Service Quote” version with separate labor and materials rows. Useful if you bill by hours and expenses rather than flat-line items.

With any downloaded template: save a clean master copy first, then fill client details into a duplicate. Never work from the original.

Professional Formatting Rules

A quote represents your brand’s professionalism. If your Excel sheet looks like a default grid, it will feel cheap. Follow these strict formatting rules to achieve a high-end look:

• Remove Gridlines: Default gridlines make your quote look like a draft. Go to the View tab in Excel and uncheck Gridlines. Apply borders manually only where needed (like headers and totals).
• Use Modern Typography: Avoid outdated fonts. Use clean, modern sans-serif fonts such as Inter, Arial, or Segoe UI in 10pt for table content, and 14pt bold for headers.
• Currency Formatting: Never type currency symbols manually. Select your money columns, right-click, select Format Cells, choose Currency, and set it to your region’s setting (e.g. $#,##0.00).
• Color Harmony: Use color sparingly. Choose a dark brand color (like charcoal, deep navy, or emerald) for your table header background block, and keep row backgrounds white or a very light gray (#f9f9f9) for alternating lines.
• Alignment is Key: Left-align text descriptions, right-align numbers and prices, and center quantities or item numbers. This aligns with standard billing layout practices.

Saving and Exporting: The Right Way

Once you’ve built your perfect sheet:

1. Save as Template (.xltx): Go to File > Save As and select Excel Template (.xltx). Save it as “Master Business Quote Template”. This ensures that whenever you open it, you get a clean slate without overwrite risks.
2. Export to PDF for Clients: Never send raw .xlsx files to clients. They can accidentally break formulas, or view it on a device that doesn’t have the same fonts. Go to File > Save As and choose PDF (.pdf), or use Export > Create PDF/XPS. Verify that the document fits perfectly on one page before sending.

Excel’s power lies in automation. Once you lock down your template, you only update client details and quantities — Excel handles the calculations instantly, keeping your quoting process fast and professional.

When to Move Beyond Excel

While Excel is an excellent starting point, manual document preparation introduces friction as your business grows:

• Zero Interaction Tracking: You cannot see if a client has opened, forwarded, or ignored your PDF quote.
• Workflow Disconnection: You must manually convert approved quotes into invoices, copy-pasting numbers back and forth.
• No Integrated Signatures: Clients have to print, sign, scan, or use a separate e-signature tool to approve your quote.

Waco3 solves this by replacing manual spreadsheets with smart, interactive web proposals. Upload your pricing, send secure links, see real-time open notifications, and convert approved quotes to invoices in one click.

Ready to send stronger proposals?

Build, send, and track proposals in one place so follow-up is easier.

Start your free trial →