Import contacts with Do Not Contact flag from spreadsheet to Mautic

5 MIN EXECUTION

Managing contact preferences is crucial for maintaining compliance and respecting user choices. This process helps you bulk import contacts while correctly setting their Do Not Contact (DNC) status in Mautic.

Requirements

• A spreadsheet with contact emails
• Access to Mautic with import permissions
• Basic knowledge of CSV file handling

Steps

1. Prepare your contact spreadsheet
   • Get the spreadsheet and import in Google Sheets
   • Ensure that the first row have only field headers
2. Create the DNC column
   • Add a new column named donotcontact
   • Enter TRUE in rows for contacts who should not be contacted
   • Leave blank or enter FALSE for contacts who can be contacted
3. Export to CSV format
   • Click File > Export > CSV
   • Save the file with a clear name
4. Access Mautic's import feature
   • Navigate to the Contacts page
   • Click the Import button in the top-right corner
   • Select your CSV file
   • Match your CSV columns to Mautic fields
   • Find the Do Not Contact field
   • Map it to your donotcontact column
   • Verify the unique identifier field is mapped correctly (commonly email)
   • Review the import settings
   • Start the import process in browser
   • Wait for completion

Warning

Ensure to set the right unique identifier to avoid creating duplicate contacts. Importing is irreversible.

Results

• Import completion message appears
• Contacts are visible in the contacts list
• DNC status is correctly set for marked contacts when viewing their details
• Import history shows successful completion

Info

Always verify a small sample of imported contacts to ensure the DNC status was properly set before telling the client that the task is done.

← Previous Managing inactive contacts Next → Do Not Contact (DNC) feature