One thing you might want to keep in mind is that if you spend some time trying to find a solution to do this easier, it might have taken more time than if you actually manually typed the addresses in. Of course I am saying that because we have a data entry department, and I personally wouldn't have to manually enter them.