Free Excel templates

Spreadsheet templates for budgets, invoices, payroll, projects, school and home, each built with real formulas, dropdown lists and colour highlights rather than pictures of a table. Fill one in right here in your browser and watch the totals update, then download it as an .xlsx file that opens in Excel, Google Sheets, Numbers or LibreOffice.

Templates

Monthly budget (Excel spreadsheet): A monthly budget spreadsheet: plan each category, log transactions, and see planned vs actual, what is left and your savings rate, all calculated.
Invoice (Excel) (Excel spreadsheet): An auto-calculating invoice in Excel: line items, subtotal, discount, tax, total, amount paid and balance due, laid out to print on one page.
Employee attendance sheet (Excel spreadsheet): A monthly employee attendance sheet in Excel: mark present, absent, leave, half day or holiday, with automatic totals and attendance %.
Weekly timesheet (Excel spreadsheet): A weekly timesheet template: start, finish and break times give daily hours, regular and overtime hours, and total pay.
Gantt chart (Excel spreadsheet): A Gantt chart template for Excel: tasks with start dates and durations draw their own bars across an 8-week timeline, shaded by progress, with a today line.
GST invoice format (Excel) (Excel spreadsheet): A GST tax invoice format in Excel with GSTIN, HSN/SAC, place of supply and automatic CGST and SGST, or IGST for inter-state supplies.
Work schedule (staff rota) (Excel spreadsheet): A weekly employee work schedule and staff rota: pick a shift per person per day, colour-coded, with hours per person and staff per shift.
Project tracker (Excel spreadsheet): A project task tracker with owners, priority and status dropdowns, due dates that turn red when late, and a progress summary.
Yearly calendar (Excel spreadsheet): A printable yearly calendar for Excel that works for any year: change the year and all 12 months redraw, with weeks starting on Monday.
Expense report (Excel spreadsheet): An expense report template for claims: dated expenses by category, totals per category, missing receipts flagged and the amount to reimburse.
Profit and loss statement (Excel spreadsheet): A 12-month profit and loss statement (P&L) template: revenue, cost of sales, gross profit, operating expenses, net profit and margins.
Inventory and stock register (Excel spreadsheet): An inventory spreadsheet and stock register: opening stock, stock in and out, on-hand quantity, stock value and a reorder flag that turns red.
Salary sheet (Excel spreadsheet): A monthly salary sheet format in Excel: basic, HRA and allowances, paid days, PF, ESI, professional tax, TDS and net pay for each employee.
Loan amortization schedule (Excel spreadsheet): A loan amortization schedule in Excel: enter amount, rate and term to get the payment and a full schedule of interest, principal and balance, with extra payments.
To-do list (Excel spreadsheet): A to-do list spreadsheet with priorities, due dates, lists and a done tick: finished tasks fade and overdue ones turn red.

How to use these templates

Pick a template by the job: a budget for money at home, an invoice or quotation to bill a client, a timesheet or attendance sheet for staff, a Gantt chart or tracker for a project.
Open it and type straight into the grid. Shaded cells are inputs; cells with formulas work themselves out, and hovering over one shows the formula.
Replace the sample rows and anything in [brackets] with your own details, and use the dropdowns for statuses, categories and shift codes so the totals count them.
Download the .xlsx. In Google Sheets, choose File, then Import, and upload it; formulas, dropdowns and colours come with it.

Getting the most from a spreadsheet template

Keep one row per item, whether that is a transaction, a task or an employee. Formulas such as SUMIFS and COUNTIF rely on tidy rows and break when two things share a line.
Add new rows inside the table, above its total, so the total range grows with it. Rows added below the total are not counted.
Use the dropdowns rather than typing. "Paid" and "paid " look the same to you but not to a formula.
Amounts have no currency symbol, so the same file works in dollars, pounds, euros or rupees. Apply your own currency format in Excel if you want the sign shown.
Before printing, use Print Preview: each template is set to fit the page width, and landscape where the sheet is wide.

Frequently asked questions

Are these Excel templates free?

Yes. Every template is free to fill in and download, for personal or business use, with no sign-up and no watermark.

Do the templates work in Google Sheets?

Yes. Download the .xlsx, then in Google Sheets choose File, Import, Upload. Formulas, dropdown lists, frozen headers and colour highlights carry over.

Do they use macros?

No. Everything runs on ordinary formulas and conditional formatting, so there are no security prompts and they work in Excel for the web, on a Mac and on phones.

Can I edit the template before downloading?

Yes. Type into any cell on the template page and formulas recalculate as you go; the download includes your changes. Use Reset to go back to the sample.

Which versions of Excel open these files?

Excel 2010 and later, Excel for Mac, Excel for the web and the Excel mobile apps, as well as Google Sheets, Apple Numbers and LibreOffice Calc.