Bulk Importing and Uploading Data
Members, invitees, and event attendees can be added or updated by admins through bulk imports in the dashboard and the Gradual team can import and upload bulk data like speakers, content, and events.
Dashboard Imports (Self Service)
Community Members
Import a list of community members, update members' info, and assign members to certain space(s).
Members bulk imported will not receive any welcome emails or activation notifications.
Template & Data needed
- Mandatory data: Email, First Name, Last Name, Company, Job Title
- The system will accept lowercase or uppercase text for email address
- Optional data: LinkedIn URL, Space assignment, member type
- If uploading space assignments, ensure that the Space listed is already created in the dashboard and if listing multiple spaces, divide each by “;” NOT a comma ","
- The CSV template can be found in the dashboard from the Member menu item, Member List, when selecting 'Bulk Import Members' button in the upper right
- File must be CSV and no more than 2MB in size
Import in Dashboard
💡 Pro Tip: Download the CSV template to ensure you have the correct column headers and mandatory fields to successfully upload all data
Updating existing members' profiles:
- You cannot change or update a member's email address.
- The system will replace the name, company, and title with the data provided in the import csv file.
- The system will not replace space assignments if the member is already assigned to a space(s), the system will add them to the new spaces without modifying their current space assignments.
Any missing mapping or errors will be indicated with an error message at the base of the pop-up, and the field in question will be highlighted in red. You can either correct the mapping by selecting from the drop-down, or go back by clicking 'Previous', deleting the incorrect file and uploading a corrected file
Potential errors and what they mean
- Format Error: There is a mistake in formatting for email, or text
- Duplicated Email: There is already this email address in the file
- Mandatory Field Missed: There are mandatory fields missing
- Space does not exist: The space does not exist in the dashboard, and must be added before importing
- If there are multiple errors, they are listed and divided by “,”
Note: You can download an error list of those who were unable to import from this pop-up or from the confirmation pop-up to follow
Note: Any members that are marked Pending can not be updated as they are not active members.
Any member bulk uploads will be logged in the admin activity log so you can track these actions.
Event Attendees
Register attendees to an event(s) in bulk, and assign ticket types and attendee types
Attendees bulk imported will not receive any event confirmation emails or activation notifications. They will also not receive event calendar invitations if the Google Calendar integration is enabled.
Template & Data needed
- Mandatory data: Email, First Name, Last Name, Company, Job Title
- The system will accept lowercase or uppercase text for email address
- Optional data: LinkedIn URL, Space assignment, member type, attendee type
- If uploading space assignments, ensure that the Space listed is already created in the dashboard and if listing multiple spaces, divide each by “;” NOT a comma ","
Note: You can update the attendee type of currently registered members when importing Attendees as well. Attendee type is mandatory in the CSV file for import in that instance.
- The CSV template can be found in the event dashboard from the Attendee menu item when selecting 'Import Attendees' button in the upper right
- File must be CSV and no more than 2MB in size
Import in Dashboard
💡 Pro Tip: Download the CSV template to ensure you have the correct column headers and mandatory fields to successfully upload all data
Note: You can only bulk register for one ticket type at a time
Any missing mapping or errors will be indicated with an error message at the base of the pop-up, and the field in question will be highlighted in red. You can either correct the mapping by selecting from the drop-down, or go back by clicking 'Previous', deleting the incorrect file, and uploading a corrected file
Potential errors and what they mean
- Format Error: There is a mistake in formatting for email, or text
- Duplicated Email: There is already this email address in the file
- Mandatory Field Missed: There are mandatory fields missing
- Space Does Not Exist: The space does not exist in the dashboard, and must be added before importing
- Attendee Type Does Not Exist: The attendee type does not exist in the options
- If there are multiple errors, they are listed and divided by “,”
Note: You can download an error list of those who were unable to import from this pop-up or from the confirmation pop-up to follow
Note: Any members that are marked Pending can not be registered for events as attendees as they are not active members. Any members marked Limited Approval can not be registered for webinar, meeting, in person or 1:1 match events.
Event Invites
Import a list of invitees to event(s) in bulk, and assign what ticket type they are invited to use.
Learn more about invitations here.
Invitees bulk imported will not receive any invitation emails or activation notifications.
Template & Data needed
- Mandatory data needed: Email
- The CSV template can be found in the event dashboard from the Invitations menu item when selecting '+Invitee List' button in the upper right
- File must be CSV and no more than 2MB in size
Import in Dashboard
Any missing mapping or errors will be indicated with an error message at the base of the pop-up, and the field in question will be highlighted in red. You can either correct the mapping by selecting from the drop-down, or go back by clicking 'Previous', deleting the incorrect file, and uploading a corrected file
Potential errors and what they mean
- Format Error: There is a mistake in formatting for email, or text
- Duplicated Email: There is already this email address in the file
- Mandatory Field Missed: There are mandatory fields missing
- If there are multiple errors, they are listed and divided by “,”
Note: You can download an error list of those who were unable to import from this pop-up or from the confirmation pop-up to follow
Gradual Team Imports
Speakers
Import a list of speakers to your community database, or to a specific event
- Mandatory data needed: Name, Company, Title
- Optional data: Headshot URL, LinkedIn link, Bio
- Headshot must be smaller than 5MP and will be cropped to a square
- Template - see below
Videos
Upload videos to your content library in bulk
- Mandatory data needed: Title, Video URL, Thumbnail URL, Duration
- Optional data: Speaker Name(s), Summary, Transcript, Tags, URL Slug
- Template - see below
Blogs & Resources
Upload blogs or resources to your content library in bulk
- Mandatory data needed: Title, Subtitle, Thumbnail URL, Category, Content
- Optional data: Author Name(s), Summary, Tags, URL Slug
- Template - see below
Template
To provide consistent data to the Gradual team, follow the template below. There is a tab for each type of data upload or import list and comments in each column header to guide you in providing accurate data for importing.
Link: Template for Importing and Uploading Data
This link will prompt you to make a copy of the Google Sheet to complete for your community.
Timeline
Once you've submitted the completed template, the Gradual team will audit your list and the import or upload(s) will appear in your community within the week.