Excel is a solid tool for quotations that are primarily pricing tables. It does the math automatically, formats numbers cleanly, and exports to PDF in two clicks. Building a reusable template takes about 20 minutes and pays off quickly once you’re sending quotes regularly.
Building the template structure
An Excel quotation template for freelancers needs these components, laid out on a single sheet:
Rows 1–5: Header block
- Your name or business name (large, bold)
- Your email, phone, and website (smaller, below)
- Client name and address (right side of header, or a separate block below)
- Document title: “Quotation”
- Quote number, date, and valid until date
Rows 7–9: Project or scope description A brief merged-cell area for a one-to-three sentence description of the project. This gives context to the line items that follow.
Rows 11–30: Itemized pricing table The core of the template. Columns:
| # | Item | Description | Qty | Unit | Rate | Total |
|---|
The Total column formula: =F12*E12 (rate × qty). Lock the column letters with absolute references if you’ll copy formulas across rows.
Rows 32–36: Totals block
- Subtotal:
=SUM(G12:G30) - Discount (if applicable):
=subtotal*discount_rate - Tax:
=subtotal*tax_rate - Total:
=subtotal-discount+tax
Name the tax_rate cell: select it > Formulas > Define Name > “tax_rate”. Then your tax formula reads =subtotal*tax_rate instead of =B34*0.08, making it obvious what the formula does and easy to update.
Formula setup for calculations
Here’s the complete formula chain for a clean, maintainable template:
Line total (G12): =E12*F12
Line total (G13): =E13*F13
[continue for each row]
Subtotal (G32): =SUM(G12:G30)
Discount row (G33): =G32*discount_pct [name a cell "discount_pct"]
Taxable amount: =G32-G33
Tax (G34): =G32*tax_rate
Total (G35): =G32-G33+G34Set G32 through G35 as a named range group (“totals”) if you want to reference them consistently. Use Excel’s Name Manager (Formulas > Name Manager) to see all named ranges at a glance.
Formatting for a professional result
Remove gridlines: View > uncheck Gridlines. Gridlines read as “draft” when visible in a PDF.
Apply borders only to table cells: Select your pricing table > Home > Borders > Outside Borders for the table, then thin inside borders for rows and columns. Avoid thick inner borders — they make the table look heavy.
Color: Use one fill color for the column header row (the “Item, Description, Qty, Rate, Total” row) and one for the totals section. Match your brand color or pick a neutral dark shade.
Number formatting: Format all money cells as Currency (not Accounting — Accounting left-aligns currency symbols which looks awkward in tables). Select cells > Format Cells > Number > Currency.
Font: Calibri 10pt for body, Calibri 12pt bold for section headers. Consistent sizing makes the document readable and professional.
Name your key formula cells (tax_rate, discount_pct, subtotal) using Excel’s Name Manager. A formula that reads =subtotaltax_rate is self-documenting and takes five seconds to understand. A formula that reads =B32G4 requires investigation every time you open the file six months later.
Saving as a reusable template
Once your template is built and tested:
- File > Save As
- In the “Save as type” dropdown, select Excel Template (.xltx)
- Name it something clear: “Freelance Quotation Template 2026”
- Save location: Excel will default to a Templates folder that makes it accessible from File > New
From now on, File > New > Personal > [your template name] opens a fresh copy with all formulas intact and no prior client data.
What Excel can’t do
Excel handles the numbers well but is static once sent. A PDF quotation sent via email gives you no information about:
- Whether the client opened it
- How long they spent reviewing it
- Whether they forwarded it to a decision-maker
Following up blind — on a fixed schedule regardless of client behavior — is less effective than following up when you know the client has just reviewed the quote. Tools like Waco3 give you that signal: a real-time notification when the client opens the quote, so your follow-up is timely and relevant rather than arbitrary.
For freelancers who send occasional quotes to existing clients, Excel’s PDF approach is fine. For anyone sending quotes to new prospects regularly, the tracking layer of a dedicated tool earns its cost.
Ready to send stronger proposals?
Build, send, and track proposals in one place so follow-up is easier.
Start your free trial →
