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 with GST: 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 · 6 reviews on G2 · Our quotation generator is used by 50,000+ people · Updated October 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.
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
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
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
Quotation Format in Excel with GST (India)
The GST quotation format in Excel adds your GSTIN, the client's GSTIN, the place of supply and an HSN/SAC column to every line. Enter the taxable value and the GST rate per line, and the sheet works out the tax for you.
The Supply type cell decides how GST is split. Choose Intra-state for a client in your own state and each line shows CGST and SGST at half the rate each. Choose Inter-state for a client in another state and the full rate moves to the IGST column. The totals add up taxable value, CGST, SGST and IGST into the grand total.
The formulas are simple to check: CGST and SGST each = taxable value x GST rate / 2 when the supply is intra-state; IGST = taxable value x GST rate when it is inter-state. For HSN summaries and more detail, see the full GST quotation format guide.
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 quotation formats for India; they handle HSN/SAC and the tax split.
- More Excel layouts with formulas: the price quotation format (itemized and rate list) and service quotation formats (hourly, retainer and AMC).
- 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.
How do I add GST to a quotation in Excel?
Use the GST quotation format: enter the HSN/SAC code, taxable value and GST rate on each line, then set Supply type to Intra-state or Inter-state. The CGST, SGST or IGST columns and the grand total calculate automatically.
What is the GST formula in Excel?
GST = taxable value x GST rate. For a sale within your state, split it equally: CGST = SGST = taxable value x rate / 2. For a sale to another state, IGST = taxable value x rate.
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.