Event Organiser CSV Import

First, download the CSV Template.

Use this guide along with the Event Organiser CSV Template.xltx spreadsheet included to create your list of events to import into the Event Organiser calendar plugin.

NOTE: When saving your event information, we recommended saving the document 2 times: once as a regular Excel spreadsheet (xls/xlsx) and then as a CSV.

Using the template

The template includes 12 total fields and most popular fields are prepopulated in the first main row of the spreadsheet. This includes:

  • Column A: Title
  • Column B: Start date/time
  • Column C: End date/time
  • Column D: Recur until
  • Column E: Recurrence schedule
  • Column F: Recurrence frequency
  • Column G: Schedule metadata
  • Column H: Content
  • Column I: Venue
  • Column J: Categories
  • Column K: Included dates
  • Column L: Excluded dates

The first row of information is there for display only. Either delete that row or overwrite it with your own content.

Column A: Title

The title is the name of the event that you want to display.

Column B: Start date/time

This is the starting date and time of your event. This field should be formatted as yyyy-mm-dd hh:mm. Example: 2016-12-25 14:00 which translates to December 25, 2016 2:00pm.

NOTE: If your event is all day, only enter the date.

Column C: End date/time

This is the ending date and time of your event. The formatting is the same as the start date/time.

Column D: Recur until

If your event is recurring, this will specify the end date for the event. If it is occurring for the foreseeable future (such as a holiday), it is suggested to put the date far enough out so that it remains on the calendar (such as 2020-01-01).

Column E: Recurrence schedule

This will specify how often the event occurs. The options are:

  • once
  • daily
  • weekly
  • monthly
  • yearly
  • custom

For example, if your event happens every two weeks, you will fill in with weekly and then add in the value for Recurrence frequency.

NOTE: This field must always be filled. If your event will only happen once, fill it in with once.

Column F: Recurrence frequency

This indicates the frequency of the event. The only valid values are numbers. For example, if your event happens every two weeks, you will fill in with 2.

NOTE: This field must always be filled. If your event will only happen once, fill it in with 1.

Column G: Schedule metadata

This indicates the day of the event (if it is recurring). The options are:

  • SU
  • MO
  • TU
  • WE
  • TH
  • FR
  • SA

This field is only required if you selected custom on Recurrence schedule.

Column H: Content

This is where you will input the description of the event. It is possible to use HTML in the field. The primary usage for HTML would be to create extra paragraphs which can be accomplished by wrapping the paragraph in <p> tags. Example: <p>Content goes here.</p>

Column I: Venue

You can specify the venue for the event here. NOTE: You must create the venues beforehand. The value for the field is the slug of the venue. You can find the venue slug by going to Events -> Venues and then copying the slug and pasting it into the field.

Column J: Categories

You can specify the categories for the event here (if applicable). NOTE: You must create the categories beforehand in WordPress under Events -> Categories. If you have multiple categories, separate them with a comma. Example: category 1, category 2, subcategory 1. Unlike the venues, you do not need to insert the slug name, only the full category name.

Column K: Included dates

If your recurring event has a date outside of the usual schedule, include it here. The valid format is yyyy-mm-dd and is comma separable.

Column L: Excluded dates

If your recurring event has a date where no event will be held, include it here. The valid format is yyyy-mm-dd and is comma separable.