Work & Project Templates
These workbooks are for people who run projects or a small business from a spreadsheet: project managers, site leads on construction and fit-out jobs, freelancers, online sellers and service businesses. The Gantt planners calculate dates from working days, your holidays and finish-to-start dependencies, then draw the chart, status, resource load and dashboard for you. The construction edition adds trades, inspection hold points and permits. The business dashboards turn income, expense and invoice logs into a monthly P&L and a KPI dashboard, with extras for sellers (fees and profit per product) and service firms (profit per job and per hour).
The files are .xlsx workbooks with no macros or add-ins. Scripts recalculated them in Excel for Mac 16.114.3 and LibreOffice. Excel for Windows and Google Sheets have not been tried. Each workbook comes as a filled example and a blank copy with a PDF guide, and formula cells are protected without a password. The files are built by code, then every formula is recalculated in a real spreadsheet engine and compared with an independent Python calculation.
All 7 templates
-
Gantt Chart Project Planner for Excel
Type tasks and links once; dates, Gantt bars, status and the dashboard update themselves
$3.79 on Etsy -
Construction Schedule Template (Gantt with Trades & Permits)
A Gantt schedule that tracks trades, inspection hold points and permits alongside the dates
$3.79 on Etsy -
Project Management Bundle: Gantt Planner + Business Dashboard
Five workbooks: plan projects with a Gantt chart and track the business numbers
$5.09 on Etsy -
Small Business Dashboard: Freelancer Edition
See what you earned, what you spent and which clients still owe you
$3.19 on Etsy -
Online Seller Profit Tracker
Real profit per order and per product, after platform fees, postage and product cost
$3.19 on Etsy -
Service Business Dashboard
Profit, margin and revenue per hour for every job, next to your P&L and invoices
$3.19 on Etsy -
Pro Spreadsheet Bundle (Gantt, Dashboard, Budget + Debt)
Seven workbooks in one download: Gantt planning, business dashboards, debt payoff and budget
$6.49 on Etsy
Which one do I need?
| Template | Best for | Opens in | Files | Inside | Bundle contains | Price |
|---|---|---|---|---|---|---|
| Gantt Chart Project Planner for Excel | Project leads and teams, any project | Excel for Mac, LibreOffice | Example + blank .xlsx, 4-page PDF guide | Gantt, dependencies, RAID log, resource load, dashboard | — | $3.79 |
| Construction Schedule Template (Gantt with Trades & Permits) | Contractors, fit-out and renovation jobs | Excel for Mac, LibreOffice | Example + blank .xlsx, 4-page PDF guide | Gantt + trades, hold points, permits | — | $3.79 |
| Project Management Bundle: Gantt Planner + Business Dashboard | Owners who plan jobs and track money | Excel for Mac, LibreOffice | 5 zips: example + blank .xlsx + PDF guide each | Gantt (core + construction), 3 business dashboards | Gantt Chart Project Planner for Excel, Construction Schedule Template (Gantt with Trades & Permits), Small Business Dashboard: Freelancer Edition, Online Seller Profit Tracker, Service Business Dashboard | $5.09 |
| Small Business Dashboard: Freelancer Edition | Freelancers and sole traders | Excel for Mac, LibreOffice | Example + blank .xlsx, 3-page PDF guide | Income, expenses, invoices, P&L, top clients | — | $3.19 |
| Online Seller Profit Tracker | Online sellers tracking orders and fees | Excel for Mac, LibreOffice | Example + blank .xlsx, 3-page PDF guide | Orders, fees, postage, profit per product | — | $3.19 |
| Service Business Dashboard | Cleaning, contracting and other service firms | Excel for Mac, LibreOffice | Example + blank .xlsx, 3-page PDF guide | Jobs, billable hours, profit per job, P&L | — | $3.19 |
| Pro Spreadsheet Bundle (Gantt, Dashboard, Budget + Debt) | One toolkit for projects, business and money | Excel for Mac, LibreOffice | 3 zips: 14 .xlsx files + PDF guides | Gantt x2, dashboards x3, debt payoff + budget | Gantt Chart Project Planner for Excel, Construction Schedule Template (Gantt with Trades & Permits), Small Business Dashboard: Freelancer Edition, Online Seller Profit Tracker, Service Business Dashboard, Monthly Budget Spreadsheet, Debt Payoff Tracker: Snowball vs Avalanche | $6.49 |
Prices in US dollars from our listing records. Etsy shows the current price and your local currency at checkout.
Related guides
How to build a construction schedule in Excel (with a 12-week example)
A construction schedule in Excel needs one row per task with its phase, trade, duration in working days and the task that must finish first. Start dates are then calculated from those links, and inspections and permits are listed as their own rows or flags. The longest chain of linked tasks, the critical path, sets the finish date.
How to make a Gantt chart in Google Sheets (2 methods)
Google Sheets has no Gantt chart type, so you build one. Either make a stacked bar chart from a start-offset column and a duration column and hide the first series, or lay out a row of dates and colour each task's cells with a conditional formatting custom formula such as =AND(D$1>=$B2, D$1<=$C2).
Questions
- Does it do dependencies?
Yes: finish-to-start, one predecessor per task, with lag or overlap in working days. To wait for several tasks, link to the one that finishes last.
- Is it for big projects?
It's built for small and medium jobs: 150 task rows, finish-to-start links. For critical-path analysis of large programmes use dedicated scheduling software.
- Is it tax software?
No. It tracks income and costs and sets aside a % you choose. It is not tax advice and does not file returns.