CSV import and export - full guide
CSV is how data moves in and out of Teamopipe. Import and export are included on every plan, and everything lives in one place: Settings → Import / Export.

What you can import
Settings → Import / Export has an import card for each type of record:
- Contacts — people and their contact details
- Organizations — companies
- Deals & Notes — deals with their stage, or deal notes. Choose the type and the pipeline to import into.
- Tasks — tasks and assignments
Each card has Download template. Start from the template so your columns match what the importer expects. Teamopipe accepts .csv, .xls and .xlsx files up to 10 MB, and only the first sheet is imported.
Recommended order for a migration
- Create your custom fields in Settings → Data fields.
- Import organizations.
- Import contacts.
- Check that the target pipeline and its stage names exist in Settings → Pipelines.
- Import deals.
- Import tasks and deal notes if you need them.
Run an import
- Go to Settings → Import / Export.
- On the right card, click Download template if you don't already have a clean file.
- For deals or notes, choose the Type and the Pipeline before you upload.
- Click Import CSV, upload your file and click Continue.
- On the Mapping step, match Teamopipe fields to your columns. Required fields must be mapped before Continue becomes available. A column you leave on Don't import is ignored.
- On the Preview step, check the first five rows and the counts for ready rows, mapped fields, unmapped fields and total rows.
- Click Start Import, then open a few records to check them.
You can also import deals from inside a pipeline: three-dot menu → Import CSV, or Import notes CSV for deal notes. Imports are paused while a workspace is read-only.
Export your data
The Export section has a card for Contacts, Organizations, Deals & Notes and Tasks. Click Export CSV. For deals, choose a pipeline or all pipelines first.
Deals and deal notes export as two linked files joined by a deal_id column. Every note row carries the deal_id of its deal, so you can join the files in Excel or Google Sheets with XLOOKUP or VLOOKUP. Exports use UTF-8 and ISO 8601 dates (YYYY-MM-DD).
To export a single pipeline, use its three-dot menu → Export. Exports still work when a workspace is read-only.
Check after a migration
- Names and required fields imported correctly.
- Deals are in the intended pipeline and stage.
- Deal values are plain numbers, without currency symbols or thousands separators.
- Dates show the day you intended.
- Linked contacts are attached to the right deals.
- Custom fields hold the right type of data.
Moving from another CRM
Export your data from the old CRM as CSV, set up your pipeline stages and custom fields in Teamopipe first, then import organizations, contacts and deals in that order. See migrating from Pipedrive, Copper or another CRM.
Related articles: how to prepare a CSV file for import, how to import contacts from CSV, how to import organizations from CSV, how to import deals from CSV.
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.