If you have a large number of events to add to the Calendar, you can choose to import the events using a CSV (Comma-Separated Values) file.

Create an Event Table using Excel

Create a new blank spreadsheet and add the following header columns:

Column Name

Format

Example

1 - date

General

12/20/2018 (mm/dd/yy)

2 - startTime

General

16:00 (HH:MM 24 Hour time)

3 - duration

General

16:00 (HH:MM 24 Hour time)

4 - description

General

Add each new event on a separate row:

When you are finished editing the table, select Save As, then select the CSV (Comma delimited) (.csv) file format:

Select Save.

Excel may warn that "Some features in your workbook might be lost" by saving your spreadsheet in CSV format. If you receive this warning, select Yes to keep using the format:

Create an Event List using a Text Editor

Create a new plain text file using a text editor eg. Notepad or TextEdit, and add the following header row, separated by a comma "," with no spaces:

Field Name

Example

1 - date

12/20/2018 (mm/dd/yy)

2 - startTime

16:00 (HH:MM 24 Hour time)

3 - duration

16:00 (HH:MM 24 Hour time)

4 - description

Add each new event on a separate row:

When you are finished editing the text file, select Save As or Save.

If required, append the file name with the extension ".csv":


Import the CSV

Select Calendar from the Boards tab:

Select the Board or Committee the events are for:

Select Import CSV:

Select the CSV file from your computer.

Review the events to be imported:

Select a field to edit it:

Deselect an event to exclude it from the import:

Select Start:

Your events will now be imported, to view the events select the month they fall into:

Did this answer your question?