Free Invoice Template for Google Sheets
Our Excel-format download opens directly in Google Sheets (File → Import → Upload), which is useful if you want your invoice line items in a shared, cloud-based spreadsheet rather than a static PDF.
Create your invoice now
Fill in your details on the left, watch it build in real time on the right, then download as a file for Google Sheets — completely free, no account needed.
| Description | Qty | Price | Tax % | Total |
|---|
Nothing you type here is uploaded anywhere — your invoice is built entirely in your browser.
Our Excel-format download opens directly in Google Sheets (File → Import → Upload), which is useful if you want your invoice line items in a shared, cloud-based spreadsheet rather than a static PDF.
Why choose this format: Google Sheets is a good fit if you’re tracking multiple invoices in one place, or want formulas that update automatically as you edit line items.
How to open this invoice in Google Sheets
- Fill in the generator and click “Download for Google Sheets” — you’ll get an .xlsx file with live formulas.
- Open Google Drive → New → File upload.
- Right-click the file → Open with → Google Sheets. The formulas keep working in Sheets.
- Edit quantities or prices and the totals update; then File → Download → PDF to send.
How the totals are calculated in Sheets
| Item | Formula used |
|---|---|
| Line amount | Quantity × price (=B12*C12) |
| Subtotal | =SUM of all line amounts |
| Tax | =SUMPRODUCT of amounts and tax % ÷ 100 |
| Discount | Percentage of subtotal, or a fixed amount |
| Total due | =MAX(0, subtotal + tax − discount + shipping) |
Use Google Sheets as an invoice tracker
Sheets is ideal for keeping a log of every invoice you send. Add a second tab with these columns:
| Invoice # | Client | Issued | Due | Amount | Status | Paid on |
|---|---|---|---|---|---|---|
| INV-0041 | Acme Retail | 01 May | 31 May | $2,400 | Paid | 28 May |
| INV-0042 | Northwind | 12 May | 11 Jun | $850 | Sent | — |
A formula like =SUMIF(F:F,"Sent",E:E) shows how much is outstanding, and conditional formatting can turn overdue rows red when the due date has passed.
Frequently asked questions
Do the formulas work in Google Sheets?
Yes. The line amounts, subtotal, tax, discount and total are standard formulas that Google Sheets supports.
Why is the file an Excel file?
Google Sheets opens Excel files directly. Uploading the .xlsx to Drive and opening it with Sheets keeps the tool free and private — no Google sign-in needed on our site.
Can I share the invoice from Google Sheets?
Yes, but for clients it’s best to download it as a PDF (File → Download → PDF) so they can’t change it.