Google Sheets Invoice Template (Free)
A free invoice you can open in Google Sheets. Add your details and line items, and the subtotal, tax and total are calculated.
Download the invoice file (.xlsx)
Free. No email or sign-up needed. Opens in Google Sheets and Excel.
What is inside the invoice template for Google Sheets
The file is a standard Excel workbook that Google Sheets opens directly.
| Sheet | What it does |
|---|---|
| Invoice | Your business and client details, invoice number and dates, line items with quantity and rate, subtotal, tax and total due. |
| Read me | Short instructions. |
Colour key: yellow cells are for your own numbers and text. Green cells calculate automatically, so leave them alone. Sample data is included so you can see how it works, and you can delete it.
How to use the invoice template for Google Sheets
- Download the .xlsx file above.
- Go to drive.google.com, click New, choose File upload and pick the file.
- Right click it and choose Open with > Google Sheets, then File > Save as Google Sheets.
- Fill in your details and line items.
- Use File > Download > PDF to send the invoice.
Frequently asked questions
How do I make an invoice in Google Sheets?
Upload this template to Google Drive, open it with Google Sheets, fill in the yellow cells and download as PDF.
Does it calculate tax?
Yes. Set the tax rate and the total updates.
Can I add my logo?
Yes. Use Insert > Image in Google Sheets.
Is it free?
Yes, with no email or sign-up.
Is there an Excel version?
This is the same Excel file. See our invoice template page for details.
Need a custom Excel template or automation built for your business?
More free tools: All free calculators · Invoice template (Excel) · Google Sheets budget template · Receipt template