Importing Contacts
Import multiple contacts at once by uploading a CSV file.
Preparing Your CSV File
Required Columns
Your CSV must include these columns:
emailfirstNamelastName
Optional Columns
Add any of these standard fields:
phonenotetagsdefaultAddressCompanydefaultAddressAddress1defaultAddressAddress2defaultAddressCitydefaultAddressProvinceCodedefaultAddressCountryCodedefaultAddressZipdefaultAddressPhone
Custom Fields
Include any custom field names as column headers. Values will be imported automatically.
Sample CSV File
Download a sample CSV directly from the import dialog, or use this format:
firstName,lastName,email,phone,defaultAddressCity,defaultAddressProvinceCode,defaultAddressZip,tags,volunteerSkills
Person1,Last1,person1@example.org,555-0101,Springfield,IL,62701,volunteer;events,Phone Banking;Event Support
Person2,Last2,person2@example.org,555-0102,Chicago,IL,60601,donor;supporter,Fundraising;Outreach
Person3,Last3,person3@example.org,555-0103,Peoria,IL,61602,phonebank;canvassing,Research;Social MediaImport Process
The import wizard has 5 steps:
1. Upload
Click Choose File or drag and drop your CSV file.
Click Download Sample CSV to get a template file.
2. Mapping
The system auto-maps CSV columns to contact fields. Review and adjust mappings if needed.
Required fields (must be mapped):
- First Name
- Last Name
Optional fields can be:
- Mapped to standard fields
- Mapped to custom fields
- Skipped
3. Preview
Review the first 5 contacts to verify the import looks correct.
Check that data appears in the right fields.
4. Import
Click Start Import to begin. Progress bar shows:
- Total contacts
- Successful imports
- Failed imports with errors
5. Complete
Review import results:
- Number of contacts imported
- Any errors or skipped rows
Import Behavior
- Duplicate emails in your list are skipped
- Invalid data rows are reported with specific errors
- Unmapped columns are added as custom fields automatically
Handling Errors
Duplicate Emails
Contacts with emails already in the list are skipped. Update existing contacts manually if needed.
Invalid Data
Common issues:
- Missing required fields (email, firstName, lastName)
- Invalid email format
- Wrong data type for custom fields
The import report shows which rows failed and why.
CSV Format Requirements
- Use UTF-8 encoding
- First row must be column headers
- Use commas as delimiters
Best Practices
- Test with a small file first (5-10 contacts)
- Review the preview before importing
- Keep a backup of your original CSV
- Clean your data before import (remove duplicates, fix formatting)
- Use consistent naming for custom fields
Troubleshooting
Import Fails Completely
- Check file is valid CSV format
- Ensure required columns are present
- Verify file encoding is UTF-8
Some Contacts Skipped
Check import report for specific errors. Common issues:
- Duplicate emails
- Missing required fields
- Invalid email addresses
Custom Fields Not Importing
- Ensure custom fields exist in your organization
- Column names must match field names exactly
- Check data types in your CSV match field definitions