# Address Cleanup Pre-Import

**URL:** <https://community.hubspot.com/t/address-cleanup-pre-import/75641>\
**Category:** CRM\
**Tags:** starter\
**Created:** [February 21, 2023, 3:15pm UTC](https://community.hubspot.com/t/address-cleanup-pre-import/75641 "2023-02-21T15:15:17Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![HDiDomenico](https://avatars.discourse-cdn.com/v4/letter/h/a9adbd/32.png) [@HDiDomenico](https://community.hubspot.com/u/HDiDomenico)\
**Post date:** [February 21, 2023, 3:15pm UTC](https://community.hubspot.com/t/address-cleanup-pre-import/75641/1 "2023-02-21T15:15:17Z")

</div>

Hi! My company will be switching to HubSpot soon, and I’m reviewing current data to plan for cleanup and import. We appear to have a huge mess with physical addresses, and I’m hoping someone has a suggestion for cleanup.

Our client addresses are in multiple countries, and the current CRM just has a large multi-line text field for the entire address. The addresses have been entered by a lot of different people, and there is no consistency in formatting. All of the Excel cleanup tricks I can find don’t really apply (inconsistent comma usage, inconsistent order of information, etc).

Do you know of any tools I can use to clean this up prior to import, or is this something we’ll have to do on a record-by-record basis? It’s not the biggest data import - maybe 800 records - but still something I’d prefer not to have to do by hand. 🙂

Thanks!!  
Holley

---

<div class="post-metadata">

**Author:** ![tverdokhlib1](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/tverdokhlib1/32/58857_2.png) [@tverdokhlib1](https://community.hubspot.com/u/tverdokhlib1)\
**Post date:** [February 21, 2023, 9:06pm UTC](https://community.hubspot.com/t/address-cleanup-pre-import/75641/2 "2023-02-21T21:06:20Z")

</div>

Hi there,

You may use this [Insycle](https://app.hubspot.com/ecosystem/6325387/marketplace/apps/marketing/data-management/insycle)

With the help of this app, you can either clean up your data before importing it to HubSpot or do it within HubSpot because Insycle Data Management is a HubSpot-certified app.

You can also manage duplicates and missed data there or through HubSpot.

In regards to changing the addresses, I think there has to be some manual work as well, of course. But when it is done, you can standardize how everybody will input the data to HubSpot.