Importing to Pipedrive: Mapping Fields

To ensure your data is imported correctly into Pipedrive, you need to map the columns from your spreadsheet to the corresponding fields in Pipedrive. This step ensures that your contacts, organisations, deals, activities, notes, products, or leads are properly linked with the relevant data.

Item Icons

Each type of item in Pipedrive is represented by an icon during the import process. You need to map your data fields to these icons to ensure proper linkage.

Screenshot_2020-09-16_at_11.36.29.png

  • Person Type Fields 

Screenshot_2020-09-18_at_10.41.18.png

  • Organisation Type Fields 

Screenshot_2020-09-18_at_10.42.36.png

  • Deal Type Fields 

Screenshot_2020-09-18_at_10.43.52.png

  • Activity Type Fields 

Screenshot_2020-09-18_at_10.48.35.png

  • Note Type Fields 

Screenshot_2020-09-18_at_10.49.26.png

  • Product Type Fields 

Screenshot_2020-09-18_at_10.50.18.png

  • Lead Type Fields 

Screenshot_2020-09-18_at_10.51.03.png

To select the correct field type when mapping, click on the icons representing each item type.

Screen_Capture_on_2020-09-16_at_14-30-19.gif

Mapping Your Fields

Not all fields will be mapped automatically. It's essential to manually map any unmapped fields and double-check your mapping before proceeding to prevent any errors.

  1. Set Up Your Spreadsheet: Ensure your spreadsheet is correctly formatted and imported.

    Screenshot_2020-09-16_at_14.58.31.png
  2. Begin Mapping: Select the icon of the field type you wish to map, then drag that field to the left-hand side of the page to match it with your spreadsheet columns.

  3. Check Data Accuracy: You will see data from the first row of your import, allowing you to verify that the spreadsheet is read correctly by Pipedrive.

For example, if you have a spreadsheet with columns for person names, email addresses, and phone numbers, you would drag the "Person" icon to map those columns accordingly.

  1. Screen_Capture_on_2021-01-07_at_16-30-52.gif

Additional Resources: For more detailed information on advanced mapping, such as mapping multiple option fields, refer to this article.

By following these steps, you can ensure a smooth and accurate data import into Pipedrive, maintaining the integrity and organisation of your sales data.

Why Businesses Should Move to Automation (8)
Unlock the full potential of Pipedrive with our expert training sessions. Learn tips and tricks that will save you time and increase your productivity. Limited spots available - book your session now!