# Phone Numbers not pulling through from CSV import

**URL:** <https://community.hubspot.com/t/phone-numbers-not-pulling-through-from-csv-import/2089>\
**Category:** Lists, Lead Scoring & Workflows\
**Created:** [May 18, 2017, 7:21pm UTC](https://community.hubspot.com/t/phone-numbers-not-pulling-through-from-csv-import/2089 "2017-05-18T19:21:42Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![GG77](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/gg77/32/78471_2.png) [@GG77](https://community.hubspot.com/u/GG77)\
**Post date:** [May 18, 2017, 7:21pm UTC](https://community.hubspot.com/t/phone-numbers-not-pulling-through-from-csv-import/2089/1 "2017-05-18T19:21:42Z")

</div>

have imported contacts and have the CSV file correctly labelled with “Phone Number” and “Mobile Number” columns but for some reason they are not pulling through to the contact records. The CRM is bringing through company information based on the email address and there is a main company phone number there, but the direct dial number and the mobile number of the contact that is contained in the CSV file is not coming through. Can anyone help? I don’t want to have to manually paste 100 numbers and the same again for mobiles!

---

<div class="post-metadata">

**Author:** ![system](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/system/32/124_2.png) [@system](https://community.hubspot.com/u/system)\
**Post date:** [May 25, 2017, 10:33am UTC](https://community.hubspot.com/t/phone-numbers-not-pulling-through-from-csv-import/2089/2 "2017-05-25T10:33:45Z")

</div>

Hey @GG77 how are you formatting the numbers? Furthermore, are you using a CSV file from Excel or Google Sheets?

---

<div class="post-metadata">

**Author:** ![GG77](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/gg77/32/78471_2.png) [@GG77](https://community.hubspot.com/u/GG77)\
**Post date:** [May 25, 2017, 11:46am UTC](https://community.hubspot.com/t/phone-numbers-not-pulling-through-from-csv-import/2089/3 "2017-05-25T11:46:23Z")

</div>

Hi Tommy, thanks for replying. Im using a CSV file (and it’s pulling everything else through fine…). The number format is a bit varied now you mention it. Some have just numbers, some cells have +44 (or + and another country code) and some have spaces and some dont.

---

<div class="post-metadata">

**Author:** ![system](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/system/32/124_2.png) [@system](https://community.hubspot.com/u/system)\
**Post date:** [May 25, 2017, 1:06pm UTC](https://community.hubspot.com/t/phone-numbers-not-pulling-through-from-csv-import/2089/4 "2017-05-25T13:06:27Z")

</div>

I’d try standardizing these.

Perhaps try adding all numbers as 0044XXXXXXX first. I.e. the full country code and number.

If that fails, try using +44XXXXXXX.

If taht fails, try then formatinng the number with spaces. E.g. 0044 831613960.

This will help you narrow down if it’s an import format issue or not.

---

<div class="post-metadata">

**Author:** ![GG77](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/gg77/32/78471_2.png) [@GG77](https://community.hubspot.com/u/GG77)\
**Post date:** [May 25, 2017, 1:30pm UTC](https://community.hubspot.com/t/phone-numbers-not-pulling-through-from-csv-import/2089/5 "2017-05-25T13:30:23Z")

</div>

thank you so much. I’ll give it a go!