Files delivered as downloads — on screen and by email, as soon as payment is confirmed.

Project Tracker for Small Teams

A six-sheet workbook for teams who went back to a spreadsheet and want it to hold up under real projects.

€29

Total price.

Google Sheets/Excel · V1.0 · Updated 14 July 2026
Schematic preview — tab structure and column layout, not a screenshot of the workbook.

01 What's inside

What's inside

  1. 01project-tracker.xlsxExcelThe workbook: tasks, milestones, capacity, status summary, reference lists, and a tab explaining every formula used. (6 sheets)~340 KB
  2. 02project-tracker-worked-example.xlsxExcelThe same workbook filled in with a fictional six-week website project: 44 tasks, four milestones, two people, one deliberately over-committed week. (44 example tasks)~360 KB
  3. 03project-tracker-google-sheets-copy-link.pdfGoogle SheetsCopy link for the Google Sheets version, with a note on the two columns written differently there.~90 KB

3 files

02 Specification

Specification

File formats
Google Sheets, Excel
File size
~790 KB total
What you need
Requires Excel 2016 or later, or a free Google account for the Sheets version.
Compatibility
  • Excel 2016 and later on Windows and macOS, including Microsoft 365. Opens in LibreOffice Calc 7.x, where conditional formatting on the capacity sheet renders with slightly different colours.
  • The Google Sheets version is a copy link. "Make a copy" puts it in your own Drive.
  • No macros, no VBA, no add-ins, no Apps Script. Nothing has to be enabled or trusted on open.
  • All sheets and formulas are unlocked and unprotected. Sheet names, column headers and note text are in English.
Language
English
Technical protection
No DRM. Files are not password-protected.
Licence
Commercial licence — what you may and may not do with these files.
Version
1.0
Updated
14 July 2026
Delivery
Download link on screen and by email as soon as your payment is confirmed. See how buying works.

03 Suited to / not suited to

Who this is for

Suited to

  • Teams of two to eight running several client or internal projects at once
  • Project leads who need a weekly status view without asking everyone for an update
  • Anyone whose planning currently lives in a spreadsheet that nobody trusts

Not suited to

  • Teams who need dependencies, Gantt logic or resource levelling — this counts hours, it does not schedule them
  • Anyone looking for time tracking or billing; neither exists here

04 More previews

More previews

Schematic preview — which sheet reads from which.

05 Licence

Licence

Commercial licence — what you may and may not do with these files.

06 Buying, delivery and refunds

Buying, delivery and refunds

Note

Because the files are made available immediately at your request, the 14-day withdrawal right ends then. Your rights if a file is faulty are separate and last two years. See Refunds & Withdrawal.

Download link on screen and by email as soon as your payment is confirmed. See how buying works.

07 Version and changes

Version and changes

  • Version 1.0Initial release.2026-07-14

08 Questions about this product

Questions about this product

Do the Excel and Google Sheets versions behave identically?

Almost. Two columns use ARRAYFORMULA in Sheets where Excel fills the formula down each row; the results match. The formulas tab lists both versions side by side.

How many projects can it hold?

The tasks sheet is set up for 500 rows and the reference lists allow twelve concurrent projects. Both are ordinary ranges you can extend, and the formulas tab explains which named ranges to update if you do.

Can I add a column without breaking it?

Adding columns to the right of the tasks sheet is safe. Inserting inside the existing block will shift references used by the summary; the formulas tab marks which columns are read elsewhere.

Does it work in LibreOffice or Numbers?

LibreOffice Calc 7.x opens it and calculates correctly, with minor differences in conditional formatting colours. Apple Numbers imports it but rewrites some formulas on save, so it is not a version we would rely on.

Related products

Related products

Project Tracker for Small €29