I need products adding to a spreadsheet in correct format ready for upload to website

Existing Website - [login to view URL] My client would like to upload a new selection of products to his website, we will upload this by importing a correctly formatted CSV file with all of the products on. Just to make this clear I am looking for help with creating the CSV file, not the upload. The products that are being uploaded are all of the products from a new supplier - Draper Tools - [login to view URL] . They provide us with a read-only FTP link into their server where we can download all of the information, images, videos, pricing info, product database in various formats and we need all of the information taking from their provided info and adding correctly into the format needed so that we can upload onto my client website. All of the images are correctly named and follow a single naming convention so this should be very easy to do, anyone with moderate excel/CSV skills and a basic understanding of how these type of upload sheets work will recognise that this is a simple, quick task for the right person. Please price sensibly, I'm not after anything complex! i have attached two files, file 1 new client format = this is the client's format, everything above the yellow line is what an export looks like from their server file 2 [login to view URL] = this is the draper file that we have been working on, the columns in green we have a match for but the columns in red we don't, this is either because it's not needed for the new format or because the data need manipulating into a suitable format. for example, we need data for the size column in the new format which is in with the description in the draper format, so we need the size pulling from the description where it's available Also, i should just add that we are actively looking for a virtual team of people for repeat constant business in all fields.