Contact Import Failing? Common Formatting Errors and Fixes

Common Import Errors

• Missing required columns: Name is required for each row
• Wrong file format: Use CSV (.csv) or Excel (.xlsx)
• Special characters: Remove or escape quotes, commas in fields
• Phone number format: Include area codes, remove dashes or spaces
• Empty rows: Remove blank rows at the end of your file
• Header mismatch: Column names must match expected fields

Step-by-Step Fix

1. Download the template from the import dialog
2. Open your data in Excel or Google Sheets
3. Copy your data into the template format
4. Check for blank cells in required fields
5. Format phone numbers consistently (digits only or standard format)
6. Save as CSV (comma-separated values)
7. Try the import again

Phone Number Formatting

Frequently Asked Questions