📊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