Free, no accountNo watermarkYour details stay in this browser
Get the free 7-Day Earn More Plan
One short email a day for 7 days, then one earning idea a week. Free, and you can unsubscribe anytime.
FinanceWrite may earn a commission when you open an account through these links. The tools stay free. Disclosure
How to use the invoice spreadsheet in Google Sheets
The .xlsx file has formulas that multiply quantity by rate, add tax and total the invoice. To use it in Google Sheets, upload it to Google Drive and open it with Google Sheets, or choose File, then Import, then Upload. It is a standard Excel file we made, not a Google-hosted sheet.
The CSV button above exports whatever you typed into the form, which is handy if you track invoices in a sheet of your own.
What to include
- A running invoice number and the invoice date.
- Your details and the client details.
- One row per line item with quantity and rate.
- A tax rate if you charge tax, and the total due.
- A due date and payment instructions.
Common mistakes
- Overwriting formula cells, which breaks the totals. Type only in the input cells.
- Sharing the editable sheet instead of a PDF.
- Keeping every invoice in one tab with no numbering.
Questions people ask
How do I use an .xlsx invoice in Google Sheets?
Upload it to Google Drive and open it with Google Sheets, or use File, then Import, then Upload from inside Sheets.
Do the formulas work in Google Sheets?
The template uses plain multiplication and addition, which Sheets handles. Check the totals once after you open it.
Can I send the spreadsheet to a client?
You can, but a PDF is safer. In Sheets use File, then Download, then PDF.
What does the CSV export contain?
The invoice number, dates, names, each line item and the totals, as plain rows you can open in any spreadsheet.
More free tools
See all free tools or try one of these next.
- Get paidInvoice generator
Make a clean invoice with totals, tax and a deposit, then download a PDF.
- Get paidGoogle Docs invoice template
A free invoice template you can open in Google Docs, or fill in online.
- Get paidEstimate generator
Quote a job with a deposit, then turn it into an invoice with one click.