Skip to main content

Import contacts

Use Import when migrating from another CRM or loading event lead lists. Manual create is for one-offs; import handles hundreds or thousands of rows with column mapping, bulk assignment, and error reporting.

Who can do this​

Owners and Admins, and users granted Contacts → Import, can import contacts. Export is a separate Contacts permission.

Before you begin​

  • CSV or Excel file (.csv, .xls, .xlsx) with a header row
  • Maximum 10,000 rows, as stated on the live Upload screen
  • Custom fields already created for any columns you plan to map
  • Statuses, sources, and lifecycle stages defined so bulk assignment dropdowns are populated
  • A 10-row pilot file ready before running the full migration

In this guide​

  • File processed with success and error counts visible on the completion step
  • Imported contacts appear in All contacts and respect bulk-assigned Status, Source, and owners
  • Import history (/contact-management/imports) documents the run for audit

Step-by-step procedure​

Open the import wizard​

  1. Contacts → Import (or navigate to /contact-management/import).
  2. The wizard uses a stepper across the top. The three steps you will spend the most time on are Upload, Map, and Bulk Assign (plus optional Opt-In Consent, Importing, and Complete).

Step 1 — Upload​

  1. On Upload, select Select File or drag a file into the drop zone.
  2. Upload a .csv, .xls, or .xlsx file. To use a sample layout, select Download Template. Include a First Name column. If a row has no first name, SWS Agent uses Unknown or Contact [phone] instead.
  3. Check the preview to make sure the column names look right.
  4. If your file includes call or text history, map those columns in the next step. Each row can include one history item and its timestamp.
  5. Select Next when the file name, row count, and columns look correct.

Step 2 — Map (Map & Preview)​

  1. The Map step displays your file columns alongside Maps to Field dropdowns.
  2. Map at least one column to First Name—the wizard blocks progress without it.
  3. Map Email, Phone, Company, Status, Source, and any custom fields.
  4. Use Skip for columns you do not need; unmapped columns are ignored.
  5. Review the preview table (first rows) to confirm values land in the right CRM fields.
  6. If your file has Email type or Phone type columns, map them to keep those labels for each contact. Otherwise, SWS Agent uses the default types shown in the wizard.
note

Auto-mapping suggests matches when column headers resemble CRM field names. Always verify phone columns are not mapped to First Name—the UI warns when that mismatch is detected.

Step 3 — Bulk Assign​

  1. On Bulk Assign, use Apply to All Contacts fields to set workspace-wide defaults for every imported row.
  2. Common bulk fields: Lifecycle stage, Status, Source, Assigned To, Contact Owner, and Tags.
  3. Choose No change — use file column or leave unset when the file already supplies that value per row.
  4. If Status is unavailable, choose a Lifecycle stage first.
  5. Select Next to start Importing.

Finish and review​

  1. Wait on the Importing step until processing completes.
  2. On Complete, note created, updated, skipped, and failed counts.
  3. Open Import history (/contact-management/imports) for row-level errors.
  4. Fix failed rows in your source file and re-import if needed.

Verify your work​

  • Open Import history and review the result of your import.
  • Open one of the imported contacts and check that its information appears in the right fields.
  • If you set a default Status or Source, check that it appears on contacts whose file rows did not include that value.

Tips​

tip

Run a 10-row pilot import before migrating an entire database. Validate mapping and bulk assign once, then scale.

tip

Normalize phone numbers and emails in your spreadsheet first—duplicate detection works best on clean values.

Troubleshooting​

| Column unmapped | Add the custom field in settings, then re-upload | | Duplicates skipped | Normalize phone/email; check duplicate rules with Admin | | You can’t choose a Status | Select a Lifecycle stage first. | | Import stuck on Importing | Large files take minutes—check history before re-uploading |

See also​