Required Microsoft Excel freelancer for Spreadsheet Data Entry job

I am creating a Shopify product upload csv file (product_template.csv) and need over 2,000 products to have an additional line added with variant information.

The example of how the variant lines need to look is included in the csv file called 'Variant Example.csv'.

The box quantity, box price and single item price are all included in 'PPU Products.xlsv'.

The steps will be:
1. Remove all of the files from 'product_template.csv' which aren't in 'PPU Products.csv'
2. Add an additional line under all products in edited 'product_template.csv' and format to look like 'Variant Example.csv'
3. Add relevant information from 'PPU Products.xlsv' into 'product_template.csv'

Skills & Expertise Required

Microsoft Excel