Affiliate URLs to Root URLs

I have a list of 7800 affiliate URLs, such as: 1. [login to view URL] 2. [login to view URL] 3. [login to view URL] 4. [login to view URL] When clicked on, these URLs go to the following root URL: 1. [login to view URL] 2. [login to view URL] 3. [login to view URL] 4. [login to view URL] I need someone to pull all 7800 URLs and provide the resulting root URL. I am not expecting anyone to do this manually, so please don't bid assuming the project will take a long number of hours. I am expecting this project to be done in an automated way for $50 or less. I have attached the file to this project.