Reviewed & updated by WordNExcel Team — Updated November 10, 2026
A timeline shows events in the order they happened, or will happen, along a line of time. It turns a list of dates into a story you can follow at a glance. Timelines are used by students studying history, by event planners running a wedding or conference, and by families recording the milestones of a life. On this page you can download five free timeline templates in Excel: a history timeline, an event day timeline (run of show) and a life milestones timeline, plus a project decision timeline and a product roadmap timeline.
Each file is a real, editable .xlsx spreadsheet with formulas already set up. Type in the yellow cells and the timeline works out years, times and ages for you. These templates are for history, events and personal milestones rather than project schedules.
Free download: 5 templates (.xlsx). Works in Excel and Google Sheets. No sign-up needed.
What Is a Timeline?
A timeline is a list of events arranged in date or time order. Each entry usually has:
- A date or time: a year, a full date or a clock time.
- The event: what happened or will happen.
- Details: where, who was involved or why it matters.
Timelines help you see the order of events, how much time passed between them and how one event led to another. They are useful for school projects, presentations, event planning, family history and personal goals.
Download Free Timeline Templates
The templates open in Microsoft Excel, Google Sheets and LibreOffice Calc.
1. History Timeline

A timeline for school projects, history lessons and research. Enter the topic and student or class name, then up to 20 events, each with the year, the event, the place and why it matters. The timeline shows how many years after the first event each one happened, and a summary shows the span from the first year to the last, the number of years and the number of events. An order check tells you whether the events are in date order or need sorting. You can use negative numbers for BC years. The sample covers the Space Race, from the launch of Sputnik 1 in 1957 to the Apollo–Soyuz docking in 1975: 18 years and six events.
2. Event Day Timeline

A run of show for weddings, parties, conferences, fundraisers and school events. Enter the event name, date and the time the day starts, then list each item with its length in minutes, what happens, who is responsible and any notes. The timeline works out the start and end time of every item, so if you change the length of one item, every time after it moves automatically. At the bottom, it shows when the day ends and the total time. The sample runs from 2:00 PM set-up through doors opening, speeches, dinner, cake cutting and dancing to pack-down, ending at 8:15 PM after 6 hours and 15 minutes.
3. Life Milestones Timeline

A personal timeline for life events and goals. Enter your name and date of birth, then up to 30 milestones, each with the date, the milestone and a category from the dropdown: Education, Career, Family, Home, Travel, Health, Goal or Other. The timeline works out your age at each milestone and marks future dates as Upcoming, with a highlight. A summary shows the number of milestones, your next upcoming milestone and how many milestones you have in the education, career, family and home categories. Use it for a family record, a retirement or birthday slideshow, a memoir outline or to plan future goals.
4. Project Decision Timeline

A timeline of decisions and gates, not of every task (those belong on a Gantt or project plan). Each row has a date, the decision or event, an owner, a status (planned, done, slipped or dropped) and a short note. The header counts items still planned, and slipped rows are highlighted. When a gate moves, change the date and mark it slipped so the history stays visible. Sponsors can read this in a minute at the start of a steering meeting.
5. Product Roadmap Timeline

A product roadmap as a dated list rather than a slide. Each row has a quarter, a theme, the item or feature, a status (idea, planned, in flight, shipped or dropped) and an owner. Keep “in flight” honest — if work has not started, leave it as planned. Product managers review this with the decision timeline when a date slips. Grouping by theme as well as quarter makes trade-offs visible (too many reliability items in one quarter, for example). Drop or slip items in the status column; do not delete history.
How to Make a Timeline
- Choose the topic and time span your timeline will cover.
- Research or gather the events and their dates.
- Pick the most important events. A timeline with too many entries is hard to read.
- Enter the events with dates and short descriptions.
- Sort them in date order. The history timeline checks this for you.
- Add context: why each event matters or who is involved.
- Present it as a table, or create a chart from the data.
Tips for a Clear Timeline
- Keep descriptions short: a few words or one sentence each.
- Use the same date format throughout.
- Check your dates against reliable sources, and list them for school work.
- Group events by category or colour to show themes.
- Show the gaps. The years-after column shows how much time passed between events.
- For events, build in buffer time between items so small delays don’t knock everything off schedule.
Timelines for School Projects
Teachers often ask students to create a timeline to show they understand the order of events and how one led to another. Start with the key events your teacher has covered, then add a few more from your own research. For each event, write one sentence explaining why it matters, not just what happened. Cite your sources, such as textbooks, encyclopedias and museum websites. When you present, explain the causes and effects that link the events together.
Planning an Event Day Timeline
An event day timeline, sometimes called a run of show or run sheet, makes sure everyone knows what happens when. Start with the fixed times, such as when the venue opens, when dinner is served and when the venue must be empty, and work around them. Give each item a realistic length, and add short buffers for things that often run late, such as speeches and photos. Share the timeline with your venue, caterer, DJ, photographer and helpers a few days before, and print copies for the day.
Who Can Use These Templates?
- Students and teachers creating history timelines.
- Event planners, couples and party hosts planning the day.
- Families recording milestones and family history.
- Writers outlining biographies and memoirs.
- Anyone planning personal goals and life events.
Recording Life Milestones
A life milestones timeline is a lovely way to record a family’s story. Start with the big dates: births, school and graduation, first jobs, moves, marriages and children. Then add smaller moments that matter to you, such as trips, achievements and pets. Ask older relatives for dates and stories, and check them against documents such as certificates and old letters. The age column shows how old you were at each milestone, which makes the timeline easy to read. Add future goals with the Goal category, and the timeline will show your next upcoming milestone.
Turning a Timeline into a Chart
A table is easy to edit, but a chart can make a timeline more visual for presentations and posters. In Excel, select the year or date column and a column of numbers, such as the years after the first event, then insert a scatter chart and add data labels with the event names. In Google Sheets, the timeline chart type works with a date column and labels. For a quick printed timeline, you can also copy the events into a Word document or slide and draw a line with markers.
Editing the Templates
Type only in the yellow cells. Replace the sample events, times and milestones with your own. In the history timeline, enter years as numbers, or use full dates if you need them. In the event day timeline, change the start time at the top and the minutes for each item; every start and end time moves automatically. In the life milestones timeline, change the date of birth and every age updates. To add more rows, copy the last filled row down so the formulas copy with it. If you share the file with a class or a team, keep a copy of the original so you can always start again from a clean version.
Timeline Ideas
Not sure where to start? Popular timeline topics include a country’s history, an inventor’s life, the story of a company, the history of your school or town, a sports team’s championships, a couple’s relationship for a wedding or anniversary, and a child’s first years. For events, try a wedding day, a school sports day or a charity gala.
Related Templates
You can also check these useful templates like the family history book templates, and the teacher syllabus templates.
You may also like the office calendar templates and the daily planner templates.
Frequently Asked Questions
What is a timeline used for?
To show events in the order they happened or will happen, such as historical events, an event day schedule or the milestones of a life.
How do I enter BC dates in the history timeline?
Use negative years, for example -44 for 44 BC.
How does the event day timeline work out the times?
Each item starts when the one before it ends. Change an item’s length and every later time updates automatically.
Can I make a chart from the timeline?
Yes. Select the dates and events and insert a scatter or bar chart in Excel or Google Sheets.
Can I use the templates in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets.
