CSV Import and Export

TimeStory can import events from, and write events to, comma-separated value (CSV) files. These plain-text files can be created, viewed, and edited by spreadsheets, text editors, and other apps, and can also be imported and exported by many project-management and calendar tools.

Importing from CSV

You always import events into an existing document; this can be a newly-created document, or it can be a document which already has events and sections.

Start an import by choosing File > Import from CSV, then selecting an existing CSV file After opening the file, TimeStory will show you up to 100 rows from the file, and let you configure how you want to import it.

Validating the Import Configuration

You can press the Validate button to ask TimeStory to attempt to read the entire CSV according to your current settings, without importing anything yet. It will tell you how many valid events it found, and how many rows it had to skip because it could not extract a valid event.

Performing the Import

When you’re ready, press Import. The events will be imported and added to your document, and they will all be selected, so that you can easily adjust styling or position.

TimeStory can import quite large CSV files, containing tens of thousands of events. A large import or validation may take several seconds; as it runs, the dialog will continue to update the number of events found and the number of unusable rows it had to skip, and you can choose to stop at any time.

You can Undo and Redo a CSV import, just like any other document editing action.

Importing Date Values

Your CSV must contain at least one date column. Dates can be specified in different ways, described below. (Note that, for most purposes, you can just ignore this section, and save dates to your CSV files in a natural way, and the right thing should happen.)

If your CSV contains an End Date column, each row’s value for that column may be any of the following:

Exporting to CSV

To export a document, choose File > Export Events to CSV from the menu. This brings up the CSV Export dialog, which offers a couple of options:

The resulting CSV file has a fixed column format. Fields are separated by commas, rows are separated by carriage-return/linefeed pairs, and double quotes are used as needed to allow fields to contain those special characters. There is one header row, followed by one row per event.

The tabular format is as follows:

Date,End Date,Title,Section,Description

Note that the resulting CSV file does not contain any formatting information, such as font choices, graphic shapes, or color selections.