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.
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
- Go to CRM › Import ("Import deals").
- Upload: pick the file and choose the Target pipeline and the Initial stage where the deals will land. Click Continue.
- 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.
- 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.
- 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
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.