CSV import: column auto-detection and duplicate strategy

Upload a CSV and let Omnifox auto-detect your columns; decide what happens with repeated contacts.

Jun 26, 2026

The CSV import wizard walks you through four steps —Upload, Map Columns, Preview and Import— to load your contact list. Omnifox tries to recognize your columns automatically and lets you decide what to do when a contact already exists.

Before you start

  • Prepare a CSV file (10 MB max) with one header row and one row per contact.
  • Each contact needs at least one identifiable field: email, phone or name.

Steps

  1. Open Contacts and click Import CSV.
  2. Step 1 — Upload: drag the file in or click Choose File. Omnifox shows the name, size and how many rows it detected.
  3. Step 2 — Map Columns: each column in your CSV is matched to an Omnifox field (first name, last name, email, phone, company, job title, country, city, locale, gender, notes…).
    • Auto-detection recognizes common headers in English and Spanish: firstname/nombre, email/correo, phone/telefono/mobile, company/empresa, title/cargo, country, city, and more.
    • If a column shouldn't be imported, leave it set to -- Skip this column --.
  4. Choose the duplicate strategy (a contact counts as a duplicate when the email or phone matches):
    • Update existing contact: overwrites the data of the contact already on file.
    • Skip duplicates: keeps the existing contact and discards the repeated row.
  5. Step 3 — Preview: review the first mapped rows. Any with issues (invalid email or no identifiable field) are flagged as warnings.
  6. Step 4 — Import: confirm. You'll see a summary with Contacts Created, Contacts Updated and Errors.

Verify

When it finishes, go back to Contacts: your new records are already in the list. If some rows failed, you can download the error report as CSV to fix them and retry just those.

If it doesn't work

  • "The CSV file must contain at least a header row and one data row": your file is empty or has headers only.
  • Rows being ignored: a row is skipped if its column count doesn't match the header. Check for commas or line breaks inside values.
  • Large imports: if your file exceeds 500 rows, the import runs in the background and you'll get a notification when it's done.
  • A column isn't detected: map it manually in the mapping step; auto-detection only covers the most common header names.

Tips

  • Before importing, normalize phone numbers to international format to avoid duplicates that go undetected.
  • Use Update existing contact to enrich your base with new data without losing your existing contacts.

Related articles

Was this helpful?

Related articles

Message us on WhatsApp