How to import deals from CSV
Import deals when you are moving from a spreadsheet, another CRM or an old pipeline export. The target pipeline and its stages must exist before you start.

Prepare the pipeline and the file
- Go to Settings → Pipelines and check that the target pipeline has every stage named in your file.
- Create any deal custom fields you need in Settings → Data fields, and make sure they are visible in the target pipeline.
- Put one deal on each row.
- Give every deal a Title.
- Write each stage name in Stage Name exactly as it appears in the pipeline.
Recommended columns: Title, Stage Name, Status, Description, Deal value, Currency, Probability to win, Expected close date and Linked contacts. Status is Open, Won or Lost.
Linked contacts takes contact email addresses, so import your contacts first. Teamopipe can only link people it already knows.
Import the deals
- Go to Settings → Import / Export.
- On the Deals & Notes card, set Type to Deals.
- Choose the target Pipeline. This decides which stage names are valid.
- Click Import CSV and upload your file.
- On the Mapping step, check that Title, Stage Name and your other columns are matched.
- On the Preview step, check the first five rows: values, currency, probability, dates, status and linked-contact email.
- Click Start Import.
You can also start from the pipeline itself: open the pipeline, click its three-dot menu and choose Import CSV.
Check the result
Open the pipeline and look at several imported deals. Check the stage, deal value, probability, close date and linked contact. If something is off, fix the source file and re-import only the affected rows.
Troubleshooting
- Title is not mapped: map your "Deal name" column to Title manually, or rename the column.
- Stage is ignored: map your "Stage" column to Stage Name, or rename it.
- A stage is invalid: make the spreadsheet value match the selected pipeline's stage exactly.
- A deal has no linked contact: check that the contact exists and that Linked contacts holds its exact email address.
- Values fail or look wrong: remove currency symbols, percent signs and thousands separators, and use YYYY-MM-DD dates.
- The window closes after Continue: see import screen disappears after clicking Continue.
Related articles: how to prepare a CSV file for import, CSV import and export — full guide, how to customize pipeline stages.
If you run into issues, use the chat in the bottom-right corner or the contact form — we typically respond within 4 hours on business days.