Hi, i m serious freelancer with 100% completion rate and i believe i can help you. I can create you a simple program (macro in Excel) that will let you choose a CSV file (like in your example) and it will output another CSV file with an extra column (hotel name + zip code). If you are interested message me and i will try to help you. As i said i m serious freelancer and i've never took a single dollar unless my solution was perfect.
Edit: Please take a look at my profile and you will see that i've done more than 200 excel projects, with 100% completion rate.
Thanks, Milan