Navigate to the Control Panel > People Tab > Admin Functions > People Manager.
Click Member Options > Import Non-Members.
Use the template linked at the bottom of this page.
The import file must be in CSV (comma-separated values) format and it must contain the following fields in exactly this order. No additional fields can be added, and none should be skipped. If you don’t have data for a specific field leave that column blank. You do not need to enter false data to fill in the columns.
Select the formated file from your computer and specify a mailing list to add the non-members to.
If your club or association has subgroups, you can also select which region, district, or chapter these non-members should be imported into.
The easiest way to create this file is to create a spreadsheet in Microsoft Excel with the specified columns (column names in row 1) and save it as a CSV file. Excel will generate the proper file format.
If you don’t have Excel available, please follow these rules to get a successful import:
- Each field must be separated by commas except the last field in each row.
- Fields that might have commas within them must be enclosed in double quotes. This is not necessary for fields that cannot have commas.
- There should be no blank lines at the end of the file.
- The first row is a header line listing the field names shown above.
- Plain ASCII characters work best; special characters will be imported but the results may not be identical to your original data.