{"id":1896457,"date":"2019-10-18T13:19:09","date_gmt":"2019-10-18T17:19:09","guid":{"rendered":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/csv-file-examples-for-importing\/"},"modified":"2024-08-20T11:15:06","modified_gmt":"2024-08-20T15:15:06","slug":"csv-file-examples-for-importing","status":"publish","type":"post","link":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/csv-file-examples-for-importing\/","title":{"rendered":"CSV File Formatting and Examples"},"content":{"rendered":"\n<iframe loading=\"lazy\" width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/aXFdVpLeqYY\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen=\"\"><\/iframe>\n\n<p>The Events Calendar includes a&nbsp;feature that allows you to import events from other calendars, or to add a large number of events quickly from a&nbsp;CSV file.<\/p>\n\n<p>We have <a href=\"https:\/\/staging.theeventscalendar.com\/knowledgebase\/k\/importing-data-from-a-csv-file\/\">step-by-step instructions<\/a> for importing data from a CSV file in another post. The purpose of this post will be to provide files you can use to create your own imports. The Events Calendar is capable of importing a bunch of data for events, organizers, venues, tickets, and RSVPs alike and the examples in this post will provide you with a starting point as well as a reference for the files you plan to import.<\/p>\n\n<p>The bottom line is that <strong>each column in a file corresponds to information that would be entered directly in WordPress<\/strong> if you were creating an event, organizer, venue, ticket or RSVP post in the WordPress editor, If the information in the columns do not match the&nbsp;fields&nbsp;that are available in the editor, then it will not be included in the import. These examples will help you ensure that your data formats are correct before initiating the import process.<\/p>\n\n<p class=\"has-background\" style=\"background-color:var(--global-palette8)\"><strong>\ud83d\udca1<\/strong> It&#8217;s important to remember that some date formats can be rather ambiguous! For example, <code>05\/06\/2016<\/code> could be interpreted either as May 6th or as 5th June.*<br><strong>For the best results we recommend using the unambiguous <code>YYYY-MM-DD<\/code> format for all dates.<\/strong><br><span style=\"font-size: small;\">* The first one is more common in North America. If you want to use the day first and month second format, be sure to use hyphens instead of slashes (i.e. <code>05-06-2016<\/code>).<\/span><\/p>\n\n<h2 class=\"wp-block-heading\" id=\"venues\">Venues<\/h2>\n\n<figure class=\"wp-block-table\"><table><thead><tr><td>Field Name<\/td><td>Example Data<\/td><td>Field Type<\/td><td>Notes<\/td><\/tr><\/thead><tbody><tr><td>Venue Name<\/td><td>Precious Lamb<\/td><td><a href=\"#field-type-string\">String<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>Venue Description<\/td><td>A non-profit preschool.<\/td><td><a href=\"#field-type-html\">HTML<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>Venue Country<\/td><td>United States<\/td><td><a href=\"#field-type-string\">String<\/a><\/td><td>Preferably the country name.<\/td><\/tr><tr><td>Venue Address<\/td><td>2005 Palo Verde Ave<\/td><td><a href=\"#field-type-string\">String<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>Venue Address 2<\/td><td>&nbsp;<\/td><td><a href=\"#field-type-string\">String<\/a><\/td><td>Is appended to&nbsp;the Venue&nbsp;Address line upon import.<\/td><\/tr><tr><td>Venue City<\/td><td>Long Beach<\/td><td><a href=\"#field-type-string\">String<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>Venue State\/Province<\/td><td>CA<\/td><td><a href=\"#field-type-string\">String<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>Venue Zip<\/td><td>90815<\/td><td><a href=\"#field-type-string\">String<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>Venue Overwrite<\/td><td>1<\/td><td><a href=\"#field-type-string\">String<\/a><\/td><td>Should geo-coordinates be used to determine the venue location? (Pro only)<br><br><code>0<\/code> = No (default)<br><code>1<\/code> = Yes<\/td><\/tr><tr><td>Venue Latitude<\/td><td>33.7924082<\/td><td><a href=\"#field-type-string\">String<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>Venue Longitude<\/td><td>-118.1105883<\/td><td><a href=\"#field-type-string\">String<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>Venue Phone<\/td><td>+1-800-123-4567<\/td><td><a href=\"#field-type-phone-number\">Phone&nbsp;Number<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>Venue Website<\/td><td>http:\/\/www.sherlock-holmes.co.uk\/<\/td><td><a href=\"#field-type-url\">URL<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>Venue Featured Image<\/td><td>http:\/\/www.sherlock-holmes.co.uk\/wp-content\/uploads\/2016\/05\/29\/sherlock-thumb.png<\/td><td><a href=\"#field-type-url\">URL<\/a><\/td><td>This should be a direct URL to the image.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button align-center is-style-outline is-style-outline--1\"><a class=\"wp-block-button__link wp-element-button\" href=\"\/knowledgebase\/wp-content\/uploads\/2020\/09\/test-data-venue-4.csv\">Download Example File for Venues<\/a><\/div>\n<\/div>\n\n<h2 class=\"wp-block-heading\" id=\"organizers\">Organizers<\/h2>\n\n<figure class=\"wp-block-table\"><table><thead><tr><td>Field Name<\/td><td>Example Data<\/td><td>Field Type<\/td><td>Notes<\/td><\/tr><\/thead><tbody><tr><td>Organizer Name<\/td><td>George-Michael Bluth<\/td><td><a href=\"#field-type-string\">String<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>Organizer Description<\/td><td>Recently started growing a &lt;em&gt;moustache&lt;\/em&gt;.<\/td><td><a href=\"#field-type-html\">HTML<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>Organizer Email<\/td><td>boygeorge@halliburtonteen.com<\/td><td><a href=\"#field-type-email\">Email address<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>Organizer Website<\/td><td>http:\/\/fakeblock.com<\/td><td><a href=\"#field-type-url\">URL<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>Organizer Phone<\/td><td>+1-987-555-1238<\/td><td><a href=\"#field-type-phone-number\">Phone Number<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>Organizer Featured Image<\/td><td>http:\/\/halliburtonteen.com\/wp-content\/uploads\/profiles\/george-mb\/550&#215;400.jpg<\/td><td><a href=\"#field-type-phone-number\">URL<\/a><\/td><td>This should be a direct URL to the image.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button is-style-outline is-style-outline--2\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2024\/05\/Organizer-CSV-example-1.csv\">Download Example File for Organizers<\/a><\/div>\n<\/div>\n\n<h2 class=\"wp-block-heading\" id=\"events\">Events<\/h2>\n\n<p>Before importing events it is best to import or otherwise create the Organizers and Venues first. Once those are done, you can import an event and specify the unique Organizer name and Venue name that you have already added, and thus attach an event to the already imported organizers and\/or venues.<\/p>\n\n<figure class=\"wp-block-table\"><table><thead><tr><td>Field Name<\/td><td>Example Data<\/td><td>Field Type<\/td><td>Notes<\/td><\/tr><\/thead><tbody><tr><td>Event Name<\/td><td>Turtleneck Fitting<\/td><td><a href=\"#field-type-string\">String<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>Event Description<\/td><td>I &lt;em&gt;didn&#8217;t&lt;\/em&gt; invent the turtleneck, but&#8230;<\/td><td><a href=\"#field-type-html\">HTML<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>Event Excerpt<\/td><td>I&#8217;m afraid of any apex predator that lived through the &lt;strong&gt;K-T Extinction.&lt;\/strong&gt;<\/td><td><a href=\"#field-type-html\">HTML<\/a><\/td><td>This is used as the excerpt, while the description is used as the actual content.<\/td><\/tr><tr><td>Event Start Date<\/td><td>1965-12-31<\/td><td><a href=\"#field-type-date\">Date<\/a><\/td><td><code>YYYY-MM-DD<\/code> format recommended.<br>Example is for an event on December 31st,&nbsp;1965.<\/td><\/tr><tr><td>Event Start Time<\/td><td>21:30:00<\/td><td><a href=\"#field-type-time\">Time<\/a><\/td><td>The time of day that the event starts. Example is for an event starting&nbsp;at 9:30pm.<\/td><\/tr><tr><td>Event End Date<\/td><td>1966-01-01<\/td><td><a href=\"#field-type-date\">Date<\/a><\/td><td><code>YYYY-MM-DD<\/code> format recommended.<br>Example is for an event ending on January 1st, 1966.<\/td><\/tr><tr><td>Event End Time<\/td><td>00:50:00<\/td><td><a href=\"#field-type-time\">Time<\/a><\/td><td>The time of day that the event ends. Example is for an event ending&nbsp;at 12:50am.<\/td><\/tr><tr><td>All Day Event<\/td><td>FALSE<\/td><td><a href=\"#field-type-boolean\">Boolean<\/a><\/td><td>When true the event is treated as lasting all day from the beginning of the Start Date to the end of the End Date. The Start\/End Time fields are essentially ignored and can be left blank.<\/td><\/tr><tr><td>Timezone<\/td><td>America\/New_York<\/td><td><a href=\"#field-type-boolean\">String<\/a><\/td><td>This should be a valid Timezone string. Timezones can be represented in numerous acceptable ways. You can find a list of acceptable timezones sorted by continent <a href=\"http:\/\/php.net\/manual\/en\/timezones.php\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>.<\/td><\/tr><tr><td>Hide from Event Listings<\/td><td>FALSE<\/td><td><a href=\"#field-type-boolean\">Boolean<\/a><\/td><td>When true, the event will appear in Month View, but in &#8220;List&#8221; views like the outright List View, the Photo View, etc.<\/td><\/tr><tr><td>Sticky in Month View<\/td><td>TRUE<\/td><td><a href=\"#field-type-boolean\">Boolean<\/a><\/td><td>When true, the event will appear at the top of its corresponding &#8220;day&#8221; square in the Month View, regardless of other events that day at other times.<\/td><\/tr><tr><td>Event Venue Name<\/td><td>Archer&#8217;s Penthouse<\/td><td><a href=\"#field-type-comma-separated\">Comma Separated<\/a><\/td><td>Must match exactly the Venue Name of a preexisting Venue <a href=\"#single-venue-support-by-default\">(see note about multiple venues)<\/a>.<\/td><\/tr><tr><td>Event Organizers<\/td><td>Woodhouse, Chelsea S., 42<\/td><td><a href=\"#field-type-comma-separated\">Comma Separated<\/a><\/td><td>Must match exactly the Organizer Name of a preexisting Organizer, or you can use the Organizer&#8217;s post ID. You can enter multiple Organizer Names&nbsp;or&nbsp;IDs separated by commas.<\/td><\/tr><tr><td>Event Show Map Link<\/td><td>TRUE<\/td><td><a href=\"#field-type-boolean\">Boolean<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>Event Show Map<\/td><td>TRUE<\/td><td><a href=\"#field-type-boolean\">Boolean<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>Event Cost<\/td><td>500<\/td><td><a href=\"#field-type-string\">String<\/a><\/td><td>Set to 0 for a free event. Leave blank if you do not wish the cost field to appear. Otherwise, specify a single number for the event cost. This field is essentially unused when a ticketing plugin is active.<\/td><\/tr><tr><td>Event Currency Symbol<\/td><td>$<\/td><td><a href=\"#field-type-string\">String<\/a><\/td><td>&nbsp;This field is essentially unused when a ticketing plugin is active.<\/td><\/tr><tr><td>Event Currency Position<\/td><td>prefix<\/td><td>Unique<\/td><td>Sets whether the Currency Symbol is a prefix or suffix. Accepts two values &#8220;prefix&#8221; and &#8220;suffix&#8221;. When left blank the default &#8220;prefix&#8221; is used.&nbsp;This field is essentially unused when a ticketing plugin is active.<\/td><\/tr><tr><td>Event ISO Currency Code<\/td><td>USD, EUR<\/td><td><a href=\"#field-type-string\">String<\/a><\/td><td>Adds the ISO currency code when adding an event cost.<\/td><\/tr><tr><td>Event Category<\/td><td>Tacktleneck,&nbsp;Tailor<\/td><td><a href=\"#field-type-comma-separated\">Comma Separated<\/a><\/td><td>Separate multiple categories with commas. The example puts this event in two categories:&nbsp;Tacktleneck and Tailor.<\/td><\/tr><tr><td>Event Tags<\/td><td>Valet, Mission ready, PPK<\/td><td><a href=\"#field-type-comma-separated\">Comma Separated<\/a><\/td><td>Separate multiple tags with commas<\/td><\/tr><tr><td>Event Website<\/td><td>http:\/\/doyounot.com<\/td><td><a href=\"#field-type-url\">URL<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>Event Featured Image<\/td><td>http:\/\/doyounot.com\/wp-content\/uploads\/thumbs\/event.png<\/td><td><a href=\"#field-type-url\">URL<\/a><\/td><td>This should be a direct URL to the image.<\/td><\/tr><tr><td>Allow Comments<\/td><td>TRUE<\/td><td><a href=\"#field-type-boolean\">Boolean<\/a><\/td><td>When true, comments will be allowed on the event.<\/td><\/tr><tr><td>Allow Trackbacks and Pingbacks<\/td><td>FALSE<\/td><td><a href=\"#field-type-boolean\">Boolean<\/a><\/td><td>When true, trackbacks and pingbacks will be allowed on the event.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n<p class=\"has-background\" style=\"background-color:var(--global-palette8)\"><strong>\ud83d\udca1<\/strong> While it is possible to enable support for multiple venues, by default you can only assign a single venue to each event. So, while comma-separated values are technically supported for venues, this really only makes sense if multiple venue support is enabled. In general, it&#8217;s recommended you specify a single venue here.<\/p>\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button is-style-outline is-style-outline--3\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2023\/12\/CSV-file-for-example.csv\" target=\"_blank\" rel=\"noreferrer noopener\">Download Example File for Events<\/a><\/div>\n<\/div>\n\n<h2 class=\"wp-block-heading\" id=\"h-virtual-events\">Virtual Events<\/h2>\n\n<p>With Events Calendar Pro installed, you&#8217;ll have access to the following additional fields that you can import with your events.<\/p>\n\n<figure class=\"wp-block-table\"><table><thead><tr><td>Field Name<\/td><td>Example Data<\/td><td>Field Type<\/td><\/tr><\/thead><tbody><tr><td>Configure Virtual Event?<\/td><td>TRUE<\/td><td><a href=\"#field-type-boolean\">Boolean<\/a><\/td><\/tr><tr><td>Type of Event (Virtual, Hybrid)<\/td><td>Virtual<\/td><td><a href=\"#field-type-string\">String<\/a><\/td><\/tr><tr><td>Video Source URL<\/td><td>https:\/\/www.youtube.com\/watch?v=2HMV0JhnB8k<\/td><td><a href=\"#field-type-url\">URL<\/a><\/td><\/tr><tr><td>Embed Video?<\/td><td>TRUE<\/td><td><a href=\"#field-type-boolean\">Boolean<\/a><\/td><\/tr><tr><td>Linked Button Text<\/td><td>Button<\/td><td><a href=\"#field-type-string\">String<\/a><\/td><\/tr><tr><td>Linked Button<\/td><td>TRUE<\/td><td><a href=\"#field-type-boolean\">Boolean<\/a><\/td><\/tr><tr><td>Show Embed at<\/td><td>at-start<\/td><td><a href=\"#field-type-string\">String<\/a><\/td><\/tr><tr><td>Show Virtual Event Icon on Single?<\/td><td>TRUE<\/td><td><a href=\"#field-type-boolean\">Boolean<\/a><\/td><\/tr><tr><td>Show Virtual Event on all Views<\/td><td>True<\/td><td><a href=\"#field-type-boolean\">Boolean<\/a><\/td><\/tr><tr><td>Show Embed To<\/td><td>All<\/td><td><a href=\"#field-type-string\">String<\/a><\/td><\/tr><tr><td>Include Link in RSVP Email?<\/td><td>TRUE<\/td><td><a href=\"#field-type-boolean\">Boolean<\/a><\/td><\/tr><tr><td>Include Link in Ticket Email?<\/td><td>TRUE<\/td><td><a href=\"#field-type-boolean\">Boolean<\/a><\/td><\/tr><\/tbody><\/table><\/figure>\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button is-style-outline is-style-outline--4\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2023\/01\/virtual_events_example-1.xlsx\" target=\"_blank\" rel=\"noreferrer noopener\">Download Example File for Virtual Events<\/a><\/div>\n<\/div>\n\n<h2 class=\"wp-block-heading\" id=\"rsvp-fields\">RSVP Fields<\/h2>\n\n<p>Before importing RSVPs, you should ensure that the events (or other post types) they are associated with have been imported, too. These are the RSVP fields that can be imported via CSV:<\/p>\n\n<figure class=\"wp-block-table\"><table><thead><tr><td>Field Name<\/td><td>Example Data<\/td><td>Field Type<\/td><td>Notes<\/td><\/tr><\/thead><tbody><tr><td>Event Name, ID, or Slug<\/td><td>NYPL Author Series: Shane Pearlman<\/td><td><a href=\"#field-type-string\">String<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>Ticket Name<\/td><td>General Seating<\/td><td><a href=\"#field-type-string\">String<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>Ticket Description<\/td><td>Reservation for a seat in the &lt;strong&gt;Peifer Auditorium&lt;\/strong&gt;.<\/td><td><a href=\"#field-type-html\">HTML<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>Ticket Start Sale Date<\/td><td>2016-12-01<\/td><td><a href=\"#field-type-date\">Date<\/a><\/td><td>&nbsp;<code>YYYY-MM-DD<\/code> format recommended.<\/td><\/tr><tr><td>Ticket Start Sale Time<\/td><td>14:30:00<\/td><td><a href=\"#field-type-time\">Time<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>Ticket End Sale Date<\/td><td>2016-12-15<\/td><td><a href=\"#field-type-date\">Date<\/a><\/td><td>&nbsp;<code>YYYY-MM-DD<\/code> format recommended.<\/td><\/tr><tr><td>Ticket End Sale Time<\/td><td>21:30:00<\/td><td><a href=\"#field-type-time\">Time<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>Ticket Stock<\/td><td>450<\/td><td><a href=\"#field-type-integer\">Integer<\/a><\/td><td>CSV only accepts integers for ticket stock.<\/td><\/tr><tr><td>Ticket Show Description<\/td><td>Yes|No<\/td><td><a href=\"#field-type-string\">String<\/a><\/td><td>&nbsp;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button is-style-outline is-style-outline--5\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2021\/06\/The-Events-Calendar-Sample-Data-RSVP1.csv\" target=\"_blank\" rel=\"noreferrer noopener\">Download Example File for RSVPs<\/a><\/div>\n<\/div>\n\n<h2 class=\"wp-block-heading\" id=\"ticket-fields\">Tickets Fields<\/h2>\n\n<p>Before importing tickets, you should ensure that the events (or other post types) they are associated with have been imported, too. These are the tickets fields that can be imported via CSV:<\/p>\n\n<figure class=\"wp-block-table\"><table><thead><tr><td>Field Name<\/td><td>Example Data<\/td><td>Field Type<\/td><td>Notes<\/td><\/tr><\/thead><tbody><tr><td>Event Name, ID, or Slug<\/td><td>NYPL Author Series: Shane Pearlman<\/td><td><a href=\"#field-type-string\">String<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>Ticket Name<\/td><td>General Seating<\/td><td><a href=\"#field-type-string\">String<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>Ticket Description<\/td><td>Ticket for a seat in the &lt;strong&gt;Peifer Auditorium&lt;\/strong&gt;.<\/td><td><a href=\"#field-type-html\">HTML<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>Ticket Start Sale Date<\/td><td>2016-12-01<\/td><td><a href=\"#field-type-date\">Date<\/a><\/td><td>&nbsp;<code>YYYY-MM-DD<\/code> format recommended.<\/td><\/tr><tr><td>Ticket Start Sale Time<\/td><td>14:30:00<\/td><td><a href=\"#field-type-time\">Time<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>Ticket End Sale Date<\/td><td>2016-12-15<\/td><td><a href=\"#field-type-date\">Date<\/a><\/td><td>&nbsp;<code>YYYY-MM-DD<\/code> format recommended.<\/td><\/tr><tr><td>Ticket End Sale Time<\/td><td>21:30:00<\/td><td><a href=\"#field-type-time\">Time<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>Ticket Price<\/td><td>$25.00<\/td><td><a href=\"#field-type-string\">String<\/a><\/td><td>An integer without the currency symbol is also acceptable.<\/td><\/tr><tr><td>Ticket Stock<\/td><td>450<\/td><td><a href=\"#field-type-integer\">Integer<\/a><\/td><td>CSV only accepts integers for ticket stock.<\/td><\/tr><tr><td>Ticket SKU<\/td><td>GEN-AD<\/td><td><a href=\"#field-type-string\">String<\/a><\/td><td>&nbsp;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n<p>Note that only WooCommerce Tickets, not Easy Digital Downloads (EDD) Tickets, can be imported via CSV.<\/p>\n\n<p>A separate example CSV file to download is not available for WooCommerce Tickets. Please use the <a href=\"https:\/\/images.theeventscalendar.com\/kb\/uploads\/2014\/09\/The-Events-Calendar-Sample-Data-RSVP1.csv\">RSVP Fields CSV file<\/a> and, if desired, add the Ticket Price and\/or Ticket SKU columns to the CSV. Within your <code>wp-admin<\/code> Import settings, you will tell the importer which ticket type is being imported: &#8220;RSVPs&#8221; or &#8220;Tickets&#8221; meaning tickets created with WooCommerce.<\/p>\n\n<h2 class=\"wp-block-heading\" id=\"additional-fields\">Events Calendar Pro Additional Fields<\/h2>\n\n<p>In addition to the above fields, <a href=\"https:\/\/staging.theeventscalendar.com\/knowledgebase\/k\/pro-additional-fields\/\">you can add custom fields<\/a> with the&nbsp;<a href=\"https:\/\/theeventscalendar.com\/product\/wordpress-events-calendar-pro\/\">Events Calendar Pro<\/a>&nbsp;add-on. Each field you add will appear in the CSV Importer&nbsp;as an available field to be imported. The name of the field will be the label you typed in when you added the field. There are six field types, and the following table breaks down which types the importer accepts:<\/p>\n\n<figure class=\"wp-block-table\"><table><thead><tr><td>Field Name<\/td><td>Example Data<\/td><td>Field Type<\/td><td>Notes<\/td><\/tr><\/thead><tbody><tr><td>(Text Field)<\/td><td>I swear I had something for this.<\/td><td><a href=\"#field-type-string\">String<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>(Text Area Field)<\/td><td>Do you want ants? &#8230;because that\u2019s how you get ants.<\/td><td><a href=\"#field-type-string\">String<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>(URL&nbsp;Field)<\/td><td>http:\/\/www.algersoft.net\/<\/td><td><a href=\"#field-type-url\">URL<\/a><\/td><td>&nbsp;<\/td><\/tr><tr><td>(Radio&nbsp;Field)<\/td><td>Read a book<\/td><td><a href=\"#field-type-string\">String<\/a><\/td><td>Prefers you input&nbsp;an exact case-sensitive match to the name of an existing option in&nbsp;this custom field.&nbsp;Example selects the option &#8220;Read a book.&#8221;<\/td><\/tr><tr><td>(Checkboxes Field)<\/td><td>Boop|Yup<\/td><td><a href=\"#field-type-string\">String<\/a><\/td><td>To select multiple items separate the names of the items with a pipe bar | character. The example&nbsp;selects the two options &#8220;Boop&#8221; and &#8220;Yup&#8221;.<\/td><\/tr><tr><td>(Dropdown Field)<\/td><td>Danger Zone!<\/td><td><a href=\"#field-type-string\">String<\/a><\/td><td>Prefers you input an exact case-sensitive match to the name of an existing option&nbsp;in this custom field. Example selects the option &#8220;Danger Zone!&#8221;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n<h2 class=\"wp-block-heading\" id=\"field-types\">Field types<\/h2>\n\n<ul class=\"wp-block-list\">\n<li><strong>HTML<\/strong>: Accepts&nbsp;HTML. Further, it is run through <a href=\"https:\/\/codex.wordpress.org\/Function_Reference\/wpautop\">wpautop()<\/a>, meaning that two new line characters in a row are interpreted as a new paragraph (just like in the WordPress post\/event editor).<\/li>\n\n<li><strong>String<\/strong>: Accepts&nbsp;most any text including numbers and special characters.&nbsp;New lines are typically ignored.<\/li>\n\n<li><strong>Boolean<\/strong>: Accepts boolean values such as true&nbsp;or&nbsp;false, <em><code>1<\/code><\/em> or <code>0<\/code>, yes or no. These values are not case-sensitive, so <code>true<\/code> would also be a valid value. When left blank the default option is applied, which is typically false.<\/li>\n\n<li><strong>Integer<\/strong>:<\/li>\n\n<li><strong>Date<\/strong>: Accepts formatted dates. Preferably use the ISO 8601 date format <code>YYYY-MM-DD<\/code> as it is unambiguous (ex. <code>2015-12-31<\/code>). If you wish to use the North American &#8220;middle-endian&#8221; format, slashes are recommended&nbsp;(ex. <code>MM\/DD\/YYYY<\/code>). If you wish to use&nbsp;the international little-endian format separate it with dashes (e.g. <code>DD-MM-YYYY<\/code>).<\/li>\n\n<li><strong>Time<\/strong> &#8211; Accepts formatted hours. Preferably use the ISO 8601 format <code>HH:MM:SS<\/code> (e.g. <code>23:59:59<\/code>).<\/li>\n\n<li><strong>URL<\/strong> &#8211;&nbsp;Prefers full URLs with the protocol (e.g. <code>http:\/\/<\/code>) included.<\/li>\n\n<li><strong>Comma Separated<\/strong> &#8211; There is a certain bit of irony with this type. Accepts a comma-separated list of values&nbsp;(e.g. &#8220;Concert, Barbecue&#8221; will be interpreted as the two separate values &#8220;Concert&#8221; and &#8220;Barbecue&#8221;). If you are not exporting your data from &nbsp;Microsoft&nbsp;Excel&nbsp;or a similar tool, make sure to&nbsp;properly escape the field so the commas are not interpreted as new CSV columns.<\/li>\n\n<li><strong>Email Address<\/strong> &#8211; Accepts any string, but prefers valid email addresses.<\/li>\n\n<li><strong>Phone Number<\/strong> &#8211;&nbsp;For proper internationalization include the full phone number with a country code and leading + (e.g. <code>+1-800-867-5309<\/code>)<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>The Events Calendar includes a&nbsp;feature that allows you to import events from other calendars, or to add a large number of events quickly from a&nbsp;CSV file. We have step-by-step instructions for importing data from a CSV file in another post. The purpose of this post will be to provide files you can use to create&#8230;<\/p>\n","protected":false},"author":34,"featured_media":1955565,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_swpsp_post_exclude":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"ep_exclude_from_search":false,"footnotes":""},"categories":[126],"tags":[45],"stellar-product-taxonomy":[161],"class_list":["post-1896457","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-event-aggregator","tag-importing","stellar-product-taxonomy-the-events-calendar"],"acf":[],"taxonomy_info":{"category":[{"value":126,"label":"Importing Events"}],"post_tag":[{"value":45,"label":"Importing"}],"stellar-product-taxonomy":[{"value":161,"label":"The Events Calendar"}]},"featured_image_src_large":["https:\/\/images.theeventscalendar.com\/kb\/uploads\/2023\/02\/social-share-1024x538.png",1024,538,true],"author_info":{"display_name":"jaimem","author_link":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/author\/jaimem\/"},"comment_info":0,"category_info":[{"term_id":126,"name":"Importing Events","slug":"event-aggregator","term_group":0,"term_taxonomy_id":126,"taxonomy":"category","description":"","parent":61,"count":23,"filter":"raw","term_order":"0","cat_ID":126,"category_count":23,"category_description":"","cat_name":"Importing Events","category_nicename":"event-aggregator","category_parent":61}],"tag_info":[{"term_id":45,"name":"Importing","slug":"importing","term_group":0,"term_taxonomy_id":45,"taxonomy":"post_tag","description":"","parent":0,"count":35,"filter":"raw","term_order":"0"}],"_links":{"self":[{"href":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/1896457","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/wp-json\/wp\/v2\/users\/34"}],"replies":[{"embeddable":true,"href":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/wp-json\/wp\/v2\/comments?post=1896457"}],"version-history":[{"count":8,"href":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/1896457\/revisions"}],"predecessor-version":[{"id":1962557,"href":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/1896457\/revisions\/1962557"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/wp-json\/wp\/v2\/media\/1955565"}],"wp:attachment":[{"href":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/wp-json\/wp\/v2\/media?parent=1896457"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/wp-json\/wp\/v2\/categories?post=1896457"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/wp-json\/wp\/v2\/tags?post=1896457"},{"taxonomy":"stellar-product-taxonomy","embeddable":true,"href":"https:\/\/staging.theeventscalendar.com\/knowledgebase\/wp-json\/wp\/v2\/stellar-product-taxonomy?post=1896457"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}