How to import contacts from CSV

May 20, 2026

Import contacts when you are moving from another CRM or already keep your contact list in a spreadsheet. Teamopipe accepts .csv, .xls and .xlsx files up to 10 MB. For Excel workbooks, only the first sheet is imported.

Before you start

  • Put one contact on each row, with column names in the first row.
  • Give every contact a First name. It is the only required contact field.
  • Use separate columns for First name and Last name.
  • Put one email address and one phone number in each cell.
  • Name the phone column Phone. A column called "Phone number" does not map automatically.
  • Remove empty rows, merged cells, formulas and duplicate contacts. Each row creates a new contact.

Easiest start: go to Settings → Import / Export and click Download template on the Contacts card. Template columns include First name, Last name, Email, Phone and Description.

Import the file

  1. Go to Settings → Import / Export.
  2. On the Contacts card, click Import CSV.
  3. Drop your file into the upload area, or choose it from your computer, then click Continue.
  4. On the Mapping step, match each Teamopipe field to a column in your file. Familiar headers such as First name, Last name, Email, Phone and Description are matched automatically.
  5. Leave Don't import for any column you don't need, then click Continue.
  6. On the Preview step, check the first five rows and the counts for ready rows, mapped fields, unmapped fields and total rows.
  7. If the preview looks right, click Start Import.

A high number of unmapped fields is a reason to review your mapping, not necessarily a problem with your rows.

Linking contacts to organizations

The contact importer offers an Organization ID field, not a lookup by company name. A column containing "Acme Consulting" can't be mapped to it directly. Import your organizations first, then link contacts to them from the records.

Check the result

Open Contacts, search for two or three imported people and check their email, phone, description and any custom fields. If something is wrong, fix the source file and re-import only the affected rows, so you don't create duplicates. A good habit is to import five or ten rows first and check them before importing the full file.

Importing from another CRM

If you can't continue

  • Check that every row has a First name and that the first row contains unique column headers.
  • Save the file again as UTF-8 CSV, or try the original .xlsx file.
  • If a column stays unmapped, pick it manually from the dropdown.
  • If the window closes after you click 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 create and edit contacts manually.

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.

Related articles