Murder Mansion

Hi! I have been asked to create a map of the United States and drop pins on all of our clients. Infographic style. Here is a very rough proof of concept I did in After Effects in 5 minutes:


The problem is, we have thousands of clients. Even if I only picked a couple of hundred, this is going to be a mess to do manually.

Have you encountered any software (or widget) that I could upload coordinate data to that might be able to pull this off?

Thanks!
Landing page video