I'm about to do my first import of contacts into a pre-existing CiviCRM database on WordPress. Client sent over the CSV but there are columns like this:

Home Phone Home Fax Mobile Phone Work Phone Work Fax

That's fine, but in the DB, the Contact Details set has a Phone field and two dropdowns, one for Phone Location and one for Phone Type. And the ability to add more numbers. So what's the best way to take this CSV and properly do an import?

1 Answer 1


I'm assuming that home and work are location types in your Civi? If that is in fact the case, the one question I would ask from what you included is what location type to assign to the mobile phone. Home and work would be location types, and phone type would be phone, mobile, or fax. You would then set up your mapping in the contact import to assign the correct location and phone types to each column. Here is a sample of what I mean:

enter image description here

(I chose home as the location type for the mobile but that might not be correct in your situation.)

Hope this helps, Lesley

  • Yes, I figured this out when testing out my first import. Pretty cool system. Thanks for confirming that for me.
    – Adam Bell
    Feb 26, 2016 at 22:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.