Exporting Contacts

Whether you're looking to export a complete list of your Contacts, the results of a simple search, or a set Group, the DMS allows you to export your Contacts as a .CSV (comma separated values) format. Contacts may be exported for various purposes such as archiving, mailings, importing on 3rd party tools, further analysis, etc.

You can also select which DMS fields you would like to export, which can be useful for subsequent import into a third-party platform, such as MailChimp, Constant Contact, or another software.

This article will cover how to complete an Export of your DMS Contacts.

Export your Contacts: First Steps

1. Go to the Contacts Tab

2. Search for a specific Contact or select either:

• (1) The specific Contacts you wish to export,
• (2) Every listed Contact on the page, or
• (3) All Contacts in your search criteria

Select Contacts

3. Select the Actions menu at the upper-left side of the Contact list

4. Either type “export” in the Actions search bar or scroll the list to find the Export Contacts option

Select Export Contacts from the Actions menu

5. Once selected, you will be brought to the Export Page which we’ll go into detail below.

Exporting your Contacts

On this page, you can export:

• Every Contact field, or
• Select Contact fields.

Export Primary Fields

6. By default, the Export PRIMARY fields option will be selected. This will allow you to download all the Contact fields in the DMS.

Export PRIMARY fields

7. Before exporting your Contacts, you’ll have options to further segment your selection

Merge Options

Use one of the Merge Contact options when exporting records to reduce your mailing size by sending a single piece of mail to each address:

Merge Contact options

Merge All Contacts with the Same Address: combine any Contacts having the same address (street, city, postal code, country) into a single record.

• If a Household record already exists in which multiple Individuals share the same address, the Household will be exported as the combined record.

Example:

1. Julie D. and Fred Nick (Individual records) both have the same address as “34 Huron St”
2. Julie D. and Fred Nick are part of the “D. & Nick” Household
3. The export would list them as a single Contact named “D. & Nick”.

• If no Household record exists, the records will be combined and the Addressee field will list the Contact names, comma-separated.

Example:

1. Julie D. and Fred Nick (Individual records) both have the same address as “34 Huron St”
2. Both Contacts are not part of a Household
3. The export would list them as a single Contact, and the Addressee field would show “Julie D., Fred Nick”.

Merge Household Members into their Households: export the Household record for any Contacts sharing a Household address.

Postal Mailing Export

• Selecting Exclude contacts with “do not mail” privacy, no street address, or who are deceased. will simply exclude Contacts who cannot or do not wish to be contacted.

– This relies on the Contact’s details being kept up to date and accurate.
Learn more about Data Hygiene & Best Practices

Additional Group for Export

• Select an additional Group for exporting. Your previous export options parameters will also be applied to this additional Group.

Example: Exporting Contacts resulting from a search

8. Once all your options have been reviewed and selected, proceed by selecting the Download File button at the bottom left of the screen.

Download File
9. The DMS will begin compiling a list of all your selected Contacts. This process usually takes a few seconds but may take up to a few minutes, so please do not refresh your page until the process is finished.

10. The resulting .csv can be opened with any recent version of Excel, Google Sheets, etc.

Select Fields for Export

6. Select the Select fields for export option so you can choose which Contact fields you’d like to export

7. Select your Use Saved Field Mapping option if you have saved fields you’d like to export

8. Before exporting your Contacts, you’ll have options to further segment your selection

Merge Options

Use one of the Merge Contact options when exporting records to reduce your mailing size by sending a single piece of mail to each address:

Merge Contact options

Merge All Contacts with the Same Address: combine any Contacts having the same address (street, city, postal code, country) into a single record.

• If a Household record already exists in which multiple Individuals share the same address, the Household will be exported as the combined record.

Example:

1. Julie D. and Fred Nick (Individual records) both have the same address as “34 Huron St”
2. Julie D. and Fred Nick are part of the “D. & Nick” Household
3. The export would list them as a single Contact named “D. & Nick”.

• If no Household record exists, the records will be combined and the Addressee field will list the Contact names, comma-separated.

Example:

1. Julie D. and Fred Nick (Individual records) both have the same address as “34 Huron St”
2. Both Contacts are not part of a Household
3. The export would list them as a single Contact, and the Addressee field would show “Julie D., Fred Nick”.

Merge Household Members into their Households: export the Household record for any Contacts sharing a Household address.

Postal Mailing Export

• Selecting Exclude contacts with “do not mail” privacy, no street address, or who are deceased. will simply exclude Contacts who cannot or do not wish to be contacted.

– This relies on the Contact’s details being kept up to date and accurate.
Learn more about Data Hygiene & Best Practices

Additional Group for Export

• Select an additional  Group for exporting. Your previous export options parameters will also be applied to this additional Group.

Example: Exporting Contacts resulting from a search

9. Once all your options have been reviewed and selected, select Continue

Review Export options and select Continue

10. On the next page, select your desired Contact Type that you’d like to export or export All of them.

Select Contact Types

11. Select Add field to choose which fields you’d like to export

Add all desired fields to export

12. If you’d like to save this field selection for the future, select Save Fields and choose a name for it. You will then be able to choose this selection in the future as a Saved Field Mapping

Save Fields for future exports

13. Once all you've reviewed and selected all your options, select Download File.

Download the export file

14. The DMS will begin compiling a list of all your selected Contacts. This process usually takes a few seconds but may take up to a few minutes, so please do not refresh your page until the process is finished.

15. The resulting .csv can be opened with any recent version of Excel, Google Sheets, etc.