Zip
Area
City
State
01001
ATLANTIC
AGAWAM
MA
01002
ATLANTIC
AMHERST
MA
01002
ATLANTIC
AMHERST
MA
01002
ATLANTIC
AMHERST
MA
01005
ATLANTIC
BARRE
MA
01007
ATLANTIC
BELCHERTOWN
MA
01008
ATLANTIC
BLANDFORD
MA
01009
ATLANTIC
BONDSVILLE
MA
01010
ATLANTIC
BRIMFIELD
MA
01011
ATLANTIC
CHESTER
MA
01050
ATLANTIC
HUNTINGTON
MA
01012
ATLANTIC
CHESTERFIELD
MA
01020
ATLANTIC
CHICOPEE
MA
01013
ATLANTIC
CHICOPEE
MA
01020
ATLANTIC
CHICOPEE
MA
01020
ATLANTIC
CHICOPEE
MA
01020
ATLANTIC
CHICOPEE
MA
01026
ATLANTIC
CUMMINGTON
MA
01027
ATLANTIC
EASTHAMPTON
MA
01028
ATLANTIC
EAST LONGMEADOW
MA
01029
ATLANTIC
EAST OTIS
MA
01001
ATLANTIC
AGAWAM
MA
01030
ATLANTIC
FEEDING HILLS
MA
01031
ATLANTIC
GILBERTVILLE
MA
01032
ATLANTIC
GOSHEN
MA
01033
ATLANTIC
GRANBY
MA
01101
ATLANTIC
SPRINGFIELD
MA
01034
ATLANTIC
GRANVILLE
MA
01002
ATLANTIC
AMHERST
MA
01035
ATLANTIC
HADLEY
MA
01036
ATLANTIC
HAMPDEN
MA
01037
ATLANTIC
HARDWICK
MA
01038
ATLANTIC
HATFIELD
MA
01039
ATLANTIC
HAYDENVILLE
MA
01096
ATLANTIC
WILLIAMSBURG
MA
01040
ATLANTIC
HOLYOKE
MA
01040
ATLANTIC
HOLYOKE
MA
01040
ATLANTIC
HOLYOKE
MA
01050
ATLANTIC
HUNTINGTON
MA
01053
ATLANTIC
LEEDS
MA
01054
ATLANTIC
LEVERETT
MA
01056
ATLANTIC
LUDLOW
MA
01095
ATLANTIC
WILBRAHAM
MA
01057
ATLANTIC
MONSON
MA
01059
ATLANTIC
NORTH AMHERST
MA
01060
ATLANTIC
NORTHAMPTON
MA
01060
ATLANTIC
NORTHAMPTON
MA
01027
ATLANTIC
EASTHAMPTON
MA
01062
ATLANTIC
FLORENCE
MA
01066
ATLANTIC
NORTH HATFIELD
MA
01068
ATLANTIC
OAKHAM
MA
01069
ATLANTIC
PALMER
MA
01026
ATLANTIC
CUMMINGTON
MA
01070
ATLANTIC
PLAINFIELD
MA
01071
ATLANTIC
RUSSELL
MA
01002
ATLANTIC
AMHERST
MA
01072
ATLANTIC
SHUTESBURY
MA
01073
ATLANTIC
SOUTHAMPTON
MA
01074
ATLANTIC
SOUTH BARRE
MA
01075
ATLANTIC
SOUTH HADLEY
MA
01077
ATLANTIC
SOUTHWICK
MA
01079
ATLANTIC
THORNDIKE
MA
01069
ATLANTIC
PALMER
MA
01080
ATLANTIC
THREE RIVERS
MA
01081
ATLANTIC
WALES
MA
01082
ATLANTIC
WARE
MA
01083
ATLANTIC
WARREN
MA
01083
ATLANTIC
WARREN
MA
01012
ATLANTIC
CHESTERFIELD
MA
01085
ATLANTIC
WESTFIELD
MA
01085
ATLANTIC
WESTFIELD
MA
01001
ATLANTIC
AGAWAM
MA
01089
ATLANTIC
WEST SPRINGFIELD
MA
01092
ATLANTIC
WEST WARREN
MA
01093
ATLANTIC
WHATELY
MA
01094
ATLANTIC
WHEELWRIGHT
MA
01095
ATLANTIC
WILBRAHAM
MA
01096
ATLANTIC
WILLIAMSBURG
MA
01098
ATLANTIC
WORTHINGTON
MA
01101
ATLANTIC
SPRINGFIELD
MA
01101
ATLANTIC
SPRINGFIELD
MA
01103
ATLANTIC
SPRINGFIELD
MA
01101
ATLANTIC
SPRINGFIELD
MA
01101
ATLANTIC
SPRINGFIELD
MA
01101
ATLANTIC
SPRINGFIELD
MA
01028
ATLANTIC
EAST LONGMEADOW
MA
01107
ATLANTIC
SPRINGFIELD
MA
01101
ATLANTIC
SPRINGFIELD
MA
01108
ATLANTIC
SPRINGFIELD
MA
01101
ATLANTIC
SPRINGFIELD
MA
01115
ATLANTIC
SPRINGFIELD
MA
01106
ATLANTIC
LONGMEADOW
MA
01028
ATLANTIC
EAST LONGMEADOW
MA
01101
ATLANTIC
SPRINGFIELD
MA
01028
ATLANTIC
EAST LONGMEADOW
MA
01101
ATLANTIC
SPRINGFIELD
MA
01108
ATLANTIC
SPRINGFIELD
MA
01109
ATLANTIC
SPRINGFIELD
MA
01151
ATLANTIC
INDIAN ORCHARD
MA
The data used for this is a small sample of 100 records extracted from a much larger file of 44k records supplied by Mark Hersum.
The key to getting this to work was to edit the exported csv file from Excel which I found to contain apostrophes so I editted the csv file in text edit and then used 'Find and Replace' to find apostrophes and replace them with nulls. Otherwise all the data was being bunched up in one column.