Importing from CSV

TimeStory can import data from comma-separated value (CSV) files, allowing you to quickly bring in events from many project-planning tools, calendars, spreadsheets, and other sources.

Configuring Your Import

To get started, create a new document (or open a document to which you wish to add the events) and choose File > Import from CSV. This will let you choose 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 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.

About 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: