Project Roadmap Template in Excel: Layout, Formulas and Example
9 min read ยท 2026-10-25
A practical project roadmap template Excel file is a grid with workstreams down the left, weeks or months across the top, and colored bars that show when each piece of work runs, with milestones marked along the way. You can build it in about an hour with nothing more than conditional formatting, and once it is set up the bars move by themselves when you change a start or end date.
A roadmap is not the same as a detailed project schedule. It shows phases and major deliverables on one page so a sponsor can read it in a minute. Keep the task-level schedule in a separate tab or tool, and let the roadmap stay at the level of 15 to 30 rows.
Below you will find the layout, the step-by-step build in Excel, a filled-in example for a website relaunch, how to keep it current and how to present it. The phase structure in the roadmap that follows works for most six-month projects and is what the example uses.
The roadmap at a glance
Goal: By week 24, the project is delivered and closed, with every phase and milestone tracked on a one-page Excel roadmap that the sponsor reviews every two weeks. Duration: 24 weeks
Initiation (Weeks 1-2)
Agree why the project exists, what it covers and who decides.
- Write the project charter with objective, scope, sponsor and budget owner.
- List the workstreams that will become swimlanes on the roadmap.
- Agree the reporting rhythm, such as a steering meeting every two weeks.
Milestone: Charter signed by the sponsor and workstreams agreed.
Planning (Weeks 2-4)
Turn the scope into phases, deliverables and dates.
- List the major deliverables per workstream and estimate their duration with the people doing the work.
- Map dependencies between workstreams, such as content needing the design to be approved first.
- Set the milestones the sponsor will track, ideally one every three to four weeks.
- Build the Excel roadmap and baseline the dates.
Milestone: Roadmap baselined and reviewed with workstream leads and the sponsor.
Design (Weeks 4-9)
Agree what will be built before building it.
- Produce designs, specifications or process maps for each deliverable.
- Review them with users and the sponsor.
- Update the roadmap if design reveals new work.
Milestone: Designs signed off by the sponsor.
Build (Weeks 9-17)
Produce the deliverables in planned increments.
- Build in increments and show progress at each steering meeting.
- Track progress per row in the roadmap's status column.
- Raise risks early and log them with an owner.
Milestone: All deliverables built and ready for testing.
Test and prepare launch (Weeks 16-21)
Prove the deliverables work and get people ready.
- Run testing with real users and fix the blocking issues.
- Prepare training, communications and the go-live checklist.
- Hold a go/no-go meeting against agreed criteria.
Milestone: Testing passed and a written go decision from the sponsor.
Launch and close (Weeks 21-24)
Go live, stabilize and hand over.
- Launch and monitor closely in the first two weeks.
- Hand support over to the team that owns it.
- Run a lessons-learned session and write the closure report.
Milestone: Closure report signed by the sponsor.
The layout: what goes where
Set the sheet up in three zones. On the left, a block of information columns: ID, Workstream, Item, Owner, Start, End, Status. Across the top, from the column after Status, one column per week, each about three characters wide, with the Monday date of that week in a header row. In the grid where rows and weeks meet, conditional formatting fills the cells to draw each bar.
Group rows by workstream, which become your swimlanes. A common set is Management, Design, Build, Content, Testing and Launch. Put a shaded header row above each swimlane with its name, and leave the item rows below it. Use one fill color per workstream for the bars, and keep red, amber and green only for the Status column, so color always means one thing.
Milestones get their own rows with the same start and end date, so the bar becomes a single cell. Give them a darker fill or a bold letter M in the cell, and start the item name with Milestone: so they stand out when someone filters the sheet.
- Rows 1-2: project name, sponsor, last updated date and a short legend for colors.
- Row 3: week start dates across the timeline columns.
- Row 4: column headers for the information block.
- Row 5 onward: swimlane header rows, items and milestones.
How to build it in Excel, step by step
These steps use the desktop version of Excel. Most of them also work in Excel for the web and in Google Sheets, where the menus have similar names.
When you are done, test it: change an end date and the bar should grow or shrink at once. If it does not, check that the start and end cells hold real dates, not text.
- Enter the information columns: type ID, Workstream, Item, Owner, Start, End and Status in row 4, columns A to G.
- Create the week headers: in H3 type the Monday of week 1. In I3 enter =H3+7 and fill right for as many weeks as the project needs. Format the cells to show day and month only, and rotate the text in Home, Alignment, Orientation if space is tight.
- Draw the bars: select the grid starting at H5, then go to Home, Conditional Formatting, New Rule, Use a formula to determine which cells to format. Enter =AND(H3<=F5,H3+6>=E5). Then put the cursor on each reference and press F4 until the row of H3 is locked and the columns of F5 and E5 are locked, so the rule still points at the date row and the date columns in every cell. Choose a fill color and press OK. Each cell now fills when its week overlaps the item's dates.
- Add a today marker: select the week dates in row 3, starting at H3, and add a second rule with =AND(TODAY()>=H3,TODAY()<H3+7) and a bright fill, so the current week stands out.
- Add a Status drop-down: select the Status column, then go to Data, Data Validation, choose List and type On track,At risk,Off track,Done. Add conditional formatting rules that color each value.
- Freeze the headers: select cell H5, then go to View, Freeze Panes, Freeze Panes, so labels stay visible as you scroll.
- Group swimlanes: select the item rows of a workstream and use Data, Group, so you can collapse a lane for a summary view.
- Set up printing: in Page Layout, choose Landscape, set Print Titles to repeat rows 3 and 4, and scale to fit one page wide.
Example: a website relaunch roadmap, filled in
Picture a marketing team relaunching the company website in 24 weeks. The sponsor is the head of marketing and the project manager owns the roadmap. Here are the key rows, by swimlane, as they would appear in the sheet.
The roadmap stays at about 20 rows. The detailed tasks, such as each page template or each content brief, live in the team's task tool, and only the deliverables and milestones appear here.
- Management (owner: project manager): charter weeks 1-2, steering meetings every two weeks, Milestone: roadmap baselined in week 4.
- Design (owner: design lead): sitemap and wireframes weeks 4-7, visual design weeks 6-9, Milestone: designs approved in week 9.
- Build (owner: web developer lead): templates weeks 9-14, integrations with the CRM and analytics weeks 12-17, Milestone: site ready for testing in week 17.
- Content (owner: content lead): content audit weeks 3-6, new copy weeks 8-15, migration of existing pages weeks 14-18.
- Testing (owner: QA lead): functional and accessibility testing weeks 16-20, user testing week 19, Milestone: go decision in week 21.
- Launch (owner: project manager): redirects and launch checklist weeks 19-21, Milestone: site live in week 22, closure report week 24.
How to keep the roadmap current
Update the roadmap once a week, on a fixed day, before the status meeting. Change dates and statuses in the information columns only. The bars redraw themselves, which is the main reason to use formulas instead of coloring cells by hand.
Keep the original dates visible. Add two hidden columns called Baseline start and Baseline end, copy the dates into them when the sponsor approves the plan, and add a third conditional formatting rule that draws a thin border or lighter fill for the baseline. Slips then show at a glance. Store the file in a shared location such as SharePoint or OneDrive, so there is one version and everyone sees the latest.
How to present it in a steering meeting
Collapse the swimlanes to their header rows or hide the item rows you do not need, so the view fits one screen. Point to the today marker first, then walk through what changed since the last meeting: rows that moved, milestones hit and anything At risk or Off track. Finish with the decisions you need.
For slides, select the visible range and use Home, Copy, Copy as Picture, then paste it into PowerPoint. Add a short text box next to it with three items: milestones hit, top risk and decision needed. Leave out owner names and IDs on the slide if space is tight, but keep them in the sheet for questions.
When Excel stops being enough
Excel works well for a single project with up to a few dozen roadmap rows and one person who updates it. It gets harder when several people edit at once, when you need dependencies that move linked rows automatically, or when you run many projects that need a portfolio view.
At that point, teams often move the schedule to a tool such as Microsoft Project, Smartsheet or Jira and keep a summary view for executives. The layout principles stay the same: swimlanes by workstream, one row per deliverable, milestones that are easy to see and color used only for status.
Common mistakes to avoid
- Coloring cells by hand means every date change becomes a repainting job, so draw the bars with a conditional formatting formula tied to the start and end dates.
- Putting every task on the roadmap makes it unreadable, so keep it to deliverables and milestones and hold the detail in a separate schedule.
- Using color for both workstreams and status confuses readers, so give each workstream one bar color and keep red, amber and green for the Status column.
- Overwriting the original dates hides how far the project has slipped, so keep baseline start and end columns and show them next to the current bars.
- Emailing copies of the file creates several versions, so store one file in a shared location and send a link.
- Updating the roadmap only before steering meetings lets it drift from reality, so update it on a fixed day every week.
Frequently asked questions
How do I create a project roadmap in Excel?
List your items with an owner, start and end date in columns, put week start dates across the top, and use a conditional formatting formula to fill the cells between each item's dates. Group items into workstream swimlanes and add milestone rows. Freeze the headers and set it to print on one page.
Does Excel have a roadmap template?
Excel includes some timeline and Gantt-style templates you can find by searching from File, New. Many teams still build their own, because a custom layout with swimlanes and a formula for the bars is easy to set up and fits their project exactly.
What is the difference between a project roadmap and a Gantt chart?
A Gantt chart shows every task with dates and dependencies, and project managers use it to run the work. A project roadmap shows phases, major deliverables and milestones on one page, for sponsors and stakeholders. You can build both in Excel with the same bar technique, at different levels of detail.
How do I show milestones on an Excel roadmap?
Give each milestone its own row with the same start and end date, so it fills a single week cell. Use a darker fill or a bold M, and start the item name with Milestone: so it stands out when filtered.
Can I build the same template in Google Sheets?
Yes. Google Sheets supports custom formula rules in Format, Conditional formatting, and drop-down lists through data validation. The same formula for the bars works, with only small differences in menu names.