📊CSV Import Templates
Contacts Import (Minimal)
Basic contact CSV template with essential fields for CRM imports.
Explanation
A minimal template for importing contacts with just the essential information.
Examples
CSV Template
Output
email,firstName,lastName,phone john.doe@example.com,John,Doe,+1234567890 jane.smith@example.com,Jane,Smith,+0987654321 bob@example.com,Bob,Johnson,
Code Examples
CSV Format
email,firstName,lastName,phone
john.doe@example.com,John,Doe,+1234567890
jane.smith@example.com,Jane,Smith,+0987654321 JavaScript
// Generate CSV from contacts
const contacts = [
{ email: 'john@example.com', firstName: 'John', lastName: 'Doe', phone: '+123' }
];
const csv = [
'email,firstName,lastName,phone',
...contacts.map(c => `${c.email},${c.firstName},${c.lastName},${c.phone || ''}`)
].join('\n');Try it Now
💡 Tips
- Use UTF-8 encoding to support international characters
- Always include header row
- Optional fields can be left empty
- Validate email format before import
- Consider adding a unique ID column
⚠️ Common Pitfalls
- Excel may corrupt phone numbers (add apostrophe prefix)
- Commas in names require quote wrapping
- Different systems may expect different phone formats
- Missing BOM may cause encoding issues in Excel