Knowledge Base
How to import contacts and deals in Pipedrive

How to import contacts and deals in Pipedrive

Whether you’re using Pipedrive for the first time or a long-standing user, importing data allows you to add relevant data to leads and sales in your CRM and make it available for the whole organisation to use. 

How to import data into Pipedrive

  1. Head over the left-hand menu, click on ‘...’ and navigate to the ‘import data’ feature. If you're migrating from another CRM, then you do have the option to transfer data directly into Pipedrive. For this guide, however, we’re going to focus on importing data using a spreadsheet.
  1. First and foremost, you’ll need to decide what data you want to import. You can import information such as deals or even map data onto existing contacts in Pipedrive. Before you import your data, you’ll need to ensure that the columns in your spreadsheet are clearly listed, so that it’s easy for Pipedrive to match during the import process.

  2. Now, you’re ready to upload your spreadsheet. Click on the button ‘From a spreadsheet’ and select the file you want to import into Pipedrive. 
  1. After uploading your spreadsheet, you’ll need to match those columns in your file to data fields in Pipedrive. 

  1. Hit ‘Next’ to see a preview of your data import. When selecting merge data, Pipedrive works to avoid duplicates throughout the import process. If you’re happy with how your data is displayed, then go ahead and click ‘Start Import’.
  1. Pipedrive will provide you with a skip file once your import is complete. Basically, this file informs you of any rows that may have had an issue during the import and will highlight the reason why there was a problem. You can correct these issues in the skip file and import that into Pipedrive. 

How to automatically import data into Pipedrive with Ruler

Instead of spending time wrestling with importing data into Pipedrive, you could use a marketing attribution tool like Ruler to automate the process. This will allow you to focus on more important things, such as converting more leads into revenue.

Ruler Analytics can pass marketing source variables to Pipedrive across multiple touchpoints such as first/last, landing page, keyword, GCLID, page views and sessions to new and existing Deals in Pipedrive. 

1. Ruler tracks each anonymous visitor individually, and records how that user found your site and tracks any subsequent visits or interactions with other marketing channels and campaigns.

Related: How to view full customer journeys with Ruler

2. Once an anonymous visitor makes a conversion, whether it be a form fill, phone call or live chat, Ruler will update the data on that user to create a customer journey.

3. Using a pre-built integration, Ruler will send all the data it’s collected on your lead and send it to Pipedrive to create a new Deal. Ruler can also update existing records in your Pipedrive CRM with 60+ marketing variables. 

Related: How to add lead source data to Pipedrive and attribute marketing revenue

4. When a lead agrees to a Deal, Ruler can retrieve the information from your won deals and track it back to the moment of engagement.

Related: How Ruler attributes revenue to your marketing

This will feed data into your marketing platforms such as Google Analytics, Google AdWords, Facebook and Microsoft Advertising. 

Want more information about Ruler? 

We highly recommend taking a demo with one of our team. You’ll be able to see Ruler in action and understand how it can enrich your Pipedrive to gain a better picture of your leads and customers.

Related articles:

Connect Pipedrive with Google Analytics and drive more qualified leads
Track lead source and attribute marketing revenue in Pipedrive
How to add marketing data to Pipedrive CRM Deals
Ultimate guide to Pipedrive web forms