Answers.Body: <p>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: </p>
  
  <p><a href="https://i.sstatic.net/NyluR.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/NyluR.png" alt="enter image description here"></a></p>
  
  <p>(I chose home as the location type for the mobile but that might not be correct in your situation.)</p>
  
  <p>Hope this helps,
  Lesley</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-26T22:22:16.180Z
Answers.Text: Yes, I figured this out when testing out my first import. Pretty cool system. Thanks for confirming that for me.
Answers.UserDisplayName: Adam Bell
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-26T20:36:15.840Z
Answers.LastActivityDate: 2016-02-26T21:00:02.860Z
Answers.LastEditDate: 2016-02-26T21:00:02.860Z
Answers.UserDisplayName: Lesley Carter - BackOffice
Body: <p>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:</p>
  
  <p>Home Phone
  Home Fax
  Mobile Phone
  Work Phone
  Work Fax</p>
  
  <p>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?</p>
  
Tags: <contacts><import><database><phone>
Title: Importing phone/fax/mobile phone numbers from CSV.....best practices?
ThreadText: # Importing phone/fax/mobile phone numbers from CSV.....best practices?
  
  (Asked by: username_0 on 2016-02-26)
  
  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?
  
  **Tags:** contacts, import, database, phone
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2016-02-26. Score: 4 | Accepted answer
  
  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](https://i.sstatic.net/NyluR.png)](https://i.sstatic.net/NyluR.png)
  
  (I chose home as the location type for the mobile but that might not be correct in your situation.)
  
  Hope this helps,
  Lesley
  
  > **Comments:**
  > **username_0**: Yes, I figured this out when testing out my first import. Pretty cool system. Thanks for confirming that for me.  
  
  ---
  
  