GST Invoice Format in Excel | Free Download Sample

Download free GST invoice format in Excel

This page gives you a free GST invoice format in Excel-friendly CSV. You can open the file in Microsoft Excel, Google Sheets, Apple Numbers or any spreadsheet tool. It includes sample supplier details, buyer details, GSTIN, invoice number, place of supply, HSN/SAC, taxable value, GST rate, CGST, SGST, IGST and grand total.

The download is useful when you want a quick sample GST invoice Excel format. For repeated billing, PDF sharing, invoice numbering, client records and payment tracking, use the online GST invoice generator instead of maintaining manual spreadsheet files.

Download GST invoice Excel sample

GST invoice Excel columns

Description

Name the product or service being billed.

HSN/SAC

Use HSN for goods and SAC for services.

Qty

Number of units, hours, packages or service count.

Rate

Price per unit before GST.

Taxable Value

Quantity multiplied by rate, after any discount.

GST Rate

Tax rate such as 5%, 12%, 18% or 28%.

CGST / SGST / IGST

Tax breakup based on supply type.

Line Total

Taxable value plus applicable GST.

Sample GST invoice Excel table

Description	HSN/SAC	Qty	Rate	Taxable	GST	CGST	SGST	Total
Website development	998314	1	40,000	40,000	18%	3,600	3,600	47,200
Monthly support	998313	1	8,000	8,000	18%	720	720	9,440
Setup fee	998315	1	2,000	2,000	18%	180	180	2,360

GST invoice Excel formulas

If you build your own Excel template, keep formulas simple and visible. The exact GST split depends on supply type, but these formula ideas are useful for most sample formats.

Taxable Value

= Quantity * Rate

GST Amount

= Taxable Value * GST Rate

CGST

= GST Amount / 2 for same-state supply

SGST

= GST Amount / 2 for same-state supply

IGST

= GST Amount for inter-state supply

Line Total

= Taxable Value + CGST + SGST + IGST

Excel vs online GST invoice generator

Excel is familiar and flexible, but it creates manual work. Formulas can break, invoice numbers can repeat, print layout can shift and old files can get copied with wrong customer details. An online GST invoice generator is better when you need repeatable invoices, PDF output, client records and payment tracking.

Use Excel for one-off sample formats.

Use InvoiceWala for customer-ready GST invoice PDFs.

Use Excel only after checking formulas and tax split.

Use InvoiceWala when invoice numbers and records matter.

GST invoice format in Excel FAQs

Can I download GST invoice format in Excel?

Yes. This page includes a free spreadsheet-friendly CSV sample that opens in Excel, Google Sheets and Numbers.

What columns should a GST invoice Excel format include?

Useful columns include description, HSN/SAC, quantity, rate, taxable value, GST rate, CGST, SGST, IGST and line total.

Is CSV the same as Excel?

CSV is a spreadsheet format that opens in Excel. It is simpler than XLSX but useful for a clean downloadable invoice sample.

What formula calculates GST in Excel?

For exclusive GST, GST Amount = Taxable Value x GST Rate. Line Total = Taxable Value + GST Amount.

How do I split CGST and SGST in Excel?

For same-state supply, CGST and SGST are commonly half of total GST each. Example: 18% GST becomes 9% CGST and 9% SGST.

When should I use IGST?

IGST is generally used for inter-state supplies where seller and buyer are in different states. Confirm exact treatment with your accountant.

Can I use Excel for GST invoices?

Yes, but manual Excel invoices can lead to formula, numbering and PDF layout mistakes. For repeated billing, an online GST invoice generator is safer.

Can I convert this Excel format to PDF?

Yes. You can print or export the spreadsheet to PDF, or use InvoiceWala to create a cleaner PDF invoice online.