Pages

Thursday, January 30, 2020

How to Make Timelines With Google Sheets

There was a time when I didn't like working with Google Sheets. That changed about ten years ago after a chat with Kern Kelley who showed me some of the things that he had created with Google Sheets. Since then I've used Google Sheets for all kinds of things from self-grading assessments to data visualizations. But as a history teacher my favorite thing to do with Google Sheets has been making multimedia timelines with the help of templates from Flippity and Timeline JS.

With the Timeline JS template you can make a multimedia timeline that includes pictures, videos, audio, maps, and text. Watch my video below to see how it works.


Flippity's timeline template doesn't have as many options as the Timeline JS template, but it's still a good option for making a timeline. The upside to Flippity's template is that it is a little easier for first-time users to follow than the Timeline JS template. My video embedded below demonstrates how to use Flippity's timeline template.