A .csv file, or comma separated values file, offers a significantly more flexible way of importing events than the standardized iCal format (.ics). While .ics files are standardized, they’re also quite limited in how they’re structured and what information can be included.
The only absolutely required fields are
event_begin, but you can also automatically generate categories and locations from your CSV import file.
Your CSV file must have a header row that includes the field names as listed below, e.g. “event_id,event_title,event_begin”. The header row will be used to map values to My Calendar’s data structures.
Supported CSV Fields
event_begin: Starting Date
occur_begin: Starting Date
event_end: Ending Date
occur_end: Ending Date
event_time: Starting Time
event_endtime: Ending Time
event_link: External event URL
event_link_expires: Link expiration
event_recur: Recurring frequency period: S – single, D – day, E – weekdays, W – weekly, M – month/date, U – month/day, Y – year.
event_repeats: Number of repetitions or date to repeat until. 4 = event repeats 4 times, for a total of 5 occurrences. 2022-05-25 means “repeats until May 25th, 2022”.
event_every: Recurrence frequency multiplier. D + 3 == every 3 days, 2 + W == every two weeks.
event_image: Event Image URL
event_allday: Event is all-day
event_author: Author ID
event_approved: Publishing status
event_category: Category Name or ID
category_color: Category Color
category_icon: Category Icon
category_private: Category Privacy status
event_fifth_week: Omit week 5 recurrences
event_holiday: Cancel on Holidays
event_group_id: Event Group ID
event_span: Event spans multiple days
event_hide_end: Hide end date
event_status: Event Status
event_flagged: Event Flagged as Spam
event_tickets: Event Tickets Link
event_registration: Event Registration Info
event_host: Event Host ID
event_access: Event Accessibility Data
location_preset: Location ID
event_label: Location Label
event_street: Location Street
event_street2: Location Street (2)
event_city: Location City
event_state: Location State
event_postcode: Location Postcode
event_region: Location Region
event_country: Location Country
event_url: Location URL
event_phone: Location Phone Number
event_phone2: Alternate Location Phone
event_longitude: Location longitude
event_latitude: Location latitude
event_zoom: Map zoom level
event_location: Location ID in locations table
mc_copy_location: Copy location into DB
UID: Unique event ID. If an event exists with this UID already, it will be updated instead of added.
event_added: Date this event was added to source calendar