How to Make a Roadmap in Google Sheets: Step-by-Step Guide with Timeline
8 min read ยท 2026-10-09
Here is how to make a roadmap in Google Sheets. Open a blank spreadsheet. List your work in rows, with one column each for phase, task, owner, start date, end date and status. Then add a row of week dates across the top and use conditional formatting to color each week a task touches. You get a simple, Gantt-style roadmap that anyone with the link can read and edit.
The full setup takes about 2 hours. This guide walks through each step, gives you the exact formulas, and shows how to keep the sheet useful after week one. If you would rather skip the manual setup and start from a ready-made visual plan, generate your roadmap with AI (first one free), then adjust it by drag and drop.
The roadmap at a glance
Goal: A shared Google Sheets roadmap with phases, tasks, owners, dates, statuses and a color-coded timeline. Duration: About 2 hours of setup, then 15 minutes of upkeep each week.
Define the scope (20 minutes)
Decide what the roadmap covers before you open the sheet.
- Write the goal of the roadmap in one sentence.
- Pick the time horizon, for example one quarter or six months.
- List 3 to 6 phases that move you toward the goal.
- Choose the time unit for the timeline: weeks for most projects, months for long plans.
Milestone: A one-line goal, a list of phases and a chosen time unit, written down.
Build the data table (20 minutes)
Set up the columns that hold every task.
- In row 1, type these headers: Phase, Task, Owner, Start, End, Status.
- Make row 1 bold and give it a background color.
- Go to View, then Freeze, then 1 row, so the headers stay visible.
- Format columns D and E as dates with Format, then Number, then Date.
Milestone: A frozen header row and six labeled columns with date formatting.
Add tasks and dropdowns (30 minutes)
Fill the table and lock in consistent values.
- Enter each task on its own row, grouped under its phase.
- Select the Status column, then use Insert, then Dropdown, and add: Not started, In progress, Blocked, Done.
- Add a second dropdown for the Phase column with your phase names.
- Give each task one owner and a start and end date.
Milestone: Every task has a phase, an owner, two dates and a status chosen from the dropdown.
Create the visual timeline (30 minutes)
Turn the table into a timeline you can read at a glance.
- In cell G1, type the Monday of your first week.
- In H1, type =G1+7 and drag it right until you cover your time horizon.
- Select the grid from G2 to the last week column and last task row.
- Open Format, then Conditional formatting, choose "Custom formula is" and enter =AND($D2<=G$1+6, $E2>=G$1).
- Pick a fill color and click Done.
Milestone: Each task shows a colored bar across every week it touches, even if it starts midweek or lasts only a few days.
Add status colors and milestones (15 minutes)
Make progress and key dates stand out.
- Add conditional formatting on the Status column: green for Done, red for Blocked.
- Add a row for each milestone with the same start and end date.
- Make milestone rows bold so they read as checkpoints.
- Add a thin border to the current week column.
Milestone: Anyone can spot blocked work and the next milestone in under a minute.
Share and review (15 minutes)
Get the team using the same sheet.
- Click Share and add people with the right access: Editor for owners, Viewer for stakeholders.
- Set a weekly review slot on your calendar.
- Add a "Last updated" cell at the top with the date of each review.
Milestone: The sheet is shared, and the first weekly review is on the calendar.
Why use Google Sheets for a roadmap
Google Sheets works well when you need a roadmap fast and your team already uses Google tools. It is free with a Google account, it runs in the browser, and several people can edit the same file at once. Comments, version history and sharing settings are built in, so you do not need to set up anything new.
It also fits small and medium plans well. A product launch, a hiring plan or a personal learning plan of small to medium size fits on one screen. Because it is a spreadsheet, you can sort by owner, filter by status or add a column for priority whenever you need it.
The limits show up as the plan grows. The timeline is made of colored cells, so moving a task means editing dates rather than dragging a bar. Presenting the roadmap to people outside the team can also feel crowded, because the data table and the timeline sit in one wide sheet.
The columns every roadmap sheet needs
A roadmap is a plan that shows what you will do, in what order, and by when. In a spreadsheet, each row is one piece of work and each column answers one question about it. Keep the core columns short and add extras only when they help a decision.
A good test: if a column has not changed a decision in a month, delete it. Fewer columns make the sheet faster to update, and a roadmap that is updated beats a detailed one that is out of date.
- Phase groups tasks into stages, such as Research, Build, Test and Launch.
- Task is a short action that starts with a verb, such as "Write onboarding emails".
- Owner is one person, not a team, so it is clear who moves the task forward.
- Start and End are real dates, which the timeline formula needs.
- Status comes from a dropdown so filters and colors work.
- Optional columns include Priority, Dependency (the task this one waits on) and Notes.
How the timeline formula works
The timeline uses one conditional formatting rule. Row 1 holds the Monday of each week, and columns D and E hold each task's start and end dates. The formula =AND($D2<=G$1+6, $E2>=G$1) asks, for every cell, "does this task overlap this week?" The week runs from Monday (G$1) to Sunday (G$1+6). The task overlaps it if it starts on or before Sunday and ends on or after Monday. If yes, the cell gets colored.
This overlap check matters. A task that starts on a Wednesday still colors its first week. A three-day task, or a milestone with the same start and end date, still shows up in the week it falls in.
The dollar signs matter too. G$1 locks the row, so every cell checks the Monday in row 1 of its own column. $D2 and $E2 lock the columns, so every cell in a row checks that task's own start and end dates. If your bars look wrong, check these first, then check that your dates are real dates and not text.
You can add a second rule for finished work. Use =AND($D2<=G$1+6, $E2>=G$1, $F2="Done") with a gray fill, and place it above the first rule in the list. Completed tasks then fade, and active work stands out. Some Google Workspace plans also include a built-in Timeline view under Insert, then Timeline, which turns your date columns into cards without formulas.
Keeping the roadmap up to date
A roadmap only helps if people trust it. The simplest habit is a 15-minute weekly review: walk through tasks due this week and next, update statuses, and move dates that slipped. Change the "Last updated" cell each time so readers know the sheet is current.
When a date moves, change it in the table, not in the timeline. The colored bars update by themselves. If a delay pushes a milestone, add a short note in the Notes column explaining why, so stakeholders see the reason without a meeting.
At the end of each phase, copy the tab and name it with the date. You keep a record of how the plan changed, which helps when you plan the next project. If keeping the sheet in shape takes more time than the work itself, generate your roadmap with AI (first one free) and keep the spreadsheet only for detailed task tracking.
When to move beyond a spreadsheet
Google Sheets is a good starting point, but some signs show it is time for a visual roadmap tool. You spend more time fixing formatting than planning. Stakeholders ask for a cleaner view to present. You rebuild the same structure for every new project.
At that point, a dedicated roadmap builder can help. You describe your goal, get phases, steps and milestones as a visual roadmap, and adjust them by drag and drop instead of editing date cells. You can keep both: the visual roadmap for direction and communication, and the sheet for detailed tasks.
Common mistakes to avoid
- Typing dates as text breaks the timeline formula, so format the Start and End columns as dates before you fill them in.
- Listing team names as owners leaves no one accountable, so assign one person per task.
- Writing statuses by hand creates "done", "Done" and "finished", so use a dropdown for every status.
- Planning by day over six months makes the sheet too wide to read, so use weeks or months for the timeline.
- Adding every small to-do turns the roadmap into a task list, so keep only work that matters at the phase level.
- Never reviewing the sheet makes people stop trusting it, so book a weekly 15-minute update.
Frequently asked questions
Does Google Sheets have a roadmap template?
Google Sheets offers a template gallery, and some versions include a Gantt chart template you can use as a starting point. You can also build your own in about 2 hours with the steps above. A custom sheet is often easier to maintain, because you only keep the columns your team uses.
How do I make a Gantt chart in Google Sheets?
Put your tasks with start and end dates in a table, add the Monday of each week across row 1, and apply a conditional formatting rule with =AND($D2<=G$1+6, $E2>=G$1). Each task then shows a colored bar across every week it overlaps, including short tasks and tasks that start midweek. Some Google Workspace plans also offer a Timeline view under the Insert menu.
Can several people edit the same roadmap in Google Sheets?
Yes. Click Share, add people by email and choose Editor, Commenter or Viewer access. Changes appear for everyone in real time, and version history lets you restore an earlier state if something breaks.
Is Google Sheets good for a product roadmap?
It works well for small product teams and early-stage plans, especially when the roadmap fits on one screen. As the number of features, teams and stakeholders grows, a visual roadmap is often easier to present and update. Many teams then use the sheet for task details and a visual roadmap for the big picture.