--- title: How Do I Import Registrations? description: You can import registrations you received outside of ActivityHero using a CSV file. This allows you to have all your camp and class enrollments in one place. --- [Skip to content](https://help.activityhero.com/importing-registrations-into-activityhero#main-content) [![](https://help.activityhero.com/hs-fs/hubfs/ActivityHero%20Logo.png?width=200&height=151&name=ActivityHero%20Logo.png)](https://www.activityhero.com/) Open main navigation Close main navigation - [School District Support](https://support.activityhero.com/?utm_source=activityherohelp&utm_medium=referral&utm_content=button) [School District Support](https://support.activityhero.com/?utm_source=activityherohelp&utm_medium=referral&utm_content=button) How can we help? - There are no suggestions because the search field is empty. 1. [Help Center](https://help.activityhero.com/?hsLang=en) 2. [Help for Activity Providers](https://help.activityhero.com/help-for-activity-providers?hsLang=en) 3. [Managing Activity Registrations](https://help.activityhero.com/help-for-activity-providers?hsLang=en#managing-activity-registrations) # How Do I Import Registrations? ## Add your registration data to ActivityHero in bulk using import templates. Save time and streamline your setup process by uploading all your registrations in bulk with just a few simple steps. For an overview of importing in ActivityHero for an idea about how locations, activities, sessions, and other data are related to each other check out our help article [How do I import data into ActivityHero?](https://help.activityhero.com/hc/en-us/articles/360061447891-importing-activities-locations-and-sessions?hsLang=en)   ![10-2](https://help.activityhero.com/hs-fs/hubfs/10-2.png?width=670&height=136&name=10-2.png) 1\. Download a sample registration template by clicking the **Download sample registrations csv** button. The downloaded file will contain one line of sample data. Actual ActivityHero registration data will not be downloaded.  2\. Add your registration data into the CSV file. - Sample Data - Remember to remove the first row of sample data once you’ve added some of your own data. - Session ID - To associate the registrations to the correct session, the activity\_schedule\_id must be included. The activity\_schedule\_id is also known as the Session ID and can be found on your session in Sessions & Content Manager \> Session: Session ID. ![8-1](https://help.activityhero.com/hs-fs/hubfs/8-1.png?width=624&height=223&name=8-1.png) - Spot Count - be sure to enter enough spots to cover the number of registrations you are importing. Each imported registration will reduce the spot count by one, and once it hits 0 spots, the remaining registrations will be Waitlisted. - Custom Questions - If your registration forms require custom questions, they need to be added to the registration upload template.  Create a new column at the end of the template. For the column heading, copy/paste the custom question name. This must be exactly as it shows in your registration forms to prevent validation errors. For example, if the custom question is named Student ID, the heading must be "Student ID". For more information about Custom Questions and Registration forms check out our [help article](https://help.activityhero.com/hc/en-us/articles/115005631786-how-do-i-customize-my-registration-forms-?hsLang=en). 3\. Upload your CSV file by clicking the **Upload a new file** button. Be sure to select the Registration file type. 4\. After uploading your CSV file, click the **Validate** button to see if your data is ready for import.  ![11-2](https://help.activityhero.com/hs-fs/hubfs/11-2.png?width=250&height=153&name=11-2.png) 5\. If there are errors, you will see Validation Failed. Click **View Report** to inspect the reason for the failure. Correct any errors, and then repeat step 3. For tips on frequent validation errors check out the section below. 6\. When the file is validated successfully, the green 'Run' button will be available. Select this button to begin importing your information. This can take a few minutes to complete the import. ![12-1](https://help.activityhero.com/hs-fs/hubfs/12-1.png?width=281&height=183&name=12-1.png) ### Common Registration Validation Errors Below is a list of common validation errors and how you might address them: **Missing Data** - One of the most frequent issues when importing new registrations is missing data in required fields. To avoid this, make sure to carefully check your template for all necessary fields before exporting it as a CSV. **Required Registration Form Data** - In addition to general required fields, any data marked as *required* on your registration form must also be included in the registration import template. This includes any *Custom Questions* set as required. Additionally, the column header for each required custom question must match exactly as it appears in your custom questions. For more information on registration forms and custom questions, check out our [help article](https://help.activityhero.com/hc/en-us/articles/115005631786-how-do-i-customize-my-registration-forms-?hsLang=en). ### Registration Data Fields **\* required fields** **\*\* required if the user has not registered on ActivityHero before** - \* activity\_schedule\_id or external\_schedule\_id - At least one is required - \*\* user\_email  - \*\* first\_name - \*\* last\_name - \*\* user\_zip - \* amount (enter the amount paid, if it was free, enter 0) - \* enrollment\_status (Enrolled, Cancelled, Pending, Wait Listed) - \* participant\_first\_name - \* participant\_middle\_name - \* participant\_last\_name - participant\_dob (required if your session is for specific ages) - participant\_grade (required if your session is for specific grades) - participant\_school\_name - participant\_allergies - participant\_medical\_condition - \* parent1\_first\_name - \* parent1\_last\_name - parent1\_cell - \* parent1\_email - parent1\_street\_address - parent1\_city - parent1\_state - parent1\_zip - parent1\_country - parent2\_first\_name - parent2\_last\_name - parent2\_cell - parent2\_email - parent2\_street\_address - parent2\_city - parent2\_state - parent2\_zip - parent2\_country - authorized1\_name (adult who is authorized to pick up or sign in/out the participant) - authorized1\_cell - authorized1\_relation - authorized2\_name - authorized2\_cell - authorized2\_relation - Additional authorized adults can be added as authorized3\_name, authorized3\_cell, authorized3\_relation, and so on. - emergency1\_name (emergency contact) - emergency1\_cell  - emergency1\_relation (eg: mother, father, aunt) - emergency2\_name - emergency2\_cell - emergency2\_relation (up to 5 emergency contacts can be included: label them emergency3, emergency4, emergency5) - authorized1\_name (authorized persons for picking up or dropping off) - authorized1\_cell - authorized1\_relation (up to 10 emergency contacts can be included: label them autorized2... to authorized10) - hospital\_name - physician\_name - physician\_phone - insurance\_company - sibling\_request (Names of siblings who are also attending) - special\_request  - alt\_price\_type (blank for session price, session\_alt\_price for alternate price,  session\_alt2\_price if Tiered Pricing is enabled) - subscribed (default is "FALSE". Set to "TRUE" if the user should receive ActivityHero email newsletters. Providers need to first import users before they can be subscribed to provider marketing emails.) - external\_registration\_id (a unique identifier from your system) - sis\_student\_id (a unique student ID from a student information system) - room\_num (a field used to group students into classes or rooms) Contact support@activityhero.com if you have questions or problems.   - [Getting Started](https://help.activityhero.com/getting-started?hsLang=en#main-content) - [Prospective Activity Providers](https://help.activityhero.com/getting-started?hsLang=en#prospective-activity-providers) - [Completing your Business Listing](https://help.activityhero.com/getting-started?hsLang=en#completing-your-business-listing) - [Help for Families](https://help.activityhero.com/help-for-families?hsLang=en#main-content) - [Signing Up for ActivityHero FAQ](https://help.activityhero.com/help-for-families?hsLang=en#signing-up-for-activityhero-faq) - [Navigating ActivityHero](https://help.activityhero.com/help-for-families?hsLang=en#navigating-activityhero) - [Account Management](https://help.activityhero.com/help-for-families?hsLang=en#account-management) - [Activity Registration](https://help.activityhero.com/help-for-families?hsLang=en#activity-registration) - [Writing a Review](https://help.activityhero.com/help-for-families?hsLang=en#writing-a-review) - [Payments & Invoices](https://help.activityhero.com/help-for-families?hsLang=en#payments-invoices) - [Hero Rewards Loyalty Program](https://help.activityhero.com/help-for-families?hsLang=en#hero-rewards-loyalty-program) - [Gift Cards](https://help.activityhero.com/help-for-families?hsLang=en#gift-cards) - [Referrals & Affiliate](https://help.activityhero.com/help-for-families?hsLang=en#referrals-affiliate) - [Help for Activity Providers](https://help.activityhero.com/help-for-activity-providers?hsLang=en#main-content) - [Activity Setup - In-Person & Online](https://help.activityhero.com/help-for-activity-providers?hsLang=en#activity-setup-in-person-online) - [Prices, Discounts & Payment Plans](https://help.activityhero.com/help-for-activity-providers?hsLang=en#prices-discounts-payment-plans) - [Managing Sessions](https://help.activityhero.com/help-for-activity-providers?hsLang=en#managing-sessions) - [Reviews](https://help.activityhero.com/help-for-activity-providers?hsLang=en#reviews) - [Listing On-Demand Activities](https://help.activityhero.com/help-for-activity-providers?hsLang=en#listing-on-demand-activities) - [Registration Forms & Deadlines](https://help.activityhero.com/help-for-activity-providers?hsLang=en#registration-forms-deadlines) - [ActivityHero Services, Business Marketing & Analytics](https://help.activityhero.com/help-for-activity-providers?hsLang=en#activityhero-services-business-marketing-analytics) - [Communication Tools](https://help.activityhero.com/help-for-activity-providers?hsLang=en#communication-tools) - [Payments, Refunds & Receipts](https://help.activityhero.com/help-for-activity-providers?hsLang=en#payments-refunds-receipts) - [Managing Activity Registrations](https://help.activityhero.com/help-for-activity-providers?hsLang=en#managing-activity-registrations) - [Registration Links & Widgets](https://help.activityhero.com/help-for-activity-providers?hsLang=en#registration-links-widgets) - [Payments & Adjustments](https://help.activityhero.com/help-for-activity-providers?hsLang=en#payments-adjustments) - [Stripe](https://help.activityhero.com/help-for-activity-providers?hsLang=en#stripe) - [API](https://help.activityhero.com/api?hsLang=en#main-content) - [API for Registrations](https://help.activityhero.com/api?hsLang=en#api-for-registrations) - [API for Activity Schedules](https://help.activityhero.com/api?hsLang=en#api-for-activity-schedules) - [Contact Support](https://help.activityhero.com/contact-support?hsLang=en) [![Help on ActivityHero](https://help.activityhero.com/hs-fs/hubfs/ah_logo.png?width=24&height=24&name=ah_logo.png "Help on ActivityHero")](https://www.activityhero.com) [Submit a Ticket ↗](https://cgcag.share.hsforms.com/2cz7UyPgsStmXxM9oGoM2Uw) [List your Business ↗](https://activityhero.com/business-wizard) [School District Support↗](https://support.activityhero.com?utm_source=activityherohelp&utm_medium=referral&utm_content=footer)