Back to app
Import CRM data

Import CRM data

Bring accounts, contacts, and notes into Vertiqa from a CSV export, with column mapping and duplicate-safe import.

Reviewed OperatorVertiqa 1.75+

The CRM Import Center brings your existing customer data into Vertiqa from a CSV export — accounts, contacts, and notes in one pass. It's the tool to reach for when you're migrating off another system or onboarding a backlog of records. You need both account-create and contact-create permissions to use it.

What it imports

Accounts, their contacts, and notes — plus your account and contact custom fields, if you've defined any. (Leads and opportunities aren't imported here.)

Import a CSV

50 seconds, narrated: import three accounts with their contacts. Open video
  1. Open CRM → Import (route /crm/import). You can also get here from Import data on the Accounts or Contacts page.

    The CRM Import Center with Accounts and Contacts shortcuts, a Legacy source picker set to Spreadsheet / CSV, a CSV file chooser, Download log and Import buttons, and a Recent imports panel.
    Start by choosing where the file came from and uploading it.
  2. Pick the legacy source: Spreadsheet / CSV, HubSpot, Salesforce, Pipedrive, Zoho, Jobber, ServiceTitan, Housecall Pro, or Other. The source helps Vertiqa guess the column layout.

  3. Upload your CSV. Vertiqa reads it and suggests a field for every column.

  4. Check the mapping. Each row shows a CSV column, a sample value from it, and the Vertiqa field it goes to, with a running X of N columns mapped count. Change any field that's wrong, or choose Don't import to skip a column.

    The column mapping table for the sample CSV: Company Name to Company / Account name, Website, City, State / Province, First name, Last name, Email, Role / job title and Notes, with Company Phone set to Don't import and its picker highlighted.
    Company Phone wasn't recognized. Choose Phone so the number comes across.
  5. Preview. Before anything is written, you see how many rows are ready, how many contacts they create and how many are blocked, and the first rows tagged Ready, Ready with warnings or Blocked.

    The import preview with Rows 3, Ready 3, Contacts 3 and Blocked 0, three Ready rows pairing each account with its contact, and the Import 3 button highlighted.
    Only Ready rows are imported. Fix Blocked rows in the file and upload it again.
  6. Import. Select Import N. Only ready rows are imported. Existing accounts and contacts are matched and skipped rather than duplicated, so you can re-run a file safely. A progress bar and a per-row log (Imported, Skipped, Partial, Failed) show what happened.

  7. Keep a record. Download log saves the results as a CSV, and past runs are listed under Recent imports, where you can reopen their results.

Source tags

Every import automatically tags the records it brings in — once with the file's name and once with an import: tag — so you can always find or filter the batch you loaded later.

Tips

  • Clean the CSV first. The mapping step is only as good as your column headers — consistent headers mean less manual mapping.
  • Trust skip-existing. If an import is interrupted or you're unsure what loaded, re-running the same file won't create duplicates.
  • Check the Blocked rows in preview before importing — they won't load, and the reason is usually a missing required field you can fix in the CSV.

Learn more about the Vertiqa CRM →