Your CRM takes a CSV file of contacts, companies or deals, the kind a spreadsheet saves and other tools export. Google Contacts, HubSpot and Pipedrive exports are read as they are; any other file works when its first row names its columns.
Before you start
- Import companies first if you have a file of them, then contacts, then deals. A contact's company and a deal's contact are found by what is already in your CRM.
- A deal names its contact by email, so the contacts must be in before their deals.
- One file holds one kind of record, up to 10 MB and 50,000 rows.
Import a file
- Open Contacts, Companies or Deals, choose Import or export at the top of the list, then Import a CSV.
- Under What the file holds, choose what the rows are, choose your CSV file, then Continue.
- Each column is matched to a field by its name: "First name" and "Last name" become one Name, "Organization" or "Company" a Company, Google's and Pipedrive's own column names included. Check each match, change what is wrong, or choose Leave out for a column you do not want.
- For contacts and companies, choose what happens to one already in your CRM: Fill in what is missing (nothing already there is changed) or Leave it as it is.
- Choose Start the import. A large file is read in the background; you can leave the page and come back.
What each row becomes
- A contact is found by any of its email addresses. One already in your CRM gains only what it lacks: a phone, a job title, a company, addresses it does not hold, tags and empty custom fields.
- A company is found by its website's domain, then by its name.
- A deal is always added. A stage your pipeline lacks is added last. A status is Open, Won or Lost, and a lost deal needs its reason.
- An Owner column names a member of your team by their email or name. A name nobody on the team has refuses the row, so no record is given to nobody by mistake.
- A Notes column becomes one note on the timeline of each record the import adds.
- Contacts the import adds are marked New contact until someone edits them, so you can check them.
When it is done, the page counts what was Added, Filled in and Already there, and lists each refused row with why. Fix those rows in your file and import it again: the rows already in are found, not added twice.
Undo an import
On the import's page, choose Undo this import. It removes the contacts, companies and deals the import added, with their notes and reminders, and the stages it added that hold no deal. The records it filled in keep what they gained. Undo is possible for 7 days; Earlier imports, under Import a CSV, leads back to an import's page.
Take your records out
Import or export on each list also has Export these contacts, Export these companies or Export these deals: a CSV of what the list's filters show, with each custom field as a column. Its columns are named the way an import reads them, so an export imports back. A contact's own menu has Export this contact (JSON): everything about them, their whole timeline included.
Exporting needs the export permission of what you export; Owners and Admins have it, Sales does not.