TYMORA: Project Timeline Google Sheets Template

TYMORA lays a project out as a timeline and draws the bars for you. Each task carries an owner and a span; a grid of weeks to the right shades the cells that fall inside that span, so the schedule reads like a light Gantt chart without any chart to maintain. It's a project timeline template for Google Sheets with no account behind it and no trial — the free .xlsx download is the product, and it opens in Google Sheets, Excel or LibreOffice.

What the project timeline template holds

The Timeline tab starts with one editable cell — the project start date — and then a row per task: task name, owner (from a dropdown), start, end, duration in days, status and percent complete. To the right sit ten week columns, Wk 1 through Wk 10, whose header dates chain off the project start. The Lists tab is the editable source of the dropdowns: your team's owners and the task statuses (Not started, In progress, Blocked, Done).

How the Gantt grid and the duration work

Duration is calculated, not typed: the sheet takes end minus start, inclusive of both ends, so a task that runs Monday to Friday reads five days. The week headers are chained — the first reads the project start, each next one adds seven — so moving the start date slides the whole grid. The bar itself is conditional formatting: a week cell turns green when that week falls inside the task's start-to-end span, which is what gives you the Gantt look. Two more rules read the status, shading a Done row green and a Blocked row red. Ten sample tasks arrive across the weeks with varied statuses and progress, so the bars and the status colours are visible before you replace them.

How to plan a project timeline in Google Sheets

1. Set the project start date — the week headers recalculate on their own.
2. List your owners and statuses on the Lists tab if you want different ones.
3. Add each task with its start and end; the duration in days fills itself in.
4. Read the grid: the green cells are each task's span — that's your Gantt bar.
5. Mark status and percent as you go; Done turns green and Blocked turns red.

A project timeline in twelve languages

Project teams don't all work in English, so TYMORA ships in twelve language editions — each a separate .xlsx with tab names, column labels, owner samples, statuses and date formats translated, formulas left intact. Download the one that matches your page language, and use the opening guide if the .xlsx import step is unfamiliar.

A timeline sets the dates; the day-to-day execution lives elsewhere. The day schedule template blocks out a single working day and the to-do list template carries the loose tasks, while the rest of the set sits under project management templates for Google Sheets.