If your program uses segments, the Members import page lets you add new members and update existing ones in bulk. You download an Excel file, fill it in, and upload it back. You can also use it to set or update segment answers for many members at once, instead of editing each profile individually.
This article applies to programs that use segments. For an overview of how segments work, see Segments: Custom Profile Fields. If your program does not use segments, see Inviting Members to Your Program.
When to use the spreadsheet import
The spreadsheet import is useful when you want to:
- Add a group of new members to your program
- Pre-fill segment answers for a group of members before they log in
- Correct or update answers for multiple members at once
- Migrate profile data from another system
Step 1: Download the template
- Go to your program dashboard and open the Members tab.
- Click the upload icon beside the + button to open the Import Users page.
- Click Download Template to get a blank template, or Download Members to get your current members in the same format.
Both files are Excel (.xlsx) files. They have the standard member columns plus one column for each segment your program has configured. Use Download Template when you are adding new members. Use Download Members when you want to update people who are already in your program, because their current answers are already filled in.
Always start from a downloaded file rather than building one from scratch. The column names must match exactly, and the downloaded file gives you the correct names automatically.
Step 2: Fill in the spreadsheet
Open the file in your spreadsheet application of choice. Add a row for each new member, or update the rows of existing members.
A few things to keep in mind:
- Only name and email are required. The mentor column is optional: enter yes for a mentor and no for a mentee. If you leave it blank, the member is added as a mentee. Mentors added this way are approved automatically.
- Tags listed in your file that do not exist yet are created for you during the import. Separate several tags with a comma.
- Select-type segments (single-select and multi-select fields) only accept values that match one of the defined options for that segment. Capitalization does not matter, and you can use the English or the French label of an option, but the spelling must match.
- Multi-select segments accept multiple values. Separate each value with a semicolon (;), not a comma.
- Leave a cell blank if you do not want to change that member's current answer. Blank cells are treated as no change, not as a deletion.
If you are unsure what the valid options are for a segment, check the segment configuration on your Segments page, or look at the values already in the downloaded file for existing members.
Step 3: Upload and validate the file
- Go back to the Import Users page.
- Select your filled-in file and click Upload & Validate.
Mentorly checks every row before saving anything. If there are errors, nothing is saved. See the next section for how to fix them.
If all rows pass, click Confirm Import (N members). Mentorly then tells you how many members were created and how many were updated.
Step 4: Send invitations
Importing does not email anyone. Members you added are created waiting for an invitation. Back on the Members tab, you will see a notice that some members are pending an invitation. Click Send invitation emails when you are ready.
Good to know:
- If a row has the email of someone who is already a member, that member is updated.
- If a row has the email of a member you archived, Mentorly brings them back with their history instead of creating a new account.
Understanding validation errors
If your file has a problem, such as a value that does not match a valid option for a select-type segment, Mentorly stops the import and lists the errors. No changes are saved until the whole file is valid.
The error list tells you exactly what went wrong:
- The row number where the problem is
- The column (segment name) where the bad value appears
- The value you entered
- The full list of accepted options for that segment
Example:
Row 5, Column "Role": the value "Manager" is not valid. Valid options: Educator, Key Leader, Assistant Store Manager, Store Manager, Regional Manager, Area Director.
To make fixing easier, click Download Annotated XLSX. You get your file back with the errors marked. Fix the values in your spreadsheet and upload the file again. You can repeat this as many times as needed until the file is clean.
Tips for a smooth import
- Always download a fresh file before each import. If you or a colleague have added or renamed segments since your last download, an old file may have columns that no longer match.
- Copy values from existing rows in the file when you are unsure of the exact spelling. This avoids typos that would fail validation.
- Coordinate with your translation setup. If your program uses translated segment labels, the column names in the file use the default language. For more on translations, see Translating Your Segments.