# Address Book Data Cleanup

**URL:** <https://community.glideapps.com/t/address-book-data-cleanup/79121>\
**Category:** Ask for Help\
**Created:** [January 10, 2025, 5:50pm UTC](https://community.glideapps.com/t/address-book-data-cleanup/79121 "2025-01-10T17:50:43Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mkbw](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mkbw/32/74637_2.png) [@mkbw](https://community.glideapps.com/u/mkbw)\
**Post date:** [January 10, 2025, 5:50pm UTC](https://community.glideapps.com/t/address-book-data-cleanup/79121/1 "2025-01-10T17:50:43Z")

</div>

Hi,

I’m working on address book solution to become a system-of-record for addresses in multiple foreign systems. I’ve have an export from another system with an incredible number of duplicates and near-duplicates with errors, typos, “Street” vs “St”, etc.

Total dataset is ~14,000 records. I suspect 70% of this is duplicates or near duplicates.

Have any of you tried using Glide or other tools to clean something up like this? Was thinking an LLM via API might be a solution?

The standing features in Excel are not up to the job on this.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [January 11, 2025, 1:20am UTC](https://community.glideapps.com/t/address-book-data-cleanup/79121/2 "2025-01-11T01:20:05Z")

</div>

My best guess would be something like this, or an autocomplete API, or maybe even a geocoding API?

> **[Address Validation API overview  |  Google for Developers](https://developers.google.com/maps/documentation/address-validation/overview)**

You have to standardize all sorts of variations into a structured format, and also hope those APIs can correct the typos as well.