How to prepare a CSV file for import
A clean file makes the mapping and preview steps predictable. Most import problems come from formatting in the file, not from the importer. Teamopipe accepts .csv, .xls and .xlsx files up to 10 MB, and reads only the first sheet.

Use this structure
- One record per row and one field per column.
- Unique column names in the first row.
- No title rows, subtotals, blank rows, merged cells, charts or images.
- Replace formulas with their displayed values.
- Put only one email address or phone number in each cell.
- Use dates like 2026-11-15 (YYYY-MM-DD). Avoid ambiguous formats such as 11/12/26.
- Use plain numbers for value and probability: 9500 and 55, not $9,500 and 55%.
Match Teamopipe's column names
Exact names reduce manual mapping. Current examples:
- Contacts: First name (required), Last name, Email, Phone, Description.
- Organizations: Organization Name (required), Website, Description, Assignee Email.
- Deals: Title (required), Stage Name, Description, Deal value, Currency, Probability to win, Expected close date, Status, Linked contacts.
Stage values must match the stages of the pipeline you choose exactly. Use a currency code such as USD or EUR instead of a symbol. The easiest way to get the right names is Download template in Settings → Import / Export.
Clean the data
- Remove duplicate rows. Every row creates a record.
- Filter for missing required values.
- Trim spaces before and after names and emails.
- Standardize dates, currencies, phone numbers and status values.
- Check that your custom fields already exist in Settings → Data fields.
- Keep a backup copy.
Export from Google Sheets or Excel
In Google Sheets, choose File → Download → Comma-separated values (.csv). If you have several sheets, download each one separately. In Excel you can upload the .xlsx file directly, but only the first sheet is read. If the file behaves oddly, save it as UTF-8 CSV and open it in a plain text editor to check it.
Test with a small batch
Import five to ten rows first. Check the records, fix any mapping or formatting problem, then import the full file. This is especially useful for custom fields and linked records. During preview, a high unmapped-field count is a warning to review the mapping, not proof that rows are invalid.
Related articles: CSV import and export — full guide, how to import contacts 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.