Zip Code List in Microsoft Excel
- Order:
- Duration: 2:57
- Published: 2009-01-05
- Uploaded: 2010-08-27
- Author: bjhughesfs
www.cdxtech.com - Create zip code lists (by city, state, or county) in Microsoft Excel. Try a free, 30-day no risk trial.
these configurations will be saved for each time you visit this page using this browser
ZIP codes are a system of postal codes used by the United States Postal Service (USPS) since 1963. The term ZIP, an acronym for Zone Improvement Plan, is properly written in capital letters and was chosen to suggest that the mail travels more efficiently, and therefore more quickly, when senders use the code in the postal address. The basic format consists of five decimal numerical digits. An extended ZIP+4 code, introduced in the 1980s, includes the five digits of the ZIP code, a hyphen, and four more digits that determine a more precise location than the ZIP code alone. The term ZIP code was originally registered as a servicemark (a type of trademark) by the U.S. Postal Service, but its registration has since expired.
The United States Post Office Department (USPOD) implemented postal zones for large cities in 1943. For example:
:Mr. John Smith :3256 Epiphenomenal Avenue :Minneapolis 16, Minnesota
The "16" is the number of the postal zone within the city.
By the early 1960s a more general system was needed, and on July 1, 1963, non-mandatory ZIP codes were announced for the whole country. Simultaneously with the introduction of the ZIP code, two letter state abbreviations were introduced. These were to be written with both letters capitalized. The reason for the two-letter abbreviations is that it was thought that a long city name coupled with a multi-letter state abbreviation (e.g. Mass. for Massachusetts) would be too long for address labels used on magazines when the ZIP code was added. Robert Moon, an employee of the post office, is considered the father of the ZIP code; he submitted his proposal in 1944 while working as a postal inspector. The post office gives credit to Moon for only the first three digits of the ZIP code, which describe the sectional center facility (SCF) or "sec center." An SCF is a central mail processing facility with those three digits. The SCF sorts mail to all post offices with those first three digits in their ZIP codes. The mail is sorted according to the final two digits of the ZIP code and sent to the corresponding post offices in the early morning. Sectional centers do not deliver mail and are not open to the public (though the building may include a post office open to the public), and most of the workers are employed to work night shift. Mail picked up at post offices is sent to their own SCF in the afternoon, where the mail is sorted overnight. In the cases of large cities, the last two digits coincided with the older postal zone number, thus:
:Mr. John Smith :3256 Epiphenomenal Avenue :Minneapolis, Minnesota 55416
In 1967, these were made mandatory for second- and third-class bulk mailers, and the system was soon adopted generally. The United States Post Office used a cartoon character, Mr. ZIP, to promote use of the ZIP code. He was often depicted with a legend such as "USE ZIP CODE" in the selvage of panes of stamps or on labels contained in, or the covers of, booklet panes of stamps. Curiously enough, the only time the Postal Service issued a stamp promoting the ZIP code, in 1974, Mr. ZIP was not depicted.
A ZIP+4 code uses the basic five-digit code plus four additional digits to identify a geographic segment within the five-digit delivery area, such as a city block, a group of apartments, an individual high-volume receiver of mail or any other unit that could use an extra identifier to aid in efficient mail sorting and delivery. Initial attempts to promote universal use of the new format met with public resistance, and today the plus-four code is not required. In general, mail is read by a multiline optical character reader (MLOCR) that almost instantly determines the correct ZIP+4 code from the address and—along with the even more specific delivery point—sprays a Postnet barcode on the face of the mailpiece that corresponds to 9 digits.
For post-office boxes, the general (but not invariable) rule is that each box has its own ZIP+4 code. The add-on code is often one of the following: the last four digits of the box number (e.g., PO Box 58001, Washington DC 20037-8001), zero plus the last three digits of the box number (e.g., PO Box 12344, Chicago IL 60612-0344), or, if the box number consists of fewer than four digits, enough zeros prepended to the front of the box number to produce a four-digit number (e.g., PO Box 52, Garrett Park MD 20896-0052). However, there is no uniform rule, so the ZIP+4 code must be looked up individually for each box.
It is common to use add-on code 9998 for mail addressed to the postmaster (to which requests for pictorial cancellations are usually addressed), 9999 for general delivery and other high-numbered add-on codes for business reply mail. For a unique ZIP code (explained below), the add-on code is typically 0001.
The ZIP code is often translated into a barcode called Postnet that is printed on the mailpiece to make it easier for automated machines to sort. Unlike most barcode symbologies, Postnet uses long and short bars, not thin and thick bars. The barcode can be printed by the person who sends the mail (some word-processing programs such as WordPerfect and Microsoft Word include the feature), or the post office will put one on when it processes the piece. In general, the post office uses OCR technology, though a human may have to read the address if absolutely necessary.
People who send bulk mail can get a discount on postage if they have printed the barcode themselves. This requires more than just a simple font; mailing lists must be standardized with up-to-date Coding Accuracy Support System (CASS)-certified software that adds and verifies a full, correct ZIP+4 code and an additional two digits representing the exact delivery point. Furthermore, mail must be sorted in a specific scheme and be accompanied by documentation verifying this. These steps are usually done with PAVE-certified software that also prints the barcoded address labels and barcoded sack or tray tags.
This means that every single mailable point in the country has its own 12-digit number (at least in theory). The delivery-point digits (the 10th and 11th digits) are calculated based on the primary or secondary number of the address. The USPS publishes the rules for calculating the delivery point in a document called the CASS Technical Guide. The last digit is always a check digit, which is obtained by summing all 5, 9 or 11 digits, taking the residue modulo 10 of this sum (i.e., the remainder after dividing by 10) and finally subtracting this from 10. (Thus, the check digit for 10001-0001 00 would be 7, since 1+1+1=3, 3≡3(mod 10) and 10–3=7.) An application needs only to print something like /100010001007/ in the 12-point Postnet font to create a valid barcode. The slashes "/" are translated into start/stop characters (one long bar), and each digit is translated into a sequence of two long bars and three short bars.
On business-reply mail, the FIM code primarily indicates the orientation (facing) of the mailpiece, since there is, in general, not a stamp or postage meter imprint containing fluorescent ink (which is usually used by the facing machine to orient mail). Additionally, FIM codes A and C indicate that a Postnet bar code is present, allowing this mail to bypass the MOCR and go straight to a barcode scanning machine. For that reason, even though courtesy reply mail and metered reply mail are mailed with a stamp or a postage-meter imprint, they typically carry an FIM code, namely FIM A, to indicate that the Postnet bar code is present. The FIM D barcode is used for computer-generated indicia from online postage meters.
In general, the first three digits designate a sectional center facility, the mail sorting and distribution center for an area. A sectional center facility may have more than one three-digit code assigned to it. For example, the Northern Virginia sectional center facility in Merrifield is assigned codes 220, 221, 222 and 223. In some cases, a sectional center facility may serve an area in an adjacent state, usually due to the lack of an appropriate location for a center in that region. For example, 739 in Oklahoma is assigned to Liberal, Kansas; 865 in Arizona is assigned to Gallup, New Mexico; and 961 in California to Reno, Nevada.
In terms of geographic location, many of the lowest ZIP codes, which begin with '0', are in the New England region. Also in the '0' region are New Jersey (non-contiguous with the remainder of the '0' area), Puerto Rico, the U.S. Virgin Islands and APO/FPO military addresses for personnel stationed in Europe, Africa, Southwest Asia and aboard vessels based in the waters adjoining those lands; APO/FPO addresses are also used by U.S. diplomatic and consulary facilities. The lowest ZIP code is in Holtsville, New York (00501, a ZIP code exclusively for the U.S. Internal Revenue Service center there). Other low ZIP codes are 00601 for Adjuntas, Puerto Rico; 01001 for Agawam, Massachusetts, and 01002 for Amherst, Massachusetts. Until 2001, there were six ZIP codes lower than 00501 that were numbered from 00210 to 00215 (located in Portsmouth, New Hampshire) and were used by the Diversity Immigrant Visa program to receive applications from non-U.S. citizens.
The numbers increase southward along the East Coast, such as 02115 (Boston), 10001 (New York City), 19103 (Philadelphia), 20008 (Washington, D.C.), 30303 (Atlanta) and 33130 (Miami) (these are only examples, as each of these cities contain several ZIP codes in the same range). From there, the numbers increase heading westward and northward east of the Mississippi River, southward west of the Mississippi River, and northward on the west coast. For example, 40202 is in Louisville, 50309 in Des Moines, 60601 in Chicago, 77063 in Houston, 80202 in Denver, 94111 in San Francisco, 98101 in Seattle, and 99950 in Ketchikan, Alaska (the highest ZIP code).
The first digit of the ZIP code is allocated as follows:
*0 = Connecticut (CT), Massachusetts (MA), Maine (ME), New Hampshire (NH), New Jersey (NJ), Puerto Rico (PR), Rhode Island (RI), Vermont (VT), Virgin Islands (VI), Army Post Office Europe (AE), Fleet Post Office Europe (AE)
In most urban areas, like 462 for Marion County, Indiana, the three-digit prefix will often exist in one county, while, in rural and most suburban areas, the prefix will exist in multiple counties, for example, the neighboring 476 prefix is found in part or in entirely in six counties: Gibson, Pike, Posey, Spencer, Vanderburgh, and Warrick. In some cases, an urban county may have more than one prefix. This is the case with Allen (467, 468), Lake (464, 463), St. Joseph (465, 466), and Vanderburgh (476, 477) Counties. Cities like Chicago, Houston, Los Angeles, and New York have multiple prefixes within their city limits.
Despite the geographic derivation of most ZIP codes, the codes themselves do not represent geographic regions; in general, they correspond to address groups or delivery routes. As a consequence, ZIP code "areas" can overlap, be subsets of each other, or be artificial constructs with no geographic area (such as 095 for mail to the Navy, which is not geographically fixed). In similar fashion, in areas without regular postal routes (rural route areas) or no mail delivery (undeveloped areas), ZIP codes are not assigned or are based on sparse delivery routes, and hence the boundary between ZIP code areas is undefined. For example, some residents in or near Haubstadt, Indiana, which has the zip code 47639, have mailing addresses with 47648, the ZIP code for neighboring Fort Branch, Indiana, while others living in or near Fort Branch have addresses with 47639. Many rural counties have similar logistical inconsistencies caused by the aforementioned sparse delivery routes, often known as Rural Routes or by some other similar designation.
For example, U.S. government agencies in and around the capital are assigned ZIP codes starting with 20200 to 20599, which are Washington, D.C., ZIP codes, even if they are not located in Washington itself. While the White House itself is located in ZIP code 20006, it has the ZIP code 20500. The Nuclear Regulatory Commission is located in Rockville, Maryland, at ZIP code 20852, but has been assigned by the Postal Service the address "Washington, DC 20555". The United States Patent and Trademark Office used to be located in Crystal City, Virginia at ZIP code 22202 but was assigned by the Postal Service the address "Washington, DC 20231"; however, since its move to Alexandria, Virginia, it uses the ZIP+4 code 22313-1450.
In similar manner, the ZIP code for the Metropolitan Washington Airports Authority, a federally-chartered independent authority, is 20001-6000, even though the physical address of the Authority's office, "1 Aviation Circle", is in Arlington, Virginia.
In rare circumstances, a locality is assigned a ZIP code that does not match the rest of the state; in other words, a ZIP code may cross state lines. In general, the locality is so isolated that it is most conveniently served from a sectional center in another state. Examples:
Default place names are typically the actual city or town that the address is located in. However, for many cities that have incorporated since ZIP codes were introduced, the actual city name is not the default place name. Many databases automatically assign the default place name for a ZIP code, without regard to any acceptable place names. For example, Centennial, Colorado, is divided among seven ZIP codes assigned to Aurora, Englewood or Littleton as its default place names. Thus, from the perspective of the U.S. Postal Service, the city of Centennial does not exist—it is part of Aurora, Englewood or Littleton. In the ZIP-code directory, Centennial addresses are listed under those three cities. And since it is acceptable to write "Centennial" in conjunction with any of the seven ZIP codes, one can write "Centennial" in an address that is actually in Aurora, Englewood, or Littleton, as long as it is in one of the shared ZIP codes.
Acceptable place names are often added to a ZIP code in cases where the ZIP-code boundaries divide them between two or more cities, as in the case of Centennial. However, in many cases only the default name can be used, even when many addresses in the ZIP code are in another city. For example, approximately 85% of the area served by the ZIP code 85254, to which the place name Scottsdale, Arizona, is assigned, is actually inside the city limits of neighboring Phoenix. This is because the post office that serves this area is in Scottsdale. This has led some residents of the ZIP code to believe that they live in Scottsdale when they actually live in Phoenix. A Scottsdale website listing the positive and negative aspects of the city mentioned the 85254 ZIP code as a positive aspect because Scottsdale is being used for businesses located outside the Scottsdale city limits.
The result of this is that sometimes people must use the name of a different city than their own. One of the better-known examples is the neighborhood of the city of Los Angeles, which shares the famous ZIP code 90210 with the city of Beverly Hills, and is therefore known as Beverly Hills Post Office.
Another example is Missouri City, Texas, which is in both Harris and Fort Bend counties and is a suburb of Houston. The portion that is within Harris County is within the ZIP code 77071, which must use the city Houston instead of Missouri City. A tiny portion of the city of Houston is in Fort Bend County in the ZIP code 77489, and residents there must use the city Missouri City for their address even though they are within the city limits of Houston. A former mayor and a city council member in Houston lived in Fort Bend county and were accused of not living in Houston since they had an address of Missouri City.
This phenomenon is repeated across the country. The previously mentioned Englewood, Colorado is an inner-ring suburb that was built out by the 1960s. Its post office served the area that is now the high-growth southern tier of the Denver metropolitan area, and ZIP codes in this area were assigned Englewood as their default place name. An employment center as large as downtown Denver has grown in this area, and its office parks are the headquarters for many internationally recognized corporations. Even though they are actually located in other cities, they indicate Englewood as their location, as this is the default postal place name. As a result, there are really two Englewoods — the actual city, small and with a largely working-class residential population, and, a number of miles away, the postal Englewood, a vast suburban area of upscale subdivisions and office parks that have nothing to do with the city of Englewood yet share a split identity with it solely because of ZIP codes. People who say that they live or work in Englewood and identify closely with it may rarely enter the actual city of that name. In Indiana, the ZIP code for a town usually indicates the ZIP code for its corresponding township, as nearly all of Indiana's small town post offices have rural routes.
In 2009, a Milwaukee Public Schools science teacher was fired from his job teaching science at Custer High School; MPS requires that all of its teachers live within Milwaukee city limits. Milwaukee shares a ZIP code with Brown Deer, 53223, and mail with that ZIP code can be addressed to either Milwaukee or Brown Deer and be delivered to the correct address, given the street name. Dan Bearss was forced to resign for living in Brown Deer.
Acceptable place names also come into play in areas of the country where many citizens identify more strongly with a particular urban center than the municipality they actually live in. For example, Allegheny County, Pennsylvania, has 130 distinct municipalities, but many of the county's residents, and even some residents of adjacent counties, commonly use Pittsburgh, PA as their postal address. Similarly, Hollywood, CA is an acceptable place name for ZIP code 90028, despite the fact that Hollywood is a district of Los Angeles and not a municipality or census-designated area (the default place name is Los Angeles, CA).
Many ZIP codes are for villages, census-designated places, portions of cities, or other entities that are not municipalities. For example, ZIP code 03750 is for Etna, New Hampshire, but Etna is not a city or town; it is actually a village district in the town of Hanover, which itself is assigned the ZIP code 03755. Another example is ZIP code 08043, which corresponds to the census-designated place of Kirkwood, New Jersey, but actually serves the entirety of Voorhees Township. This is also the case in LaGrange, New York, a portion of which is served by the 12603 ZIP code based in the neighboring town of Poughkeepsie. The rest of LaGrange is served by the LaGrangeville Post Office. LaGrangeville is itself not a town at all, but a section of LaGrange. Willow Grove, Pennsylvania, served by the 19090 ZIP code, is a village that straddles the border of Upper Moreland Township and Abington Township, and that post office also serves a small portion of Upper Dublin Township. Furthermore, non-municipal place names may also share ZIP codes with municipal place names. For example, West Windsor Township, New Jersey, is commonly referred to in most mailing databases as Princeton Junction, a census-designated place within West Windsor.
The postal designations for place names become de facto locations for their addresses, and as a result it is difficult to convince residents and businesses that they actually are located in another city or town different from the "default" place name associated with their ZIP codes. Because of the confusion and lack of identity generated by this situation, some cities, such as Signal Hill, California, have successfully petitioned the Postal Service to change ZIP-code boundaries or create new ZIP codes so that their cities can be the default place name for addresses within the ZIP code.
This confusion also can have financial implications for local governments, because mail volume is among the factors used by the U.S. Census Bureau to estimate population changes between decennial census enumerations. Sometimes local officials in a community that is not the default place name for a ZIP code but is an acceptable place name will advise residents to always use the name of the community, because if the census estimate of that town's population is low they will get fewer state and federal funds that are computed based on population. A very typical example of this is Paddock Lake, Wisconsin, whose default place name is Salem. Paddock Lake is incorporated as a village within the town of Salem, even though there are more people in the village of Paddock Lake than there are in the unincorporated parts of the town of Salem. Further confusion is caused because Silver Lake, Wisconsin, which is also a village in the town of Salem and is of similar size and status to Paddock Lake, has its own ZIP code and post office.
In another case, the U.S. Federal Communications Commission (FCC) denied a radio station (now WNNX FM) a move requiring a change in its city of license to Sandy Springs, Georgia, in large part because it was not a city (until municipal incorporation in late 2005), despite being the seventh-largest place in the state by population. The FCC cited the use of "Atlanta" on letters of support from local organizations, even though the USPS forced them to use Atlanta for 30328 until well after incorporation took effect. Even now, "Sandy Springs" is only "acceptable", despite none of 30328 being in Atlanta, or anywhere else outside the Sandy Springs city limit. This even applies to the ZIP code used only for PO boxes at the Sandy Springs main post office.
Because ZIP codes and their associated place names ignore county lines, this also creates problems where street addresses are based on which quadrant of the county they are in. For example, 30339 is Vinings, Georgia, located in southeastern Cobb County; therefore everything is labeled SE, and has a house number on that county's grid (according to the distance from the town square in the county seat). However, because the USPS demands the use of Atlanta, Vinings addresses are written such that they appear to be in southeast Atlanta, instead of on the opposite (northwest metro Atlanta) side where they actually are. This can also cause problems with 9-1-1 caller location, which in Johns Creek, Georgia led to the death of a person when her ambulance was sent to the wrong address by the emergency dispatcher.
In rapidly growing communities, it is sometimes necessary to open a new sectional center facility, which must then be allocated its own three-digit ZIP-code prefix or prefixes. Such allocation can be done in various ways. For example, when a new sectional center facility was opened at Dulles Airport in Virginia, the prefix 201 was allocated to that facility; therefore, for all post offices to be served by that sectional center facility the ZIP code changed from an old code beginning with 220 or 221 to a new code or codes beginning with 201. However, when a new sectional center facility was opened to serve Montgomery County, Maryland, no new prefix was assigned. Instead, ZIP codes in the 207 and 208 ranges, which had previously been assigned alphabetically, were reshuffled so that 207xx ZIP codes in the county were changed to 208xx codes, while 208xx codes outside that county were changed to 207xx codes. Because Silver Spring (whose postal area includes Wheaton) has its own prefix, 209, there was no need to apply the reshuffling to Silver Spring; instead, all mail going to 209xx ZIP codes was simply rerouted to the new sectional center facility.
On the other hand, depopulation may cause a post office to close and its associated ZIP code to be deallocated. For example, Centralia, Pennsylvania's ZIP code 17927 was retired in 2002.
Elkins Park, Pennsylvania was originally issued the 19117 zip code, although it lies in Montgomery County. Because of the 191 prefix, which is found only in Philadelphia with that lone exception, auto insurance companies charged higher city premiums to that suburban location. For that reason, residents petitioned the USPS for a 190-prefix ZIP code, which is common to the inner-ring Pennsylvania suburbs of that city, and, after several attempts that were initially disapproved by the USPS, Elkins Park was finally reassigned to the 19027 ZIP code.
ZIP codes also change when postal boundaries are realigned. For example, at the same time at which the above-noted change in Montgomery County took place, and under pressure from then-mayor of Washington, D.C., Marion Barry, the USPS realigned the postal boundaries between the District of Columbia and Maryland to match the actual boundary. Previously, many inner suburbs, such as Bethesda and Takoma Park, had been in the Washington, D.C., postal area. As a result of the change, ZIP codes in Maryland beginning with 200 were changed to new ZIP codes beginning with 207, 208 or 209, depending on their location, and ZIP codes straddling the D.C.-Maryland line were split. For example, 20014 (Bethesda) became 20814, while the Maryland portion of 20012 (Takoma Park) became 20912.
ZIP Codes are inherently discrete data, or point based data, as they are assigned only at the point of delivery, not the spaces in between the delivery points. The U.S. Census Bureau then interpolates this discrete data set to create polygons, or areal features representing the approximate extent of the ZIP Code to use for mapping and data presentation. ZCTAs are not to be confused with ZIP codes, and they are not updated as frequently as ZIP Codes. However for many research and planning purposes they are very useful, and can be used with ZIP Code data.
This text is licensed under the Creative Commons CC-BY-SA License. This text was originally published on Wikipedia and was developed by the Wikipedia community.
