View Source

Spreadsheet Format

Each row represents an event on the timeline. The Timeline spreadsheet requires exact data labels. Add these to your spreadsheet's first row exactly as they are written on this table.

Column	1	2	3	4	5	6	7	8	9	10	11	12
Label	id	startdate	enddate	title	description	image	link	icon	importance	low_threshold	high_threshold	date_display
Data Type	plain text	plain text	plain text	plain text	plain text	plain text	plain text	plain text	number	number	number	plain text
Contents	A short, unique id for the event	Marks the start date for the event in plain text	Marks the end date for the event inplaintext	The label for the event. This will appear on the timeline.	Describes the event. This will pop up on the timeline when a user clicks the event's label.	An image URL. This adds an image link to the event.	A URL. This adds a link to the event'spopup.	An image filename. This adds an icon next to the event's label on the timeline.	Represents the relative importance of the event. This determines the event's size and visibility on the timeline.	Determines the minimum zoom value at which the event is visible on the timeline. Note: Make sure this value is different than high_threshold; otherwise, your event won't show up	Determines the maximum zoom value at which the event is visible on the timeline. Note: Make sure this value is different than low_threshold; otherwise, your event won't show up	A variable that determines how a given day appears on the timeline. Note: Options are "year", "month", "day", "hour", or "none" (hides the date)
Required		x		x	x

Customization Options

Go to Common Customization Options for more settings

Source of events

sets the data source

Enter the link to your spreadsheet
Learn more at "Data source url" in Common Customization Options

Title of timeline

sets the title above the timeline

Enter a title

Description

describes the data represented in the timeline

Type in a short description
By default, the description is only visible when a user clicks the "info" link
Set "Show the description?" to True to show the description when your timeline loads

Center date of timeline

sets the initial center of the timeline

Enter a date
Use the DD/MM/YYYY format

Initial zoom of timeline

sets the initial perspective of your timeline

Type in a number -- the lower the number, the shorter the time span
Use these guidelines to choose a zoom number:
- 60: show 1,000 years of the timeline
- 55: show 350 years of the timeline
- 50: show 100 years of the timeline
- 45: show 35 years of the timeline
- 40: show 10 years of the timeline
- 35: show 3 years of the timeline
- 30: show 10 months of the timeline
- 25: show 3 months of the timeline
- 20: show 1 month of the timeline
- 15: show 10 days of the timeline
- 10: show 3 days of the timeline
- 5: show 8 hours of the timeline

Minimum zoom of timeline

controls the minimum zoom factor of the timeline

Type in a number (1 - 100)

Maximum zoom of timeline

controls the maximum zoom factor of the timeline

Type in a number (1 - 100)

Image lane height

controls the height of the images at the top of the timeline

Type in a number

Maximum # of Popups

sets how many popups to keep open at one time

Type in a number
After you open the maximum number of popups, the first opened popup will close

Show the footer?

displays the date of an event and "previous" and "next" buttons at the bottom of the timeline

True shows the footer
False hides the footer

Show zoom bar?

adds a zoom bar to the timeline

True shows the zoom bar
False hides the zoom bar