# Fix Formatting Issues **URL:** \ **Category:** CRM\ **Created:** [July 20, 2022, 11:37am UTC](https://community.hubspot.com/t/fix-formatting-issues/61331 "2022-07-20T11:37:18Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![AMulready](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/amulready/32/49683_2.png) [@AMulready](https://community.hubspot.com/u/AMulready)\ **Post date:** [July 20, 2022, 11:37am UTC](https://community.hubspot.com/t/fix-formatting-issues/61331/1 "2022-07-20T11:37:18Z")
Currently going through fixing formatting issues on names and emails. Can only currently pick 50 at a time which is fine if noticed at the start but now have a database of 35k of incorrect formatting and capitilization (over 700 pages of data) Would like to be able to select much more, select all or over 100 per page ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [July 20, 2022, 11:45am UTC](https://community.hubspot.com/t/fix-formatting-issues/61331/2 "2022-07-20T11:45:13Z")
Hi @AMulready, How exactly are you fixing these issues? There are different ways to approach this: 1. Export contacts, correctly capitalize in Excel or Google Sheets, reimport contacts. Fastest, easiest and cheapest solution. 2. Use [data quality automation](https://knowledge.hubspot.com/workflows/format-your-data-with-workflows) (workflow action) in HubSpot Operations Hub Professional. This lives right within HubSpot. 3. Evaluate third-party solutions like [Insycle](https://www.insycle.com/hubspot/). Insycle lets you apply formatting rules for your records. Let me know if you have questions about one of these. Hope this helps! ---
**Author:** ![AdamLPW](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/adamlpw/32/29368_2.png) [@AdamLPW](https://community.hubspot.com/u/AdamLPW)\ **Post date:** [July 20, 2022, 1:30pm UTC](https://community.hubspot.com/t/fix-formatting-issues/61331/3 "2022-07-20T13:30:49Z")
@AMulready, +1 for Insycle. It’s a really cheap tool, but makes these kind of bulk operations incredibly easy and painless. Just chugs through all your HubSpot data and allows preview/fix/schedule options. ---
**Author:** ![AMulready](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/amulready/32/49683_2.png) [@AMulready](https://community.hubspot.com/u/AMulready)\ **Post date:** [July 22, 2022, 8:06am UTC](https://community.hubspot.com/t/fix-formatting-issues/61331/4 "2022-07-22T08:06:37Z")
I used a workflow in the end to change the First Names to capitalization. It worked great, I can share it below [Format Data with Workflows](https://knowledge.hubspot.com/workflows/format-your-data-with-workflows) ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [July 22, 2022, 8:19am UTC](https://community.hubspot.com/t/fix-formatting-issues/61331/5 "2022-07-22T08:19:09Z")
Hi @AMulready, Nice! This is the second step I suggested here: > * * * > > @karstenkoehler wrote: > > Use [data quality automation](https://knowledge.hubspot.com/workflows/format-your-data-with-workflows) (workflow action) in HubSpot Operations Hub Professional. This lives right within HubSpot. > > * * * (It’s the same link as you shared.) In any case, glad it’s resolved. If you want to make it easier for others to find these options, you can help them by [accepting my earlier post as a solution](https://community.hubspot.com/t5/CRM/Fix-Formatting-Issues/m-p/668104/highlight/true#M134868). I’d appreciate it. Have a great weekend! ---
**Author:** ![AMulready](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/amulready/32/49683_2.png) [@AMulready](https://community.hubspot.com/u/AMulready)\ **Post date:** [July 20, 2022, 11:55am UTC](https://community.hubspot.com/t/fix-formatting-issues/61331/6 "2022-07-20T11:55:30Z")
Hi Karsten, I am going through it via the fix formatting issues section It only allows 50 at a time, but obviosuly this takes a massive amount of time, Thanks, Karsten ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [July 20, 2022, 11:57am UTC](https://community.hubspot.com/t/fix-formatting-issues/61331/7 "2022-07-20T11:57:15Z")
Hi @AMulready, Thank you for that added context. In that case, please review the options that I suggested – the behavior of the fix formatting tool cannot be changed as far as I know. Best regards! ---
**Author:** ![AMulready](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/amulready/32/49683_2.png) [@AMulready](https://community.hubspot.com/u/AMulready)\ **Post date:** [July 20, 2022, 1:12pm UTC](https://community.hubspot.com/t/fix-formatting-issues/61331/8 "2022-07-20T13:12:21Z")
How do I create a list of those with formatting errors? I can see them within the picture i sent you but have no way to export them out or create a list from them ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [July 20, 2022, 1:22pm UTC](https://community.hubspot.com/t/fix-formatting-issues/61331/9 "2022-07-20T13:22:47Z")
Hi @AMulready, Unfortunately, this does not seem to be possible. You would have to export all contacts and then filter those in an Excel file which are not capitalized correctly, for example. Best regards! ---
**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:** [October 24, 2022, 11:50pm UTC](https://community.hubspot.com/t/fix-formatting-issues/61331/10 "2022-10-24T23:50:20Z")
Thank you for mentioning Insycle @AdamLPW and @karstenkoehler. I work there 🙂 I wanted to pop in and add a little more context for @AMulready. So, [Insycle](https://app.hubspot.com/ecosystem/6303986/marketplace/apps/marketing/data-management/insycle) can format any text field in HubSpot CRM, based on the rules you set. For fields that commonly need standardization or formatting—like personal names, company names, phone numbers, addresses, job titles, industries, countries, states, etc.—Insycle offers pre-built templates that allow you to format these fields out of the box. You can also build your own custom templates for other fields or for problems that are unique to your database. Then you can schedule those templates for automation so that your fields are always formatted consistently on a set schedule. You can even inject Insycle’s operations into HubSpot Workflows so that the formatting happens immediately after data hits HubSpot CRM and before your first communications to those contacts go out. Alternatively, I would be remiss if I didn’t recommend Operations Hub as well. You can do formatting there as well as coding custom solutions for unique issues. Best, Ryan ---
**Author:** ![NMiller4](https://avatars.discourse-cdn.com/v4/letter/n/9d8465/32.png) [@NMiller4](https://community.hubspot.com/u/NMiller4)\ **Post date:** [May 22, 2024, 6:12pm UTC](https://community.hubspot.com/t/fix-formatting-issues/61331/11 "2024-05-22T18:12:48Z")
These options dont help when trying to either fix location formats when you have a bucket load annoyingly. If there was an option to pick 500 a time or more etc would realy be beneficial. Or the option to turn it off