+ Reply to Thread
Results 1 to 3 of 3

Adding City field to an existing spreadsheet

  1. #1
    Registered User
    Join Date
    03-31-2014
    Location
    New Orleans, LA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Adding City field to an existing spreadsheet

    I have a spreadsheet of over 8000 addresses. I have the street, state and zip but not the cities.

    Is there a way I can do a search and mass import of cities from a website, like USPS? I'd like to know if there is something I can do quickly rather than manually look each zip code up and enter it in one by one.

    Thanks,

  2. #2
    Forum Contributor
    Join Date
    04-07-2009
    Location
    Rowley
    MS-Off Ver
    Excel 2007
    Posts
    326

    Re: Adding City field to an existing spreadsheet

    Look here:

    http://www.unitedstateszipcodes.org/zip-code-database/

    Has both an Excel file and a CSV type file.

    With the Excel you only need do a VLookup and match the Zip Codes and pull out the city.

    You will probably still have to make some manual adjustments, but it should be minimal.

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Adding City field to an existing spreadsheet

    This website might have what you are looking for. It lists Excel format.

    https://www.zip-codes.com/free-zip-code-database.asp
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 12-28-2012, 07:38 PM
  2. Change an existing field to a calculated field using Show Values as
    By Excel_vba in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-16-2012, 01:50 PM
  3. Replies: 3
    Last Post: 03-03-2012, 12:16 PM
  4. Adding lookup table to existing spreadsheet
    By bellicusa in forum Excel General
    Replies: 1
    Last Post: 01-18-2012, 12:21 PM
  5. "Adding columns to existing spreadsheet"?
    By colink in forum Excel General
    Replies: 4
    Last Post: 01-30-2010, 11:01 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1