Import deals, contacts and companies from CSV

Upload a CSV exported from your spreadsheet to create deals in your pipeline, linking or creating each row's contact and company.

Jun 26, 2026

Watch this step in the video · Importing contacts and creating deals

What it is and when to use it

The CRM import wizard takes a CSV or TSV file (what any spreadsheet produces with "Save as CSV") and creates deals in the pipeline you choose. In the same pass it links or creates each row's contact and company. Use it to load your starting book of business or to bring leads in from another tool.

Requirements

  • The CRM module available on your plan.
  • A CSV/TSV file up to 10 MB and 2,000 rows per import. The first row must be the column headers.
  • At least one column to act as the Deal title (the only required field).

Steps

  1. Go to CRM › Import ("Import deals").
  2. Upload: pick the file and choose the Target pipeline and the Initial stage where the deals will land. Click Continue.
  3. Map: Omnifox auto-detects columns by their header. Review the mapping and fix anything that's off. The fields you can map are: Title, Amount, Currency, Probability, Expected close date, Source, Contact name/email/phone, and Company name. Use "— Skip this column —" for any you don't want to import.
  4. Preview: this is a dry run; nothing is written yet. For each row you'll see whether it will Create or Update, plus any rows with an Error.
  5. Import now: applies the import. When it finishes you'll see how many were created, updated and failed, with a button to Go to pipeline.

How duplicates are avoided

  • Contacts: matched/created by email, then phone, then name, within the workspace.
  • Companies: by name.
  • Deals: by contact/company + title.

That makes the import idempotent: re-uploading the same sheet updates the existing records instead of duplicating them.

Verification

Open CRM › Pipeline and confirm the deals landed in the right pipeline and stage. Open a contact record to check the contact and company were linked.

If it doesn't work

  • "The file is empty" / "has a header but no data rows": make sure the CSV has rows under the headers.
  • Can't continue past mapping: assign a column to the Deal title.
  • Rows with Error: usually the title is missing on that row; fix it in the sheet and re-import (no duplicates).
  • Fewer rows imported than expected: you exceeded the 2,000-row limit; split the file into parts.

Tips

  • If your sheet uses a semicolon separator (common in non-English Excel), no problem: the wizard detects the delimiter automatically.
  • Start with a small test file and check the Preview before importing everything.

Related articles

Was this helpful?

Related articles

Message us on WhatsApp