First Name & Last Name Separation for list export

Gary Allen
Gary Allen Member Posts: 17 VERIFIED MEMBER
edited July 2022 in Sales CRM #1

Edit, you can now ask the Pipedrive support team to enable the split of first-  and last name fields in your account 🚀

-----

Hi I would like to know if I can export a list with the first and last name fields in diferent columns.

Tagged:
«13

Comments

  • Mike van der Valk
    Mike van der Valk Pipedrive Team Posts: 3,065 PIPEDRIVE TEAM
    2500 Comments Fourth Anniversary 100 Likes 5 Answers
    edited February 2022 #2

    Hi @Gary Allen what is the email address you're using to login to Pipedrive? (write it here or email me at mike@pipedrive.com0

    I can then enable a feature we're working on that splits names into first- and last name in the contact details and lists. This will then also reflect in the export.

  • Gary Allen
    Gary Allen Member Posts: 17 VERIFIED MEMBER
    edited May 2021 #3

    Hi @Gary Allen what is the email address you're using to login to Pipedrive? (write it here or email me at mike@pipedrive.com0

    I can then enable a feature we're working on that splits names into first- and last name in the contact details and lists. This will then also reflect in the export.

    Hi @Mike van der Valk 

    Thanks for the reply and for putting this feature on.

    My login email is: gary.allen@synergistics.co.uk

    Thanks

    Gary

  • Gary Allen
    Gary Allen Member Posts: 17 VERIFIED MEMBER
    edited February 2022 #4

    Hi @Mike van der Valk 

    How do I switch this feature on and off.

    Thanks

    Gary

  • Mike van der Valk
    Mike van der Valk Pipedrive Team Posts: 3,065 PIPEDRIVE TEAM
    2500 Comments Fourth Anniversary 100 Likes 5 Answers
    edited April 2020 #5

    Hi @Mike van der Valk 

    How do I switch this feature on and off.

    Thanks

    Gary

    Hi @Gary Allen it's a new feature not live for everyone yet, so you'd need to reach out to support to have it switched on and off. You will now on your contact persons see the first- and last name fields like this below. If you export all your contacts these fields will be shown on your export list as well.

    image
  • Gary Allen
    Gary Allen Member Posts: 17 VERIFIED MEMBER
    edited April 2020 #6

    Hi @Mike van der Valk 

    How do I switch this feature on and off.

    Thanks

    Gary

    Hi @Mike van der Valk 

    Thanks for the help on this. 

    But for some reason it seems to have changed a number of my contacts to show their first name only  when viewing them in a list and individually in pipedrive.

    I think you might have some bugs there.

    Please can you switch the feature off for now.

    Thanks

    Gary

  • Mike van der Valk
    Mike van der Valk Pipedrive Team Posts: 3,065 PIPEDRIVE TEAM
    2500 Comments Fourth Anniversary 100 Likes 5 Answers
    edited April 2020 #7

    Hi @Mike van der Valk 

    How do I switch this feature on and off.

    Thanks

    Gary

    @Gary Allen I've switched it off for now but would love to learn more about it since we didn't get complaints from other users. What is your expectation of what will happen and what is happening now? 

  • Gary Allen
    Gary Allen Member Posts: 17 VERIFIED MEMBER
    edited April 2020 #8

    Hi @Mike van der Valk 

    How do I switch this feature on and off.

    Thanks

    Gary

    Hi @Mike van der Valk 

    I think it might have been my error, I'm using an email marketing tool called snov.io and whe setting up the integration I mapped first name in snov.io to person name in pipedrive.

    Listen, I'm realy sorry to be a pain, if you could switch the feature back on again and I'll give it another try  with a filtered export of contacts into xls and I'll give you full feedback once it's done.

    Thanks

    Gary

     

  • Mike van der Valk
    Mike van der Valk Pipedrive Team Posts: 3,065 PIPEDRIVE TEAM
    2500 Comments Fourth Anniversary 100 Likes 5 Answers
    edited April 2020 #9

    Hi @Mike van der Valk 

    How do I switch this feature on and off.

    Thanks

    Gary

    @Gary Allen no worries mate! I'm here to help :) 

    The feature is switched back on, hope it helps!

  • Gary Allen
    Gary Allen Member Posts: 17 VERIFIED MEMBER
    edited April 2020 #10

    Hi @Mike van der Valk 

    How do I switch this feature on and off.

    Thanks

    Gary

    Hi @Mike van der Valk 

    image

    Please see attached some screenshots.

    One is the screen in pipedrive showing the contact with the first and last name fields as you describe.

    The second is the export to  excel, unfortnatley it doesn't seem to be separating the first and last names.

    In addition,  I noticed that the email adrresses are not separated, work from home etc..., this will cause an error if exported to an email marketing tool as it can only read one email per contact within a field.

    Thanks

    Gary

     

  • Gary Allen
    Gary Allen Member Posts: 17 VERIFIED MEMBER
    edited May 2021 #11

    Hi @Mike van der Valk 

    How do I switch this feature on and off.

    Thanks

    Gary

    image
  • Mike van der Valk
    Mike van der Valk Pipedrive Team Posts: 3,065 PIPEDRIVE TEAM
    2500 Comments Fourth Anniversary 100 Likes 5 Answers
    edited April 2020 #12

    Hi @Mike van der Valk 

    How do I switch this feature on and off.

    Thanks

    Gary

    Thanks for sharing @Gary Allen I tried it yesterday and exported filter results from the contact person list view and it worked. The columns for first- and last name were the ones totally on the right of the spreadsheet for me though, are they also missing there for you?

  • Gary Allen
    Gary Allen Member Posts: 17 VERIFIED MEMBER
    edited April 2020 #13

    Hi @Mike van der Valk 

    How do I switch this feature on and off.

    Thanks

    Gary

    Hi @Mike van der Valk 

    As per the screenshot, only my name as the owner is on the spreadsheet on the right hand side..

    image
  • Mike van der Valk
    Mike van der Valk Pipedrive Team Posts: 3,065 PIPEDRIVE TEAM
    2500 Comments Fourth Anniversary 100 Likes 5 Answers
    edited April 2020 #14

    Hi @Mike van der Valk 

    How do I switch this feature on and off.

    Thanks

    Gary

    @Gary Allen before you did the export, did you add the fields to your list view? Like shown here: 

    image
  • Gary Allen
    Gary Allen Member Posts: 17 VERIFIED MEMBER
    edited April 2020 #15

    Hi @Mike van der Valk 

    How do I switch this feature on and off.

    Thanks

    Gary

    Hi @Mike van der Valk 

    Thanks, it works  perfectly now  :-)

    Best

    Gary

     

  • Mike van der Valk
    Mike van der Valk Pipedrive Team Posts: 3,065 PIPEDRIVE TEAM
    2500 Comments Fourth Anniversary 100 Likes 5 Answers
    edited May 2021 #16

    Hi @Mike van der Valk 

    How do I switch this feature on and off.

    Thanks

    Gary

    Awesome, glad to hear Gary!

  • Annelies Warreyn
    Annelies Warreyn Member Posts: 1 VERIFIED MEMBER
    edited February 2022 #17

    @Mike van der Valk  I would like to pick up on this conversation. Could I also have this function turned on? In Belgium we have any people with double or even triple last names. Now Pipedrive splits the contact name in half. If we use the field first name in email this gives some strange results and does not come across very professional.... Maybe this new function will resolve this problem. My log-in is info@netwerkondernemen.be. 

  • Mike van der Valk
    Mike van der Valk Pipedrive Team Posts: 3,065 PIPEDRIVE TEAM
    2500 Comments Fourth Anniversary 100 Likes 5 Answers
    edited April 2020 #18

    @Mike van der Valk  I would like to pick up on this conversation. Could I also have this function turned on? In Belgium we have any people with double or even triple last names. Now Pipedrive splits the contact name in half. If we use the field first name in email this gives some strange results and does not come across very professional.... Maybe this new function will resolve this problem. My log-in is info@netwerkondernemen.be. 

    Hi @ANNELIES WARREYN  I just enabled it for your account, have fun!

  • RH1
    RH1 Member Posts: 7 VERIFIED MEMBER
    Third Anniversary Name Dropper Combo Breaker First Comment
    edited February 2022 #19

    I need this too. I'm surprised you can't just have the option to export the first name as a standard option. It's available already in email templates. 

  • Mike van der Valk
    Mike van der Valk Pipedrive Team Posts: 3,065 PIPEDRIVE TEAM
    2500 Comments Fourth Anniversary 100 Likes 5 Answers
    edited June 2020 #20

    I need this too. I'm surprised you can't just have the option to export the first name as a standard option. It's available already in email templates. 

    @Robert Holder as far as I could see it's already enabled on your account. You should be able to have different columns for first- and last name in your list view and also on the contact person detail page there should be two fields. It will be a standard option in the future but there's some extra things we're still testing before we go live to the whole userbase. 

  • Gary Allen
    Gary Allen Member Posts: 17 VERIFIED MEMBER
    edited June 2020 #21

    Hi @Robert Holder 

    The First Name Last name Separation is great for list exporting, I've laso integrated Pipedrive with the ESP Klenty, and you great integration with good visibility of which campaigns you are sending emails through via Pipedrive filters.

    As I hate anyone here having to maually handle and clean lists on .csv its a reall boon.

  • Jan-Mikael Lepistö_7491
    Jan-Mikael Lepistö_7491 Member Posts: 1 VERIFIED MEMBER
    edited July 2020 #22

    I need this too. I'm surprised you can't just have the option to export the first name as a standard option. It's available already in email templates. 

    Hi @Mike van der Valk ,

    I need this option too for lists and exports.  My login (and email) is jan@kaks.io.

    Thanks a lot!

    Jan-Mikael

  • Kaitlin Borden
    Kaitlin Borden Member Posts: 1 VERIFIED MEMBER
    edited February 2022 #23

    Hi @Mike van der Valk ,

    We would love to use this at my company! Could you add this feature to kaitlin@merideewinters.com? Thanks!

  • Mike van der Valk
    Mike van der Valk Pipedrive Team Posts: 3,065 PIPEDRIVE TEAM
    2500 Comments Fourth Anniversary 100 Likes 5 Answers
    edited July 2020 #24

    I need this too. I'm surprised you can't just have the option to export the first name as a standard option. It's available already in email templates. 

    Hi @Jan-Mikael Lepistö I've enabled it for your account!

  • Mike van der Valk
    Mike van der Valk Pipedrive Team Posts: 3,065 PIPEDRIVE TEAM
    2500 Comments Fourth Anniversary 100 Likes 5 Answers
    edited July 2020 #25

    Hi @Mike van der Valk ,

    We would love to use this at my company! Could you add this feature to kaitlin@merideewinters.com? Thanks!

    Done @Kaitlin Borden :) 

  • SchwarmBatterie Support
    SchwarmBatterie Support Member Posts: 1 VERIFIED MEMBER
    edited February 2022 #26

    Hi. please enable this funtion for my account as well, thank you!

  • Mike van der Valk
    Mike van der Valk Pipedrive Team Posts: 3,065 PIPEDRIVE TEAM
    2500 Comments Fourth Anniversary 100 Likes 5 Answers
    edited August 2020 #27

    Hi. please enable this funtion for my account as well, thank you!

    @SchwarmBatterie Support it's on! 

  • Cahlan Sharp
    Cahlan Sharp Member Posts: 1 VERIFIED MEMBER
    edited February 2022 #28

    hi @Mike van der Valk can I get this enabled please?

  • Mike van der Valk
    Mike van der Valk Pipedrive Team Posts: 3,065 PIPEDRIVE TEAM
    2500 Comments Fourth Anniversary 100 Likes 5 Answers
    edited August 2020 #29

    hi @Mike van der Valk can I get this enabled please?

    Done, have fun! @Cahlan Sharp 

  • Safia Dodard
    Safia Dodard Member Posts: 1 VERIFIED MEMBER
    edited February 2022 #30

    Hi @Mike van der Valk,

    This seems like a popular feature! I'd love to have it enabled on my account as well please! Thanks :) 

  • Mike van der Valk
    Mike van der Valk Pipedrive Team Posts: 3,065 PIPEDRIVE TEAM
    2500 Comments Fourth Anniversary 100 Likes 5 Answers
    edited August 2020 #31

    Hi @Mike van der Valk,

    This seems like a popular feature! I'd love to have it enabled on my account as well please! Thanks :) 

    Done @Safia Dodard enjoy!