How to Open a Zip File in Excel 2007. A ZIP file usually contains several other files that have been compressed to a smaller size and bundled into a single package with a .zip filename extension.

You could enter everything but the city and state in excel, then import it all into access and run a query against a zip code/city/state database (which you'd have to buy, they can be had for ...