I just decided to do this. I’ve been meaning to learn more about the vlookup function in Excel. I figured this one would be a semi-useful template for you to use. This is best used on Excel 2010.
The way to use the sheet is just to copy and paste all of the zipcodes in the first column then the rest is magic.
Zip Codes to City State 2019 Leading Zeros (xlsx) – Updated December 2019
Zip Codes to City State (xlsx) – Updated January 2019
Zip Codes to City State with Acceptable Cities (xlsx) – Updated January 2019