Standard Quotation Template
Any business quoting products or services. The simple quotation format most clients expect.
- Quotation number, date and validity
- Itemized table with qty and unit price
- Discount, tax and total
- Acceptance and signature line
Microsoft Excel · .xlsx
Quotation Format in Excel: Free Templates with Formulas
Excel quotation templates that do the math: line amounts, subtotal, discount, tax and deposit calculate as you type. They also work in Google Sheets.
4.8/5 on G2 · Our quotation generator is used by 50,000+ people · Updated September 2026What is a quotation format in Excel?
A quotation format in Excel is a spreadsheet quote with the layout and formulas built in, so line totals, discount, tax and the grand total calculate automatically.
Excel is the best choice for quotes with long price lists, quantity-based pricing or tax to split. You type in the yellow cells and the formulas do the rest. The construction template totals each cost category, the service template works out the deposit, and the GST formats switch between CGST + SGST and IGST.
- Formulas calculate line amounts, discount, tax and totals
- Yellow cells are inputs; grey cells calculate on their own
- Works in Excel, Google Sheets, Numbers and LibreOffice
- Includes GST formats for India
- Free for commercial use, no email required
Download a Quotation Format in Excel
Every template below is an .xlsx file with working formulas. Prefer free-form wording? Get the same designs as a quotation format in Word.
Simple Quotation Template
A clean, one-page blank quote when you just need the essentials. Good for quick jobs and small orders.
- Description, qty, price and amount
- Subtotal, tax and total
- Validity note
- Acceptance line
Service Quotation Template
Freelancers, agencies and consultants who price by phase, by the hour or at a fixed fee.
- Phases and deliverables
- Hours x rate or fixed fee per line
- Deposit due on acceptance
- Revision and timeline terms
Freelance Quotation Template
Freelancers and solo creatives quoting a project with a deposit and optional extras.
- Deliverables with hours x rate
- Deposit due on acceptance
- Optional extras kept out of the total
- Revision and file handover terms
Sales Quotation Template
Product sellers, wholesalers and distributors quoting by SKU with discounts and shipping.
- SKU, unit and unit price
- Per-line discount %
- Shipping and tax
- Incoterms, lead time and returns terms
Construction Quotation Template
Contractors and trades quoting a job: renovation, plumbing, electrical, landscaping.
- Site address, start date and duration
- Labor, materials, equipment and permits
- Automatic subtotal per category (Excel)
- Change order and price validity terms
GST Quotation Format (India)
GST-registered businesses in India quoting to other businesses or consumers.
- Your GSTIN, state and state code
- HSN/SAC code per line item
- CGST + SGST or IGST, switched automatically (Excel)
- Amount in words and bank details
Company Letterhead Quotation
Formal quotations to companies and procurement teams, written as a business letter.
- Letterhead with company details
- Ref, subject and salutation
- Price table and totals
- "Yours faithfully" sign-off
How to Make a Quotation in Excel
1
Open and save a copy
Download the .xlsx and save a copy named after the quote.
2
Fill in the yellow cells
Your details, the client, quotation number, date, validity and currency.
3
Add line items
Description, quantity and unit price on each row; the amount appears automatically.
4
Set discount and tax
Type the percentages; tax is calculated after the discount.
The Formulas Inside the Excel Quotation Formats
| Cell | What it does | Example formula |
|---|---|---|
| Line amount | Quantity x unit price, blank if empty | =IF(OR(C14="",E14=""),"",C14*E14) |
| Subtotal | Adds every line amount | =SUM(F14:F28) |
| Tax | Tax % applied after the discount | =(F30-F32)*F33 |
| Deposit (service) | Total x deposit % | =F33*F34 |
| Category total (construction) | Adds lines in one category | =SUMIF($A$15:$A$34,"Labor",$F$15:$F$34) |
| IGST (GST India) | Full GST rate when inter-state | =IF($J$5="Inter-state",F14*G14,0) |
Tips for Quotations in Excel
- Protect the formula cells with Review > Protect Sheet after unlocking the yellow inputs.
- Keep a quote log sheet with number, client, amount, validity and status (sent, accepted, expired).
- Use the GST formats for India; they handle HSN/SAC and the tax split.
- Google Sheets users: upload the .xlsx and Open with > Google Sheets.
- Want a share link, WhatsApp sending and one-click conversion to invoice? Try the free quotation generator.
Related Templates & Free Tools
All Quotation Templates
Every quotation template in Word, Excel and PDF, plus a filled sample.
Free Quotation Generator
Skip the file: build a quote online, used by 50,000+ people.
Quotation Terms & Conditions
40+ copy-ready clauses.
GST Quotation Format
CGST, SGST and IGST formats for India.
Quotation Email Templates
Emails to send and follow up on quotes.
Taskip Quotations
Send, track and get quotes accepted online.
Quotation Format in Excel FAQs
How do I make a quotation in Excel?
Download an Excel quotation format, fill in the yellow cells, add your line items and tax, then export it as a PDF to send.
Is there a GST quotation format in Excel?
Yes. Two GST formats are included, one with an HSN summary. See the GST quotation format page for details.
Does the Excel quotation calculate tax automatically?
Yes. Enter the tax rate and it is applied after any discount.
Can I use these Excel quotation formats in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets; the formulas keep working.
Are these Excel quotation formats free?
Yes. Free for business use, no signup and no watermark.