Google Sheets invoice template

Download a spreadsheet invoice with the math built in, or fill one in online and export it as CSV.

Free, no accountNo watermarkYour details stay in this browser

Download spreadsheet template (.xlsx)
Saved in this browser only, never sent to us.Clear my saved info
Next step, with your details carried over

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.