Import a CSV or Excel File

Preceden allows you to import Comma Separated Value (CSV) and Excel files in order to quickly add events and layers to your timeline.

If you are on a paid plan, you can access the import feature by clicking the Import CSV link above your timeline.
From there, select Choose File, pick the CSV or XLSX file, then click the Import button.

If there are issues with any of the events in the file, Preceden will give you the details and won't import any of them.

File Format

Here is an example of a valid CSV file:
You can download this example CSV  here.
The CSV file must have exactly 11 columns, though only 3 are required to have values. The header row is optional.
# Column Name Description
1 Layer Name (required) The name of the layer to add the event to.

If you specify a layer name that does not exist on the timeline already, it will be created during the import.
2 Event ID (optional) The ID of the event. 

If set, the import will update the existing event instead of creating a new event. You'll likely only have this set if you're importing a CSV that you previously exported from Preceden.
3 Event Name (required) The name of the the event.
4 Description (optional) The description of the event.
5 Start Date (required) The start date of the event.

The date must be in  a format that Preceden supports.
6 Approximate? (optional) Whether or not the start date is approximate. 

Valid values are yes or no. Defaults to no.
7 End Date (optional) The end date of the event.

The date must be in  a format that Preceden supports.
8 Approximate? (optional) Whether or not the end date is approximate.

Valid values are yes or no. Defaults to no.
9 Milestone? (optional) Whether or not to designate the event as a milestone.

Valid values are yes or no. Defaults to no.
10 Icon (optional) One of the following values:

solid circle, regular circle, solid triangle, regular triangle, solid star, solid play, solid diamond, solid bolt, solid cloud, solid heart, solid sun, solid lightbulb, solid megaphone, solid arrow alt right, solid hand point right, solid redo, solid undo, solid times, solid crosshairs, solid certificate, solid exclamation triangle, solid smile, solid frown, solid skull, solid flag, solid check, solid check square, solid file, solid comment, solid comments, solid comments dollar, solid filter, solid shield, solid bullseye, solid bell, solid bullhorn, solid burn, solid calendar alt, solid chevron circle right, solid rocket, solid money bill alt, solid credit card, solid briefcase, solid suitcase, solid dollar sign, solid badge dollar, solid hand holding usd, solid chart bar, solid chart line, solid analytics, solid poll, solid user chart, solid file chart line, solid hands helping, solid question circle, solid exclamation circle, solid building, solid pencil, solid envelope, solid folder, solid book, solid book open, solid user, solid users, solid male, solid female, solid running, solid gift, solid chart pie, solid podium, solid city, solid mountain, solid phone, solid presentation, solid cabinet filing, solid hashtag, solid tv, solid mobile alt, solid gamepad, solid person booth, solid video, solid mask, solid ad, brand youtube, brand instagram, brand twitter, brand amazon
Defaults to solid circle.

Note that the icon will only display on your timeline if you leave the end date of the event blank.
11 Color (optional) A valid six digit hex code with or without the leading #. Example: #FF0000 or FF0000. Can also be random in which case Preceden will randomly select a color from the color palette.

Defaults to  random.

If all went well, you'll be redirected back to your timeline with the new events:


Is there a limit on the number of events I can import?

CSV imports work well for up to 500 events, but after that you may see an error due to how long it takes to process the import. It's still possible to import to your timeline, you'll just need to email it to us and we can import it to a timeline on our end. Email us at and attach your CSV and we can take care of it.

My imported timeline has events that are missing letters, what can I do?

This can happen when there are problems with a CSV file's encoding. On Windows, try saving the CSV file with UTF-8 encoding and try the import again:

I'm having problems. Who can I contact?

If you run into any problems with your import, please feel free to shoot us an email at any time: Please include the CSV file you are trying to import and any other relevant information.

Still need help? Contact Us Contact Us