Template·August 2026·6 min read

Free Invoice Template for Excel and Google Sheets

Four spreadsheet templates with working formulas — the total, tax and deposit calculate themselves. No email address, no signup, no watermark.

Most "free invoice template" downloads are a blank PDF or an image. You cannot type in either of them. The four templates below are real spreadsheets: you fill in the cream-shaded cells and the amounts, subtotal, tax and total due work themselves out. They open in Excel, Google Sheets, Numbers and LibreOffice.

Download — pick your trade

Every file is the same layout with line items written for that kind of work. Grab whichever is closest; you can retype the descriptions.

Each is a .xlsx file, about 8 KB. Google Sheets imports .xlsx directly — see the steps below. If you would rather have a printed form to fill in by hand, the PDF versions are on each profession's page, linked at the bottom.

Why a spreadsheet beats a PDF template

A blank PDF is the least useful thing you can hand someone who searched for an invoice template. Three things a spreadsheet does that a PDF cannot:

It adds up. Change a quantity or a rate and the line amount, subtotal, tax and total all update. No arithmetic, no transcription mistakes.
It is reusable. Save a copy per client, change three cells, send. A PDF has to be re-created every time.
It still exports a PDF. File → Download → PDF in Sheets, or File → Export in Excel. You get the sendable document at the end anyway.

How to use it in Google Sheets

1

Download the file above

It saves as an .xlsx file. You do not need Excel installed.

2

Open a blank Google Sheet

Go to sheets.new, or Google Drive → New → Google Sheets.

3

File → Import → Upload

Drop the .xlsx in, choose Replace spreadsheet, and click Import data. The formulas and formatting come across intact.

4

Fill in the cream cells

Your details, the client's details, then the line items. Leave the grey cells alone — those are the formulas.

5

File → Download → PDF

Set it to Portrait, Fit to width, and turn off gridlines and notes for a clean document.

How to use it in Excel, Numbers or LibreOffice

Double-click the file. That is the whole procedure — it is a native .xlsx, not a converted document. Numbers will ask to convert it and that is fine. In Excel, use File → Export → Create PDF/XPS when you are ready to send.

What is inside the file

One sheet, laid out the way an invoice is read from top to bottom:

  • Rows 4–9 — who to and who from. Your name, email, phone and tax number on the left; the client's company, contact and billing address on the right.
  • Rows 11–13 — the meta row. Invoice number, issue date, due date and payment terms. The due date is a formula: it is the issue date plus whatever number of days you put in "Days to pay", so changing 14 to 30 moves the due date for you.
  • Rows 16–25 — ten line items. Description, quantity, rate, amount. The amount column is =IF(B16*C16=0,"",B16*C16), which means a line with a quantity of zero stays visibly blank instead of showing a distracting 0.00.
  • Rows 27–31 — the maths. Subtotal =SUM(D16:D25), a tax rate you type, tax =D27*D28, any deposit already paid, and TOTAL DUE=D27+D29-D30.
  • Rows 33–36 — payment terms and notes, with a reminder to quote the invoice number as the payment reference.

Cream shading marks every cell you are meant to type in. Everything else is a formula and is best left alone.

Three things worth knowing before you send one

!
The issue date is =TODAY(), so it changes every time you open the file. That is handy while you are drafting and wrong once you have sent it. Before sending, type the real date over that cell — otherwise your archived copy will show today's date next year, and the due date will drift with it.
!
The tax rate cell is a percentage, so enter it as one. Typing 20% works. Typing 20 gives you two thousand percent.
!
Need more than ten lines? Right-click a row inside the 16–25 block and insert there — both Excel and Sheets will widen the subtotal range for you. If you type below row 25 instead, the subtotal will quietly ignore it. Check the total after adding rows.

When a spreadsheet stops being the right tool

Spreadsheets are excellent for a handful of invoices a month. They get awkward when you need to know which invoices are unpaid, when you are hunting for last quarter's numbers across a folder of files, or when you are retyping the same client's address for the ninth time.

That is the point at which a spreadsheet costs more time than it saves, and it is what Simple Invoice Generator is for — clients saved once and auto-filled, status tracking for draft, unpaid, paid and overdue, PDF export with your logo, and eight currencies. The free plan covers three invoices with no card required. Until you hit that point, the spreadsheet is genuinely fine, and we would rather say so.

Common questions

  • Do I have to give you an email address? No. The download is a direct link to the file. There is no gate and no follow-up sequence.
  • Is there a watermark or a logo I have to keep? No. There is one small line in the footer crediting invoicegenapp.com — delete it if you like.
  • Can I use it commercially? Yes. Invoice your clients with it, change it, rename it. It is yours.
  • Will the formulas survive the import into Google Sheets? Yes. SUM, IF and TODAY all exist in Sheets and behave identically.
  • Does it handle multiple tax rates? Not as shipped — there is one rate applied to the subtotal. For mixed rates, add a second tax row and point it at the specific lines it applies to.

Outgrown the spreadsheet?

Create, send and track invoices in the browser instead. Free for your first three, no card required.

Create an invoice free