{"id":523,"date":"2024-04-03T09:08:32","date_gmt":"2024-04-03T09:08:32","guid":{"rendered":"https:\/\/staging.knowledge-base.canapii.com\/\/index.php\/docs\/importing-attendees-into-an-event\/"},"modified":"2026-03-24T08:45:07","modified_gmt":"2026-03-24T08:45:07","password":"","slug":"importing-attendees-into-an-event","status":"publish","type":"docs","link":"https:\/\/staging.knowledge-base.canapii.com\/index.php\/docs\/importing-attendees-into-an-event\/","title":{"rendered":"Importing attendees into an event"},"content":{"rendered":"<h3 style=\"font-size: 1.05em;margin-top: 10px;margin-bottom: 4px\">\u00a0<\/h3>\n<div style=\"background: #eef4ff;border-left: 4px solid #3b82f6;padding: 12px 16px;margin: 16px 0;border-radius: 4px\"><strong>Note:<\/strong><\/p>\n<p>If an attendee is imported into your event, they will not need to use a ticket to register, therefore any custom registration attributes that are not included within the import will not be captured in their attendee profile. These can be edited on an individual attendee basis.<\/p>\n<\/div>\n<h3 style=\"font-size: 1.05em;margin-top: 10px;margin-bottom: 4px\"><strong>To import attendees:<\/strong><\/h3>\n<p>Navigate to your event&#8217;s <strong>attendees<\/strong> page on the event Console sidebar.<\/p>\n<ul>\n<li>Click on the <strong>import<\/strong> button.<\/li>\n<li>Click on the\u00a0<strong>show guide<\/strong> option to see what information is required and what information is optional. The headers in your CSV file must match exactly to what is shown in this guide in order for your fields to be pulled through accurately.<\/li>\n<li>Choose your file. Once the file has been processed a data validation window will appear to show you any errors that may restrict an entry from being imported.<\/li>\n<\/ul>\n<div style=\"background: #eef4ff;border-left: 4px solid #3b82f6;padding: 12px 16px;margin: 16px 0;border-radius: 4px\"><strong>Note:<\/strong><\/p>\n<p>When doing multiple imports of your attendee list, leaving the columns blank will retain the data from the previous import.\u00a0<\/p>\n<\/div>\n<h4 style=\"font-size: 1em;margin-top: 8px;margin-bottom: 4px\">Including passwords:<\/h4>\n<p>If you import a user who already has an account with Canapii, any password listed in the password column will not be carried over into their profile. Their original existing password will still be valid<\/p>\n<p>Users who are imported without a password will need to use the forgot password option to set a new password OR use the <strong>sign in without a password<\/strong> option that appears on the login page once their email has been entered.<\/p>\n<div style=\"background: #fef2f2;border-left: 4px solid #ef4444;padding: 12px 16px;margin: 16px 0;border-radius: 4px\"><strong>Warning:<\/strong><\/p>\n<p><strong>Note<\/strong>: if an attendee has already registered for your event (system will use email as a unique identifier to locate duplicates) the existing attendee information will not be updated with the new imported attendee data.<\/p>\n<\/div>\n<h4 style=\"font-size: 1em;margin-top: 8px;margin-bottom: 4px\">Importing registration fields with multiple answers<\/h4>\n<p>In the event that you would like to import a user and include their answers to a &#8220;multiple selection&#8221; style registration field, you simply need to separate each of the multiple choices with a semi colon (;). Do not include any spaces between the multiple options. For example if you wanted to import a user who&#8217;s multiple answers to a regsitration field were: &#8220;a,b,d and g&#8221; under the appropriate import header you would list these as &#8220;a;b;d;g&#8221;<\/p>\n<h3 style=\"font-size: 1.05em;margin-top: 10px;margin-bottom: 4px\">How to send a welcome email to newly imported attendees:<\/h3>\n<p>Upon previewing the newly imported attendees, please ensure that <strong>send welcome email<\/strong> &amp; <strong>overwrite existing<\/strong> are ticked &amp; then select import rows.<br \/><img decoding=\"async\" class=\"article-image\" loading=\"lazy\" src=\"https:\/\/staging.knowledge-base.canapii.com\/\/wp-content\/uploads\/2026\/03\/image-png-Jun-21-2022-03-11-10-34-PM.png\" style=\"max-width: 100%;height: auto\" \/><\/p>\n<p>Upon selecting this, the attendees would have been imported &amp; also received a welcome email.\u00a0\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0 Note: If an attendee is imported into your event, they will not need to use a ticket to register, therefore any custom registration attributes that are not included within the import will not be captured in their attendee profile. These can be edited on an individual attendee basis. To import attendees: Navigate to your [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_crdt_document":"","footnotes":""},"doc_category":[29,8],"doc_tag":[],"class_list":["post-523","docs","type-docs","status-publish","hentry","doc_category-attendees","doc_category-people"],"year_month":"2026-04","word_count":407,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"Canapii","author_nicename":"Canapii","author_url":"https:\/\/staging.knowledge-base.canapii.com\/index.php\/author\/administrator\/"},"doc_category_info":[{"term_name":"Attendees","term_url":"https:\/\/staging.knowledge-base.canapii.com\/index.php\/docs-category\/attendees\/"},{"term_name":"People","term_url":"https:\/\/staging.knowledge-base.canapii.com\/index.php\/docs-category\/people\/"}],"doc_tag_info":[],"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/staging.knowledge-base.canapii.com\/index.php\/wp-json\/wp\/v2\/docs\/523","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/staging.knowledge-base.canapii.com\/index.php\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/staging.knowledge-base.canapii.com\/index.php\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/staging.knowledge-base.canapii.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/staging.knowledge-base.canapii.com\/index.php\/wp-json\/wp\/v2\/comments?post=523"}],"version-history":[{"count":1,"href":"https:\/\/staging.knowledge-base.canapii.com\/index.php\/wp-json\/wp\/v2\/docs\/523\/revisions"}],"predecessor-version":[{"id":993,"href":"https:\/\/staging.knowledge-base.canapii.com\/index.php\/wp-json\/wp\/v2\/docs\/523\/revisions\/993"}],"wp:attachment":[{"href":"https:\/\/staging.knowledge-base.canapii.com\/index.php\/wp-json\/wp\/v2\/media?parent=523"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/staging.knowledge-base.canapii.com\/index.php\/wp-json\/wp\/v2\/doc_category?post=523"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/staging.knowledge-base.canapii.com\/index.php\/wp-json\/wp\/v2\/doc_tag?post=523"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}