CSV import: column auto-detection and duplicate strategy
Upload a CSV and let Omnifox auto-detect your columns; decide what happens with repeated contacts.
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
- Open Contacts and click Import CSV.
- Step 1 — Upload: drag the file in or click Choose File. Omnifox shows the name, size and how many rows it detected.
- 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 --.
- Auto-detection recognizes common headers in English and Spanish:
- 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.
- Step 3 — Preview: review the first mapped rows. Any with issues (invalid email or no identifiable field) are flagged as warnings.
- 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
Related articles
-
How to import contacts from a CSV file
Upload your contact list in minutes by mapping your CSV columns to CRM fields.
-
Managing contacts and the CRM
In Omnifox every conversation creates a contact. Learn to use custom fields, tags, the deal pipeline and the contact 360 timeline.
-
CRM complete guide
The CRM in depth, in 46 chapters: pipeline, deals, the deal record, to-dos, dashboard and goal, settings, the contact record, contacts, import, lead forms, chat, AI and workflows.
-
Contact custom fields
Build fields tailored to your business to store exactly the information you need about each contact.
-
The sales pipeline and deals
Visualize and manage your sales process with a stage board and opportunity cards.