Template Library

Excel templates that already work

Every file here opens with the formulas live and a few sample rows to type over. Nothing is a picture of a spreadsheet — the totals, variances and summaries recalculate the moment you change a number.

The 8 free ones download straight from their card. No signup, no email, no watermark, and yours to edit, rebrand and use commercially.

74

Templates

2,786

Live formulas

7

Categories

8

Free downloads

74 templates shown

FinanceFree

Simple Cash Book

Money in, money out, and a balance that runs down every row so you always know where you stand.

  • 21 rows
  • 33 live formulas
  • 8 KB
Download .xlsx
Finance$19

VAT Return Summary

A quarter of sales and purchases logged once, adding straight up into the figures a VAT return asks for.

  • 27 rows
  • 57 live formulas
  • 9 KB
View details
Business$19

Job Costing Sheet

Labour, materials and subcontractors priced per line, with the margin on the job worked out as you go.

  • 31 rows
  • 67 live formulas
  • 9 KB
View details
Projects$7

RACI Matrix

Who is Responsible, Accountable, Consulted and Informed — with a check that every task has exactly one A.

  • 14 rows
  • 12 live formulas
  • 8 KB
View details
Projects$19

Sprint Burndown

Ideal against actual points remaining each day, with the velocity you would need to finish on time.

  • 28 rows
  • 63 live formulas
  • 8 KB
View details
Sales$12

Lead Tracker

Scores every lead out of 100 from fit and engagement, and tells you which to call first.

  • 13 rows
  • 17 live formulas
  • 8 KB
View details
Data$19

KPI Dashboard

Target against actual with on/off-target status, direction-aware so lower can be better.

  • 13 rows
  • 23 live formulas
  • 8 KB
View details

The complete pack

All 66 Pro templates in one download

Cash flow forecasting, loan amortisation, Gantt charts, sales pipeline, timesheets, inventory, KPI dashboards and the rest — built the same way as the free ones. One payment, commercial use, no subscription.

See what's included →

Built your own version and something looks wrong?

Upload it to our free auditor and it will flag broken references, inconsistent formulas and hardcoded values — with the cell address for each one.

Free Audit →

Using these templates

Each file opens with a few rows of sample data. That is deliberate — it shows you what belongs in each column and proves the formulas work before you touch anything. Replace the samples with your own rows and everything downstream updates.

When you add rows below the last sample row, check that the total formulas still cover them. In the budget tracker, for example, the total reads =SUM(C5:C12). Adding a row at row 13 leaves it outside that range. Insert new rows in the middle of the block instead and the range grows on its own — this is the single most common reason a template quietly stops adding up, and it is worth knowing about before it bites you. Our guide on why Excel totals are wrong goes through the rest.

Shaded, boxed cells are inputs — a tax rate, an hourly rate, a reorder level — and the table reads from them. Anything else holding a formula will overwrite itself if you type over it.

The task tracker uses TODAY(), so the days-left column changes every day you open it. That is what you want for a live project, but it means the file is never identical twice — do not be surprised when yesterday's numbers have moved.

Frequently Asked Questions

Do I need to sign up or give an email address?

No. Every free template downloads straight from its card — no account, no email, no newsletter. The files are plain .xlsx with nothing tracking you inside them.

Will these work in Google Sheets and LibreOffice?

Yes. Every function used — SUM, SUMIF, COUNTIF, COUNTIFS, IF, PMT, TODAY, AVERAGE and TEXT among them — exists in Google Sheets, LibreOffice Calc and Excel 2013 onwards. Upload the file to Google Drive and open it with Sheets, or open it directly in Calc.

Are the formulas already built in, or do I have to add them?

Already built in and live. Type over the sample rows and the totals, differences and summaries recalculate. Nothing is pasted-in static numbers — the formula count on each card is the real number of live formulas in that file.

What do the previews show?

The first few rows of the actual file, drawn from the workbook itself rather than mocked up. If a preview shows a column, that column is in the file you download.

Can I use these for commercial work?

Yes. Use them at work, edit them, rebrand them, send the invoice one to your clients. We wrote these from scratch, so there is no licence to worry about and no attribution required.

The totals show zero when I open the file — why?

Some spreadsheet apps open with calculation set to manual, which shows the stored value rather than recalculating. Press F9, or in Excel go to Formulas → Calculation Options → Automatic. Our guide on formulas not calculating covers every other cause.