If you have a field containing address information, you can set up a simple function in Google Sheets to be able to populate a separate column with ZIP code data.
Google Sheets
GIS Software
How To Make a Map From Open Data Using a Spreadsheet
Jonathan Goldman explains in this tutorial how to extract an open data feed from a civic data portal and pull it into Google Sheets, and then map it quickly using Geosheets.