# Phone Number Formatting **URL:** \ **Category:** CRM\ **Tags:** contacts\ **Created:** [August 12, 2024, 6:18pm UTC](https://community.hubspot.com/t/phone-number-formatting/114329 "2024-08-12T18:18:28Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Shelby\_Both](https://avatars.discourse-cdn.com/v4/letter/s/b19c9b/32.png) [@Shelby\_Both](https://community.hubspot.com/u/Shelby_Both)\ **Post date:** [August 12, 2024, 6:18pm UTC](https://community.hubspot.com/t/phone-number-formatting/114329/1 "2024-08-12T18:18:28Z")
Hello! Is there a way to remove the phone number format in bulk? I have added the +1 before I import the contact information but it is not registering it and I have had to go through every contact to add the United States code to each number. Without it, they wonโ€™t register as correct numbers that I can send marketing texts to. Thank you, ---
**Author:** ![DianaGomez](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dianagomez/32/48035_2.png) [@DianaGomez](https://community.hubspot.com/u/DianaGomez)\ **Post date:** [August 13, 2024, 11:42am UTC](https://community.hubspot.com/t/phone-number-formatting/114329/2 "2024-08-13T11:42:23Z")
Hi [@Shelby\_Both](https://community.hubspot.com/t5/user/viewprofilepage/user-id/809124), Thanks for reaching out to the Community, I hope you are great ๐Ÿ™‚ A phone number is considered valid if it starts with +1, and is a total of 11 digits, including the +1. For example, **+1-800-555-5555** is a valid US-based number, as documented [**here**](https://knowledge.hubspot.com/sms/create-and-send-sms-messages#:~:text=A%20phone%20number%20is%20considered%20valid%20if%20it%20starts%20with%20%2B1%2C%20and%20is%20a%20total%20of%2011%20digits%2C%20including%20the%20%2B1.%20For%20example%2C%20%2B1%2D800%2D555%2D5555%20is%20a%20valid%20US%2Dbased%20number.). Right now there is not a built in way to format phone numbers in bulk or automatically. There are however some integrations that you can use to do the formatting such as this one: [**https://ecosystem.hubspot.com/marketplace/apps/marketing/analytics-data/phone-number-formatter**](https://ecosystem.hubspot.com/marketplace/apps/marketing/analytics-data/phone-number-formatter? __hstc=75491725.2945bc48514310c6aa06023a564e97c9.1711396908874.1711910686244.1711980895703.25&__ hssc=75491725.7.1711980895703&__hsfp=2174296116) To bulk update the phone numbers, we can follow these steps: - Export your contact list from HubSpot with the existing phone numbers. - In the exported spreadsheet, use a data cleaning tool or Excel functions to format the phone numbers correctly. This [**article**](https://knowledge.hubspot.com/import-and-export/set-up-your-import-file#:~:text=Phone%20number%3A%20the,like%20%2B11234567890%20ext123.) shows us how to format the phone numbers. - Save the updated spreadsheet with the corrected phone numbers. - Go to your HubSpot portal and navigate to Contacts \> Import. I found his post: [**Custom Coded Workflow for Formatting Phone Number**](https://community.hubspot.com/t5/CMS-Development/Custom-Coded-Workflow-for-Formatting-Phone-Number/td-p/872708), they posted the code they are using and they had an error but seems to have been resolved. And this other Post in the search here: [**Format Phone Number**](https://community.hubspot.com/t5/forums/searchpage/tab/message?advanced=false&allow_punctuation=false&q=Format%20Phone%20Number) where workarounds were shared by other users. Hope that helps! Diana ---
**Author:** ![RBozeman](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/rbozeman/32/8786_2.png) [@RBozeman](https://community.hubspot.com/u/RBozeman)\ **Post date:** [August 14, 2024, 11:06pm UTC](https://community.hubspot.com/t/phone-number-formatting/114329/3 "2024-08-14T23:06:59Z")
I believe that to do something liek this you would have to use Ops Hub or the API, but that may take some organizing of resources to make that happen. Also wanted to mention (and full disclosure, I work for them) Insycle does bulk phone number formatting, and has templates for all of the popular phone formats. Then, you can build custom templates for handling advanced situations like formats in specific countries with country codes, extensions, etc. It may be worth checking out. [Here is an article](https://blog.insycle.com/standardize-phone-numbers-hubspot) that covers this feature to give you an idea of how it works. ---
**Author:** ![DBRAHIM](https://avatars.discourse-cdn.com/v4/letter/d/c57346/32.png) [@DBRAHIM](https://community.hubspot.com/u/DBRAHIM)\ **Post date:** [April 8, 2025, 10:23pm UTC](https://community.hubspot.com/t/phone-number-formatting/114329/4 "2025-04-08T22:23:30Z")
Hi [@Shelby\_Both](https://community.hubspot.com/t5/user/viewprofilepage/user-id/809124) Feel free to try [lintphone.com](https://lintphone.com/) โ€“ it lets you validate and format phone numbers automatically, right from a HubSpot workflow. Best regards ---
**Author:** ![MTonmoy9](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mtonmoy9/32/27282_2.png) [@MTonmoy9](https://community.hubspot.com/u/MTonmoy9)\ **Post date:** [July 22, 2025, 12:18pm UTC](https://community.hubspot.com/t/phone-number-formatting/114329/5 "2025-07-22T12:18:54Z")
You can check out Smart Phone number formatter app [https://www.formatphonenumber.com/](https://www.formatphonenumber.com/) it has a workflow action.