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. 

Below, we'll dive in to 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 Excel spreadsheet. Required columns are noted as such. The order listed below is the preferred order of the columns.

***

View Sample Full Event Data Spreadsheet

***

Event ID

*Required. Each event needs its own unique ID. You won't see this ID again, it's used solely for the import. Most commonly, the name of the event is used as the ID for ease.

Name

*Required. This one is just the name of your event!

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 in your site, then label the events in this spreadsheets 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.

<< Back to Main Page

Did this answer your question?