will importing excel data that contains zipciode data within coulumn a and counts of clients within zipcode in column b show up well on map?

It could do. You could plot shaded zipcode areas - so the shade of color represents the number of clients.
Or another good way might be to plot sized circles on each zipcode.

You may wish to experiment with the colors used to improve clarity.

Richard