clean customer list and find missing address info

We have a customer list with customer address and phone number entries. Currently the address information contains many incomplete or misspelled addresses. We would like someone to clean up the list, search for the correct address information using the available data and online search tools to complete the address. There are only 8750 records so not a very large list To clean up the list there are several online tools which are effective and finding the correct address: For addresses inside the city of edmonton there is a map tool provided by the city. It requires Internet explorer 32 bit and the Adobe SVG 3 plugin. Website: [login to view URL] Adobe SVG plugin download: [login to view URL] This tool is excellent at verifying the exact address down to the house number Of course for a more generic address search there is google maps. It's easier to navigate but cannot verify individual house numbers. For missing postal codes either the city of edmonton site or Canada post are useful: [login to view URL] For reverse directory search based on the phone number we have: [login to view URL] You are free to use any other address tool at your disposal to correct the data. Our primary goal is to be able to import the list of addresses into Google Earth Pro and show the locations of customers and which neighborhoods our stores are most popular at serving to help evaluate where we could use new locations. The secondary goal is to have a list we can use for mailing to send notices to customers. (orders not picked up after 30 days, etc)