upload locations with excel file

I would like to know if I can upload an excel file with multiple locations. I have about 500 locations nationwide we would ship to. How does the customer choose a pickup location? can it be through zip code to choose the nearby location?