Excel quotations are quick, flexible, and require no special software. If you’re already using Excel, building a quotation template is a natural next step. Learn how to set up formulas, create a professional layout, and protect your template from errors.
Setting Up Your Excel Quotation Sheet
Start with a blank Excel workbook. Add your company name at the top in a larger font, like size 18 or 20. Below that, add your address, phone, and email in smaller font. Leave white space to keep it clean. On the right side, add a “QUOTATION” header in bold. Below it, add fields for Quote Number, Date, and Expiration Date.
Next, create a section for client details with labels like “Bill To:” followed by space for the client name, company, and address. Align this section left so it looks like a standard business document. Use consistent spacing and font choices throughout.
Below the client section, create a table for line items with column headers: Description, Quantity, Unit Price, and Total. This layout is clear and standard. Clients expect to see line items organized this way.
Adding Formulas for Automatic Calculations
In the Total column, multiply Quantity by Unit Price using a formula. For example, if Quantity is in B3 and Unit Price is in C3, write =B3*C3 in D3. Copy this formula down for all line items. Excel automatically calculates the total for each service.
Below your line items, add a Subtotal row. Use =SUM(D3:D15) or adjust the range to match your line items. Add a Tax row that calculates tax as a percentage of the subtotal. Use a formula like =E16*0.08 if your tax rate is 8% and the subtotal is in E16. Finally, add a Total Due row that sums subtotal and tax using =E16+E17 or the appropriate cell references.
These formulas save time and eliminate math errors. When you change a price or quantity, totals update automatically.
Formatting for Professionalism
Use consistent fonts throughout. Arial or Calibri work well for business documents. Use font sizes strategically: larger for your company name, smaller for section headers, and smallest for body text. Use bold for headers and important labels.
Add borders to your line item table to make it stand out. Select the table area and use the Border tool. Add subtle shading to header rows with light gray fill. This clarifies the structure without looking cluttered. Align text consistently: headers left-aligned, numbers right-aligned.
Leave adequate white space. A crowded quotation looks unprofessional. Use generous margins and line spacing. Aim for quotations that fit on one page. If yours runs over, cut unnecessary sections or use smaller font for body text only.
Protecting Your Template
Once your template is complete, protect it to prevent accidental changes. On Windows, go to the Review tab and click Protect Sheet. On Mac, go to Tools and then Protect Sheet. You’ll be asked which cells users can edit. Leave cells for client name, services, and prices unlocked while locking formula cells and header cells.
This way, someone can fill in client data without accidentally deleting a formula. If they try to edit a protected cell, Excel will prompt them to unprotect the sheet first. This simple safeguard prevents errors.
Common Excel Quotation Mistakes
Never merge cells in your line item table. Merged cells break formulas and make copying down difficult. Keep cells separate and aligned visually instead. Avoid hiding columns or rows, as clients may wonder what information you’re hiding. Stay transparent.
Don’t use formulas that reference other sheets unless necessary. Keep everything on one sheet so the quotation is self-contained. Avoid color combinations that are hard to print. Some color backgrounds look bright on screen but print poorly. Test print your quotation before sending it to clients.
When Excel Quotations Fall Short
Excel quotations work for simple service lists but have limitations. Excel doesn’t track when clients open quotations, so you don’t know if they’ve read it. It doesn’t convert quotations to invoices. You manually recreate the data in an invoice sheet, risking errors.
Excel also doesn’t integrate with accounting software. You enter data twice: once in Excel and again in your accounting system. As you send more quotations, this manual process becomes unsustainable. For high-volume freelancers, tools like Waco3 add tracking, one-click invoice conversion, and automatic accounting sync.
Saving and Sharing Your Quotation
Once complete, save the quotation with a specific file name like “Quotation-ClientName-2026-05-28.xlsx”. Then export it as a PDF before sending to clients. Go to File, Export As, then PDF. The PDF version locks the formatting and prevents accidental changes. Email the PDF to the client, not the Excel file.
Keep the Excel version on your computer as your record. Update it with the client’s response status in a separate column if you track quotation status. Excel quotations are an excellent starting point for freelancers. With proper formulas and formatting, they look professional and work reliably. As you grow, you’ll naturally move to dedicated quotation tools.
Ready to send stronger proposals?
Build, send, and track proposals in one place so follow-up is easier.
Start your free trial →
