Exporting members and other contacts

What is Export is used for

You can export your contact and membership data from your Wild Apricot account into an Excel spreadsheet. Any time your press the [Export] button it will use your current selection of contacts - as determined by your the current search/filter. If you have not applied a search or filter to your records it will export all contact data.

This is a great way to backup your records into a file. Note, you cannot use export to export your webpages. If you need to backup pages you would have to copy the source code directly.

You can run a query (search) to only limit some specific records - a keyword search and/or filters/ Now when you initiate Export it will be limited to your search results.

Go to the Contact database and click on [Export] button to export your current selection.

Alternatively, you can run a query (search) from your members list, and to only limit some specific records - a keyword search, an advanced search or by clicking on any number on the Member list summary table. This will export only member records.

Export file will include all fields from your database (including your custom fields) in Microsoft Excel XML Spreadsheet format:

Note that records in the exported file might not be in the same order as they showed up on the list.

Note that member pictures can not be exported

Wild Apricot export file can be opened in Microsoft Excel 2003 and up on PC, Excel 2004 and up on Mac. Other software might work too as long as it supports XML spreadsheet format.

The export file format is exactly the same as import so it is very convenient for bulk changes - see Bulk changes using import and export

System fields and special cases

• The Export file includes all system fields (e.g. First Name).
• The Password field will be empty - actual passwords can not be exported for security reasons (because we store them in encrypted form). 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.

Related Topics

• Import Guide
• Bulk changes using import and export
• QuickBooks Export Settings