Importing your members is easy with MembershipWorks. Put your members information into a spreadsheet, save it as a CSV (Comma Separated Value) file, and upload it to us. That’s it! You can import as many or as little members, at any time.
Creating and Saving the Spreadsheet
Your spreadsheet should start with the first row being the titles of the columns. Our system recognizes the following titles:
- First Name
- Last Name
- Name
- Contact Person
- Phone
- Website
- Street
- City
- State
- Zip
- Label
- Membership Level
- Join Date
- Renewal Date
You do not have to include all of the information, but a name (either name, first name or last name) is required. Note that if an email is not provided, the member will not be able to access his account online. Also note that if you include Membership Level or Label columns, you must have already defined the labels under Labels & Membership, and that the text is an exact match (capitalization matters).
The following are 2 sample spreadsheets for reference. You can also use the sample spreadsheets as a template. Note that there are 2 Label columns in the sample spreadsheet, and you may add more Label columns if required.
Sample spreadsheet with name column
Sample spreadsheet with separate first and last name columns
Once you have entered your member information in the spreadsheet, save it in the CSV format. For Excel, select Save As, then pick CSV (Comma Delimited) as the format.
Excel may indicate that some features of your spreadsheet are not compatible with CSV, click “Yes” to continue saving it in the CSV format.
Uploading the File
From the Members folder click on the Import tab. Click on Upload CSV File to upload your member data.
After uploading the file, the file will be processed and the members added to your Members folder. Take a note of any errors shown in the results.
Comments are closed.