I have an excel list of about 780 cities in the US (includes this information ie: Riverside, Anaheim CA US)(Attached File Charter Internet). I also have another excel list with 3300 cities including state, county, city(attached file time warner residential). Lastly, I have a list of 42,000 zip codes from the US (with city, county and state information included as well) (Unfortunately this file is too large to be uploaded so please message me on freelancer to obtain). I need all the zip codes on the third list that correspond to the cities on each of the first two lists to be matched up and compiled in to two new separate excel worksheets. Please keep the the lists of cities completely separate (Do not mix Charter with time warner) and add all the corresponding zip codes, some cities will have multiple zip codes applicable. If it makes sense, it is possible to add a zip code column to the existing city lists as long as all zip codes for each city are matched correctly.
To clarify I would like cities and zip codes only for both lists, still keeping them independent of one another and I have attached a sample of the zip code file I have available. As seen in the file, there are multiple zip codes for the city of Birmingham so I would need each of those listed out individually for that city, not in any type of grouping (ie. 20000-20009)
35 freelancers are bidding on average $89 for this job
Hello jaredculver, We are professional & skilled team with experienced in this track. Understood your project requirement. Complete proposal on PM. Please check it out. Regards vSOL CORP.
This is very simple. I will send you a message to request the zip code file. While you're considering the other bids, I'll be completing the task for you! Regards, Mitchell Allen