Compact Gray
For consultants and professional services
Free Excel invoice templates
Free Microsoft Excel invoice templates with built-in formulas, as .xlsx downloads. Change a quantity or a price and the line totals, subtotal, tax, and total update. For a document-style invoice, use the Word version of the same design. No signup.
- Compact Gray invoice template for Microsoft Excel
Modern Black invoice template for Microsoft ExcelModern Black
For freelancers and online services
Professional Navy invoice template for Microsoft ExcelProfessional Navy
For lawyers and advisors
Vibrant Base invoice template for Microsoft ExcelVibrant Base
For marketing and event management
Bauhaus Special invoice template for Microsoft ExcelBauhaus Special
For designers and art directors
Minimal White invoice template for Microsoft ExcelMinimal White
For digital products and creative work
Mono Style invoice template for Microsoft ExcelMono Style
For coaches and educators
Classic Blue invoice template for Microsoft ExcelClassic Blue
For trades and service jobs
Bold Green invoice template for Microsoft ExcelBold Green
For shops and landscaping
Two Tables invoice template for Microsoft ExcelTwo Tables
For mechanics and plumbers
Signature Studio invoice template for Microsoft ExcelSignature Studio
For photographers and web designers
Modern Boutique invoice template for Microsoft ExcelModern Boutique
For writers and creators
Browse by format
Same designs, different format. Pick whichever fits your workflow.
- Google DocsOpen and customize in Google Docs
- Google SheetsAuto-calculating invoices in Google Sheets
- Microsoft WordDownload .docx and edit in Word
- Microsoft ExcelDownload .xlsx with built-in formulasYou are here
Why use an Excel invoice template?
Excel is the right choice when you want the totals calculated for you and already use Microsoft Office. Every template above has formulas for the line totals, subtotal, tax, and total. You enter quantities and prices, Excel does the arithmetic.
- Built-in formulas
Line totals, subtotal, tax, and total update as you type.
- Reads like an invoice
Gridlines are hidden and borders sit only where an invoice needs them, so the PDF looks like a document, not a spreadsheet.
- Direct .xlsx download
Opens in Excel for Windows and Mac, LibreOffice, Apple Numbers, and Google Sheets.
- Duplicate per client
Use Save As for the next invoice, or duplicate the sheet to keep all invoices in one workbook.
- Save as PDF
Set the print area, then File > Save As > PDF. Every design fits the page width.
What's inside each template
Your details and your client's
Business name, address, and contact details for both parties.
Invoice number, issue date, due date
A sequential number, the issue date, and a due date, for example 14 or 30 days later.
Line items
Description, quantity, unit price, and amount per item.
Subtotal, discounts, tax, and grand total
Calculated automatically in the Excel and Google Sheets versions, by hand in Word and Google Docs.
Payment details and terms
Bank details such as IBAN and BIC, accepted payment methods, and payment terms.
Notes and optional fields
PO number, project name, and any custom terms or thank-you note.
How to use the invoice template in Microsoft Excel
Download the .xlsx template
Click Download Excel on any template card above. Open the .xlsx file in Microsoft Excel, LibreOffice, or Apple Numbers.
Add your business info and logo
Replace the sample business name and address in the header cells. Use Insert > Pictures to put your logo in place of the sample one.
Fill in the line items
Enter a description, quantity, and unit price for each line. The amount column multiplies them. To add a line, insert a row between two item rows (right-click the row number, then Insert) and copy the amount formula from the row above. The subtotal includes the new row automatically.
Set the tax rate
The rate sits in the label of the tax line, for example VAT (20%). Change the number in the brackets and the tax and total recalculate. Some designs have a tax column instead, where you enter the rate per line.
Save as PDF and send
Set the print area first: select the invoice cells, then Page Layout > Print Area > Set Print Area. Then File > Save As and choose PDF as the file format. Email the PDF to your client and keep the .xlsx for later changes.
Let Claude or ChatGPT fill in a template
The free invoice skill fills any of these 12 designs from a short description. It asks for the details an EU invoice needs, such as the service date and VAT IDs, and can turn the PDF into a ZUGFeRD e-invoice.
Excel vs Google Sheets for invoicing
Excel and Google Sheets both calculate invoice totals for you. The difference is where the file lives and how you work on it with others.
| Feature | Excel | Sheets |
|---|---|---|
| Where it lives | An .xlsx file on your device | In your Google Drive |
| Works offline | Yes | With Drive offline mode |
| Real-time collaboration | Limited (needs OneDrive) | Built in, free |
| Cost | Needs Microsoft Office | Free with a Google account |
| Formula library | All Excel functions plus macros | Most Excel functions plus Apps Script |
| Best for | Existing Excel workflows | Teams that work in the browser |
Frequently asked questions
Does Microsoft Excel have a free invoice template?
Excel's built-in gallery has a few invoice templates. The free templates above come in 12 designs, with all the standard fields and formulas for the subtotal, tax, and total. Free .xlsx download, no signup.
How do I create an invoice in Excel?
Download an Excel invoice template above, open the .xlsx file, and replace the sample business and client details. Fill in the line items, check the tax rate, then save the invoice as a PDF and email it to your client.
How do I add my logo to an Excel invoice?
Click the sample logo and delete it. Then go to Insert > Pictures, pick your logo file, and drag the corner handles to size it.
How do I add VAT or sales tax to an Excel invoice?
Most designs read the rate from the label of the tax line, for example VAT (20%) or Tax (10%). Change the number and the tax amount and total update. Designs with a tax column take the rate per line. The formula needs Excel for Microsoft 365, Excel 2024, or Excel for the web. In older versions the tax cell shows an error, so enter the tax amount by hand there.
How do I save an Excel invoice as PDF?
Set the print area first: select the invoice cells, then Page Layout > Print Area > Set Print Area. Then File > Save As and choose PDF as the file format. With the print area set, the PDF contains only the invoice, without empty cells around it.
Can I use the same Excel invoice template in Google Sheets?
Use the Google Sheets version of the same design instead. It has the same layout with its own formulas and opens with one click on Make a copy. Uploading the .xlsx to Drive also works, but check the tax cell afterwards.
How do I add more line items to my Excel invoice?
Right-click the row number of a line item and choose Insert. Excel adds an empty row, and the subtotal includes it. Copy the amount formula from the row above into the new row, or drag the fill handle down.
What about the invoices I receive?
A template covers the invoices you send. For the ones you receive, there's Billpal. It imports invoices and receipts from your email, takes photos of paper receipts via WhatsApp, and exports everything for your accounting software.
Collect invoices for your books.
Billpal collects invoices and receipts from where they already arrive and turns them into structured, categorized data for your accountant.
- 7-day free trial, 50 documents
- No credit card required
- Cancel anytime