Updated January 21, 2026
First, prepare/access your Google Drive:
- You will need a Google account to be able to work with Google Drive. Create a Google account if you don’t have one already. If you have a Google account, be sure you can log in to it and access Google Drive.
- Create a folder for this class in your Google Drive: perhaps named "DIGIT-100", "introDH", or something convenient for you to quickly locate files you are working on. Make sure you know how to find your folder reliably.
Now, you need a Google Sheet to start from, as well as Google Sheet template to consult:
- I have created a starter Google Sheet for you to build on with this assignment. Open my starter file.
- On my starter file, go to File > Make a copy. You’ll open a window like this:

- From that window, click on the Folder “My Drive” and find the arrow that lets you navigate to file directories you have created in your Google Drive. Find the folder you made for our class, and click “OK”. (Don't worry about sharing or copying comments; you can leave those boxes unchecked.)
- Now, find your way to your Google Drive, and your folder, and open the Google Sheet you just copied to your space.
- To learn what the various fields are for in this sheet, consult this helpful sheet from TimeMapper with explanations of the column headings and the geo-mapping formula.
- On your Google Sheet, click on File > Share > Publish to the Web. This is ALSO the link you will use to publish your TimeMapper on its web form.
Now you are ready to share your Google Sheet with TimeMapper to build a web visualization.
- Visit the TimeMapper site to fill out the web form.
- Use the green Share Button to retrieve the link for the Data Source.
- Please provide a title that includes your name. (This helps me to keep track of each of you when I have a million tabs open.)
- You’ll see a prompt for creating an account with TimeMapper. Do this if you wish, or you may choose to remain anonymous.
- In Type of Data View, select Timemap.
- Leave the default settings for the last two options, and click the “Publish” button at the bottom.
My starter TimeMapper for our class is available from this link: https://timemapper.okfnlabs.org/anon/8m8cmr-dr-bs-starter-timemapper. Your link is probably longer and full of gibberish if you remained anonymous. That is okay. You may find that you want a shorter custom link, and for that I recommend bit.ly or another custom link-shortener that you know and love. You can create a custom link with your name in it if you wish.
Log in to Canvas and find the assignment to submit your two TimeMapper URLs:
- Your Google Sheet (the link from the green Share button)
- Your TimeMapper visualization