A project without a plan is a project about to go off the rails. You need to know who does what, when it should be done and what happens if someone is delayed. A project planning template in Excel gives you that overview in 20 minutes.

During my years as a consultant I have seen projects of all sizes – from 5-day implementations to multi-year transformations. The ones that succeed always have one thing in common: clear planning from the start.

Excel is not the most advanced project tool, but for projects with 10-50 tasks and 2-10 people it is often the most practical. It is available everywhere, everyone knows it and it requires no learning of a new tool.

This guide shows you how to use Excel for effective project planning, including a free downloadable template.

Download the free project planning template

Our project template for Excel includes: – Gantt-like timeline with automatic visualisation – Task structure with dependencies – Resource allocation (who does what) – Status tracking and progress – Milestone marking – Instruction sheet

Download the free project planning template

The template works in Excel 2016 and later, on both Windows and Mac. It uses conditional formatting for the Gantt visualisation – no macros required.

Why project planning in Excel works

There are dedicated project tools such as MS Project, Monday and Asana. Why choose Excel then?

Everyone already has Excel

No new system to introduce, no licences to buy, no onboarding. Your team can start working straight away.

When I helped a consulting firm standardise its project planning, they first wanted to buy MS Project. After a month, three out of ten project managers had learned the tool.

We built an Excel template instead. Everyone could use it from day one. The focus became the projects, not the tool.

Flexibility without limitations

Dedicated tools often have a rigid structure. “This is HOW you do project planning.”

Excel lets you customise freely. Need to track something unusual? Add a column. Want to combine the project plan with a budget? Add a sheet.

Easy to share and export

Excel files can be shared by email, SharePoint and OneDrive. They can be printed professionally. They can be copied into PowerPoint presentations.

Many project tools require the recipient to have a licence or an account to see the plan.

When Excel is NOT enough

For the sake of clarity – Excel has its limits:

  • Large complex projects (100+ tasks, 20+ people) → MS Project or a dedicated tool
  • Real-time collaboration with many simultaneous users → Monday, Asana
  • Advanced resource optimisation across multiple projects → professional tools
  • Critical path analysis and advanced scheduling → MS Project

But for the majority of projects in small businesses? Excel is perfectly adequate.

Read more: Excel vs dedicated tools: When is a template enough?

What a project planning template should contain

A useful project template has certain basic components.

Task list with structure

Minimum: – Task name – Description (short) – Start date – End date (or duration) – Responsible person – Status

Nice to have: – Task ID (for reference) – Phase/category (group tasks) – Dependencies (which tasks must be completed first) – Priority (high/medium/low) – Comments/notes

Timeline (Gantt visualisation)

People understand visually better than numbers. A Gantt visualisation quickly shows: – How long each task takes – Which tasks run in parallel – When critical milestones fall – Where the team is today

In Excel you create a Gantt chart with conditional formatting – no code needed.

Resource allocation

Who does what and when?

A simple resource overview shows: – Which tasks each person is responsible for – How many hours per person per week – Overload (if someone has too many tasks at the same time)

Milestones

Critical decision points or deliveries are clearly marked. It gives the team natural intermediate goals to aim for.

How to use the project planning template – step by step

Here is the process for setting up a project with our template.

Step 1: Define the project scope

Before you open Excel you need to know: – What is the goal of the project? (concrete deliverable) – When must it be done? – Who is on the project team? – What are the major phases?

Example: Goal: Launch a new website Deadline: 15 May 2026 Team: Designer, developer, copywriter, project manager Phases: Planning, Design, Development, Content, Testing, Launch

Step 2: Break down into tasks

Take each phase and split it into concrete tasks.

Phase: Design – Create wireframes – Design the home page – Design subpages (5) – Client approval – Revise according to feedback

Each task should be clearly defined with a clear end. “Work on design” is too vague. “Design the home page and get it approved” is concrete.

Step 3: Fill in the template

Download the template and open the “Project plan” tab.

For each task, fill in:

  1. Task name: Short and clear
  2. Description: What does the task involve in concrete terms?
  3. Responsible: ONE person (not “the team”)
  4. Start date: When can the task start at the earliest?
  5. End date: When must it be completed at the latest?
  6. Status: Not started / In progress / Done / Blocked

The template automatically calculates duration and updates the Gantt visualisation.

Step 4: Mark dependencies

Some tasks cannot start until others are completed.

“Develop home page” cannot begin until “Design home page” is approved.

In the “Depends on” column you enter the ID of the task that must be completed first.

Step 5: Assign resources

Check that nobody is overloaded.

If Sara is responsible for 8 tasks that all have to be done in the same week, you have a problem. Redistribute or adjust the schedule.

Step 6: Mark milestones

Identify critical points: – Design approved by client (milestone) – Development ready for testing (milestone) – Content published (milestone) – Launch (milestone)

Mark these in the “Milestone” column (Yes/No). The template colour-codes them differently in the Gantt chart.

Step 7: Review the timeline

Look at the Gantt chart. Does it look reasonable?

  • Are critical tasks too close to the deadline? → Add a buffer
  • Is the team on leave during the project? → Adjust the schedule
  • Is any phase very long compared with the others? → Perhaps it needs to be broken up

Step 8: Update regularly

A project plan is not static. Update status weekly (or daily for intensive projects).

Change “Status” to “In progress” when a task starts and “Done” when it is finished.

The template automatically shows progress as a percentage.

Build a Gantt chart yourself (if you want to customise)

Our template has the Gantt visualisation ready. But if you want to understand how it works (or build your own):

The basic principle

A Gantt chart is a row of cells per task, where some cells are coloured based on the task’s start and end dates.

Step by step:

  1. Create a date row: Columns for each day/week in the project
  2. Create task rows: One row per task
  3. Conditional formatting: Colour a cell if the date is between start and end

Formula for conditional formatting:

Say the start date is in cell C2, the end date in D2, and the date columns start from F1.

Select cells F2:Z2 (where Z is the last date column).

Go to Home > Conditional Formatting > New Rule > Use formula:

=AND(F$1>=$C2, F$1<=$D2)

Select a colour (e.g. blue). Now cells between start and end are coloured.

Repeat for all task rows.

Tip: Use different colours for: – Normal tasks (blue) – Milestones (red) – Completed tasks (green) – Delayed tasks (orange)

Advanced features for project planning

Once you master the basics you can add more advanced functionality.

Automatic resource summary

Build a summary that shows per person: – Number of assigned tasks – Total hours – Number of tasks in progress

Use COUNTIF and SUMIF formulas.

Critical path identification

Identify tasks where a delay affects the end date.

This requires more advanced formulas and quickly becomes complex in Excel. For serious critical path analysis, MS Project is recommended.

But you can manually mark tasks that are critical.

Budget integration

Add columns for: – Budgeted hours – Actual hours – Hourly cost – Total cost

Automatic calculation of project cost and comparison against budget.

Dashboard with progress

Build a summary page with: – Total number of tasks – Percentage completed (%) – Delayed tasks – Upcoming milestones – Resource load

Use pie charts, bar charts and conditional icon formatting for a visual overview.

If you need help with advanced features, an Excel consultant can save you hours of experimenting.

Common project planning mistakes in Excel

I have seen these mistakes again and again.

Mistake 1: Forgetting buffer

Everything takes longer than planned. Always.

If your analysis “should take 3 days” it will take 4. Add a 20-30% buffer, especially towards the end when everything has to come together.

Mistake 2: No clear owner

“The team will do it” means nobody does it.

Every task must have ONE named owner. That person can delegate further, but owns the deliverable.

Mistake 3: Too many simultaneous tasks per person

A person cannot work effectively on 5 tasks in parallel.

Recommended: Max 2-3 active tasks per person at a time.

Mistake 4: Too detailed or too coarse

100 tasks of 30 minutes each? Too detailed, impossible to maintain.

5 tasks of 2 months each? Too coarse, no control.

The right level: Tasks that take 1-10 days. A total of 15-50 tasks for a typical project.

Mistake 5: Static plan

The project plan is made at the start, then forgotten.

The plan must be updated. Status changes, new tasks appear, schedules are adjusted. A plan that is not followed is worthless.

Combine with time reporting

The project plan shows what SHOULD be done. Time reporting shows what has ACTUALLY been done.

Build a simple time reporting sheet where the team logs: – Date – Task (from the project plan) – Hours spent – Comment

Compare planned vs actual hours to: – See whether estimates were correct – Identify bottlenecks – Improve future planning

When you need to upgrade from Excel

Excel-based project planning works excellently in many situations. But some signs show that it is time to upgrade.

The project grows too large

If you have: – 100+ tasks – 20+ team members – Multiple projects sharing resources – Complex dependencies and a critical path

Then maintaining Excel becomes a full-time job. MS Project or a dedicated tool gives a better overview.

Real-time collaboration is required

If 10 people need to update the plan daily, Excel becomes problematic. Locked files, version conflicts and confusion.

Solution: Use collaborative tools such as Monday, Asana or Trello.

Integrations are needed

If the project plan needs to sync with: – CRM (for customer projects) – Accounting system (for invoicing) – Time reporting (for actual time)

Then Excel integration becomes complex. Dedicated tools often have built-in integration.

Read more: Excel vs dedicated tools: When is a template enough?

Frequently asked questions about project planning in Excel

Can several people work in the project plan at the same time? Not recommended in a local file. Use Excel Online via SharePoint for basic collaboration.

How often should the project plan be updated? At minimum weekly for status. Daily for intensive projects. At every change (new tasks, delays).

What is the difference between a Gantt chart and a project plan? The project plan is the whole document (tasks, resources, status). The Gantt chart is the visual timeline.

Can I use Excel for Agile projects? Yes, but it is not optimal. Agile is built on flexibility and quick updates. Tools such as Jira or Trello are a better fit. But for small Agile teams Excel works.

Do I need VBA for project planning in Excel? No, basic functionality is handled with formulas and conditional formatting. VBA can automate certain things but is not necessary.

What do I do if a task is delayed? Update the end date. Check which tasks are affected (those with dependencies). Adjust their start dates. Communicate with the team.

Next step: Start your next project in a structured way

Project planning in Excel takes 30-60 minutes to set up but saves hours of confusion and rework.

Start here:

  1. Download the free project planning template
  2. Identify your next project
  3. Define the goal, team and deadline
  4. Fill in tasks according to the guide above
  5. Share with the team and schedule a weekly status meeting

Do you need a more advanced project solution?

If your projects are large or complex, we are happy to help: – Tailored project templates for your industry – Integration with time reporting and budget – Training for your team – Consulting support at project start-up

Book a free consultation

Keep reading: – Excel templates for business: Free downloads and professional solutions – Excel vs dedicated tools: When is a template enough? – Automate Excel reports with VBA

A well-planned project is a successful project. Start with structure from day one.

Written by Lukas Lilja, Excel Department. With experience from hundreds of projects, we help companies structure and deliver on time.

Need help with this? Our VBA courses will help you – the first consultation is free of charge.

Book a free call or call 010-264 20 20.