add zip codes to numbers spreadsheet

One way would be to download a list of all 43000 (rounded) five digit ZIP codes currently in use by the USPS in a form you can then place into a Numbers table. Suitable file types include .csv and MS Excel (.xlsx). here are several sites on the net offering these lists. Most, if not all, will likely have a charge for this service.

extracting the codes for a specific State and City should then be a simple lookup task. Getting the last two digits of the code may be a little more difficult, as these vary by street address.

It may be possible to devise a script or other tool to search for and return ZIP codes for specific addresses directly from a list on the internet and place them in specific locations in a Numbers document, but that's beyond my ken.

Unless you are dealing with an extremely large list of addresses and are facing frequent changes in that list, you may find it simpler to use the USPS ZIP lookup tool. Practically, it's a one-time task for each address, barring a mass reorganization of the ZIP assignments. Once found, the 5 + 4 extended code is likely to remain stable for several years.

Regards,

Barry

Numbers doesn't have this functionality. You might try one of the approaches described here.

SG