Zip Codes and Cities Matched in Excel

This project received 36 bids from talented freelancers with an average bid price of $92 USD.

Get free quotes for a project like this
Project Budget
Total Bids
Project Description

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.

Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online