Let's get started with the basics of an event import - information about the events themselves! This will let you see and click on the events in the Events tab on the backend of the site.
Video - Events Spreadsheet for Import
Watch the video above for a guide to how the columns of the events spreadsheet should work for an event import. For a more detailed look at each column in text, read on below!
Event Import Columns
Below, we'll dive into the columns listed in an event import spreadsheet. Remember, tickets and attendees will be in their own, separate sheets. Each section below represents a column that can be imported via an Excel spreadsheet. Required columns are noted as such. The order listed below is the preferred order of the columns.
Event ID
*Required. Each event needs its own unique ID. You won't see this ID again, it's used solely for the import process. Most commonly, the name of the event is used as the ID for ease.
Name
*Required. 75 character max. This one is just the name of your event! Event Names must be unique. This ensures unique SEO names.
Category
*Required. In Novi, your events are placed in categories. This allows you to link out to different pages on the frontend, so someone can find, just committee meetings for example without having to look through every single event. Determine what event categories you'd like on your site, then label the events in this spreadsheet in the appropriate category. Common categories are Signature Events, Education Classes, Webinars, Luncheons, Committee Meetings, etc.
Start Date & Time
*Required. This is the beginning date and time of your event, and it should be formatted as MM/DD/YYYY HH:MM AM/PM. If it's a multi-day event, like a conference, no need to include a time.
End Date & Time
*Required. This is the ending date and time of your event, and it should be formatted as MM/DD/YYYY HH:MM AM/PM. If it's a multi-day event, like a conference, no need to include a time.
Location
This is the name of your event's location.
For example, "ABC Conference Center"
Address 1
This is the first line of the address of your event's location.
For example, "123 Conference Drive"
Address 2
This is the second line of the address of your event's location.
For example, "Room 33"
City
This is the city of your event's location.
State
This is the state of your event's location.
Zip
This is the zip code of your event's location.
Details
These are the basic (text-only) details about your event. Most commonly included when importing events that are happening in the future.
Contact Name
This is the name of the person or company who should be contacted with questions about the event.
Contact Email
This is the email of the person or company who should be contacted with questions about the event.
Contact Phone
This is the phone number of the person or company who should be contacted with questions about the event.
Registration Starts
This is the date that registration begins for this event, in MM/DD/YYYY format.
Registration Ends
This is the date that registration ends for this event, in MM/DD/YYYY format.
Max Registrants
This is the capacity of the total event.