Step 1: Export Data from Pipedrive
Log in to your Pipedrive account
Go to https://app.pipedrive.com/settings/export, or, inside your account, click on your avatar on the top right > Tools and apps > Export data
Export the following data types separately, preferably already in the CSV format:
People (import as contacts in Salesflare)
Organizations (import as accounts in Salesflare)
Deals (import as opportunities in Salesflare)
Note that the loading animations may keep going on forever, while the exports are actually already ready. Just reload the page in the browser to see the exports.
Step 2: Prepare Your Data
Make sure all dates in your export file (this is especially important for close dates of deals/opportunities) are in the YYYY-MM-DD format.
To apply this format in Excel you can select the column of dates, then, on the Home page you click in the dropdown list under the number section, “More Number Formats…”, “Date”, and then select the YYYY-MM-DD format.
For Google Sheets, after selecting the column of dates, you can click on the “123” button, then “Custom date and time”, and select the format that corresponds to the YYYY-MM-DD formatMake sure that all your Deals are assigned to an Organization (fill the column in the Deals export), and not just to a contact
Go through the file and remove any unwanted records. It’s better to take the opportunity to clean up when you move to a new CRM
Make sure email addresses in email address fields are valid. Also, the system will only accept one email address per field. No phone numbers will be accepted in this field
You should also go through other fields to make sure all data is valid and well formatted. Salesflare depends on this data to automate your CRM
If possible, add a website for each one of the organizations by adding an extra column and naming it “Account website”, for easy finding. For the Excel pros, this can often be derived from people’s email addresses with some Excel formulas.
It can make things easier later on if you delete unneeded columns prior to importing. You can identify essential columns by scrolling a little further down to “map the data as follows”.
Save the exported files, as CSV files, in a location accessible for the import
Step 3: Import Data into Salesflare
Log in to your Salesflare account
Navigate to the import section in Salesflare: Settings > Import data > Account/Contact/Opportunity
Begin the import process by clicking the + button at the bottom right and selecting which type of import you want to create.
Import your files, one at a time in the following order:
Organizations → Accounts
People → Contacts
Deals → Opportunities
Map the data as follows:
Organizations from Pipedrive to Accounts in Salesflare
*Name → account name
Website URL (only available as a custom field in Pipedrive) → account website (if you fill the website URL, Salesflare will be able to retrieve more information about the company for you during the import process - it’s highly recommended to fill this before importing, manually if needed)
City/town/village/locality of Address → city
State/county of Address → state/region
Country of Address → country
ZIP/Postal code of Address → zip/postal code
Street/road name of Address → street
People from Pipedrive to Contacts in Salesflare.
*First name → first name
*Last name → last name
*Email → email
Phone → phone
Organization → account name
If you choose to import the account name with the contacts, you can automatically create the accounts through the same import by clicking on the checkbox “Create an account if it doesn't exist yet.”
Optional: you could map “Label → Tags” (or even better: a custom field type “dropdown” with matching options)
Deals from Pipedrive to Opportunities in Salesflare
*Organization → account name
*Expected close date → close date (in YYYY–MM-DD format)
*Owner → owner name (make sure the name matches)
Value → value
Title → opportunity name
Stage → stage name (make sure to create it before importing)
Pipeline → pipeline name (make sure to create it before importing)
Deal created → Start date (in YYYY–MM-DD format)
Lost reason → lost reason name
Follow on-screen instructions to complete the import, ensuring proper field mapping.
If there’s any extra information you want to import to your Salesflare account, you can create a custom field to accommodate itIf your import fails you can download the error file by clicking on “fix import”, and in this new file you’ll find an error in the rightmost column that describes the error for each one of the entries.
Once you’ve fixed those errors, you can just try importing this file again
Review the imported data to verify accuracy. You can always delete your import and start over (by clicking on the menu icon on your import and then “delete data”), if needed
By following these steps, you'll be able to correctly map and import your Pipedrive data into your Salesflare account.