How to Create Maps in Excel 2007. There are several ways to create maps in Microsoft Excel 2007. ... Drag the mouse across the data you want to use for the map, including the column of ZIP Codes.

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 ...