Upload Multiple New Members

Upload Multiple New Members

Upload Multiple New Members

Add multiple members to your ecosystem by uploading a CSV file. Start with your ecosystem's member template, fill in one row per member, then match the columns and review the information before adding the members.

You need permission to add members to the ecosystem you want to use. To update existing members, follow Bulk Edit Members.

1. Download your member template

  1. Log in to PARTNER CPRM and select the correct ecosystem using the dropdown at the top left.
  2. Click Members in the left navigation menu.
  3. Open Add, then select Members From File.
  4. In the Upload Members From File window, click Download Member Template (CSV).

The template includes member information fields and columns for your ecosystem's existing custom attributes. Open it in Excel, Google Sheets, or another spreadsheet editor.


2. Fill in your member information

Enter one member per row. Include these two required fields:

FieldWhat to enter
Member NameThe name of the organization or individual you are adding. Use a name your survey respondents will recognize.
Map LabelA short label that identifies the member on network maps, such as NCC for Northside Community Center. Keep labels concise and distinguishable.

For example, a file containing only the required columns could look like this:

Member Name,Map Label
Northside Community Center,NCC
Riverbend Youth Services,RYS

Add optional information as needed:

  • Contact information: First Name, Last Name, Email, Job Title, Phone, and Website Address. Include the intended contact's name and email address if you plan to email them a survey.
  • Location information: Address, City, State, Zip Code, and Country for geographic analysis. Use state or province abbreviations, such as CO, and two-letter country codes, such as US.
  • Custom attributes: Information you want to track or use to filter and analyze your members.

You can remove unused optional columns from the file. Keep the Member Name and Map Label columns, and use the template's headers where possible so PARTNER can recognize them automatically.

For custom attributes:

  • Use existing attribute option names where possible. You can match unfamiliar values to existing options or create new options during mapping.
  • Separate multiple selections with a pipe, such as Education|Workforce Development.
  • Use YYYY-MM-DD for dates, HH:mm in 24-hour time for times, and YYYY-MM-DD HH:mm for date-and-time values.

Creating custom attributes before downloading the template includes their columns automatically. You can also add a column to your file and create its attribute during mapping.

Save your completed spreadsheet in CSV format.

3. Upload and match your columns

  1. Return to Members → Add → Members From File.
  2. Click Upload Member File and select your CSV.
  3. On the column-mapping screen, review the assignments. Recognized headers are matched automatically.
  4. For an unmatched column, use MATCH TO to select the corresponding member field or attribute. For example, match an uploaded column named Contact First Name to First Name.
  5. To skip an optional column, click Ignore this Column. Its values will not be imported.
  6. To create a custom attribute for a column, select Create Attribute and review its settings. If attribute values need matching, use MATCH OPTION to choose an existing option or Create New Option.
  7. Once all columns and any attribute options have been matched or ignored, click Continue.

If Continue is disabled, check for an unmatched column or attribute option.


4. Review and correct your data

Check the preview to make sure each column contains the information you intended. Scroll horizontally to review fields that are outside the visible area.

  1. Hover over a red-highlighted cell to read its validation error.
  2. Double-click the cell to edit it. Enter or select the corrected value, then press Enter or click outside the cell.
  3. Resolve the remaining validation errors so Add becomes available.

In the example below, Colorado is too long for the State field. Changing it to CO removes the error.

You can also edit other values directly in the preview. To save a CSV containing your preview edits, select Download → Current Data. Use Back if you need to return to the file-upload step.


5. Add and check your members

Click Add to import the members. Uploading your file and editing the preview do not add the members by themselves.

When PARTNER returns you to the member library, search for a newly added member and open their card to check the information. Larger uploads may take time to appear; refresh the member library if needed.

If you need help with your file, contact support@visiblenetworklabs.com.