Importing Contacts
Build and manage your contact database with our easy import tools.
Supported Import Methods
📄 CSV File Upload
Import contacts from spreadsheet applications like Excel, Google Sheets, or CRM exports.
🔗 API Integration
Connect directly to your CRM, e-commerce platform, or other business tools.
📝 Manual Entry
Add individual contacts or small lists directly in the dashboard.
CSV Import Guide
Step 1: Prepare Your CSV File
Ensure your CSV file includes these recommended columns:
- Email (required) - Primary email address
- First Name - Contact's first name
- Last Name - Contact's last name
- Company - Organization or business name
- Tags - Comma-separated labels for segmentation
- Source - Where the contact came from (website, event, referral)
Step 2: Format Requirements
- Use UTF-8 encoding to support special characters
- Include headers in the first row
- Use commas as separators (standard CSV format)
- Enclose fields with commas or quotes in double quotes
- Maximum file size: 10MB (approximately 100,000 contacts)
Step 3: Upload and Map Fields
In your SendPerfect dashboard:
- Navigate to Contacts > Import
- Click "Upload CSV" and select your file
- Map CSV columns to SendPerfect fields
- Review the preview of your data
- Choose import options (create lists, apply tags)
- Click "Import" to start the process
Sample CSV Format
Email,First Name,Last Name,Company,Tags,Source
john.doe@example.com,John,Doe,Acme Corp,prospect,website
jane.smith@example.com,Jane,Smith,Tech Solutions,customer,referred
Data Validation
SendPerfect automatically validates your data during import:
- Email Format: Checks for valid email syntax
- Duplicates: Identifies and handles duplicate emails
- Required Fields: Ensures email addresses are present
- Data Types: Validates phone numbers and dates
Import Options
- Skip Duplicates: Don't import contacts that already exist
- Update Existing: Update information for existing contacts
- Create Lists: Automatically organize contacts into lists
- Apply Tags: Add tags to all imported contacts
- Subscribe Status: Set initial subscription preferences
Best Practices
- Start with a small test import (10-20 contacts) before bulk uploads
- Clean your data before importing - remove bounces and spam traps
- Use consistent formatting for names, companies, and tags
- Segment your contacts with tags for better targeting
- Include source information to track where contacts came from
- Respect privacy laws - only import contacts with proper consent
Troubleshooting
Common Issues:
- Encoding Errors: Save CSV as UTF-8
- Delimiter Issues: Use commas, not semicolons or tabs
- Large Files: Split files over 10MB into smaller chunks
- Invalid Emails: Check for typos and formatting