Import a CSV or Excel File
You can import Comma Separated Value (CSV) and Excel files to quickly add events and layers to your timeline.
We recommend trying our Bulk Editor before spending much time building a spreadsheet by hand. It gives you a spreadsheet-like interface tailored to Preceden.
If you are on a paid plan, you can access the import feature by clicking the Share button above your timeline, then the Spreadsheet item. In the dialog that opens, click the Spreadsheet Import heading to expand that section, then click the Import a Spreadsheet link:
From there, choose the CSV or XLSX file you want to import, then click the Import button.
File Format
Preceden expects the spreadsheet file to be in this format:
You can download this example Excel file.
The file must have exactly 8 columns, in the order below, and the first row has to name them. The importer reads columns by position, so a file with the right columns in the wrong order is rejected rather than reordered. Only 3 of the 8 are required to have values:
| # | 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 only have this set if you're importing a spreadsheet that you previously exported from Preceden. It's not something you need to come up with on your own. |
| 3 | event_name | (required) The name of the event. |
| 4 | notes | (optional) Notes for the event. |
| 5 | start_date | (required) The start date of the event. The date must be in a format that Preceden supports. You can prepend this with a tilde (~) to indicate it's approximate. |
| 6 | end_date | (optional) The end date of the event. The date must be in a format that Preceden supports. You can prepend this with a tilde (~) to indicate it's approximate. |
| 7 | icon | (optional) A Font Awesome icon name, optionally preceded by solid, regular or brand. For example, solid circle, regular star, brand twitter, or just circle, which Preceden treats as solid circle. |
| 8 | 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 no value is provided. |
When the import finishes, you'll see a confirmation message and a View your timeline now → button. Click it and your timeline opens with the new events on it:
FAQs
Is there a limit on the number of events I can import?
Yes, in two ways.
First, a timeline holds a maximum of 1,500 events, and any events already on the timeline count toward that total, so the most you can import is 1,500 minus what is already there. An import that would go over the limit is rejected before any events are added, so you won't end up with a half-imported timeline.
Second, CSV imports work well for up to 500 events at a time, 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 us to run it. Email your CSV to [email protected] and we'll import it on our end.
I exported my timeline as a CSV, edited it in Excel, and now the date format changed.
Try exporting your timeline as an Excel file instead of a CSV, or manually import the CSV into Excel before editing it.
My imported timeline has events that are missing letters. What can I do?
This usually means the CSV file's encoding is wrong. On Windows, save the file with UTF-8 encoding and run the import again:
I'm having problems. Who can I contact?
If you run into any problems with your import, email us at [email protected]. Please include the CSV file you are trying to import and anything you can tell us about what went wrong.