Dashboard > Wild Apricot Knowledge Base > ... > 2. Membership management > Export members list
Online Help
For main website go to www.WildApricot.com
Membership and website software for communities
Build a free demo site and send it
out for feedback in 25 minutes
Name:
Email:
We value your privacy
Log In   View a printable version of the current page.  
Added by WildApricot admin, last edited by WildApricot admin on May 10, 2007  (view change)
Labels: 
(None)

Home

Export members list

You can export your current list of members at any moment.
Go to the Members section and click on [Export] button to export your whole list (including Archived records).

Alternatively, you can run a query (search) to only limit some specific records - a keyword search, an advanced search or by clicking on any number on the Member list summary table. Now when you initiate Export it will be limited to your current selection (search results).
Export file will include all fields from your database (including your custom fields) in Microsoft Excel XML Spreadsheet format:

Re-importing your export file back

Note that the export file format is exactly the same as import so it is very convenient for bulk changes:

  • Export your database
  • Make the changes
  • Import it back - existing records will be updated

System fields and special cases

  • The Export file includes all system fields (e.g. Member status).
  • For security purposes, the Password field is left empty - actual member passwords can not be exported. (But you can enter new ones and re-import this file to update passwords)
  • If you have a custom database field which can contain multiple values (Checkboxes field), values will be put in the same cell separated by an invisible new line character. Make sure to preserve it if you change any values in that field and re-import.
  • Date fields are exported in DD-MMM-YYYY format, e.g. 08 Aug 2006. Make sure to preserve this format if you change any dates and re-import.