Hi,
Excel VBA would be best solution for you to clean the CSV file. I have handled similar jobs. I can create an excel application using VBA coding, using which you can clean the CSV and get it in the format as you required and then you can upload it to your system.
I am an expert in excel and VBA Programming in Excel. I am interested to work for your project .I have experience working on lot of Excel based projects. I will make sure that I deliver you the best with 100% accuracy in minimum time . Pay me only if you are 100% satisfied with my work, after project delivery. Please see my private message(PM) and sample projects attached with PM for reference.
Regards
Fibin