CSV Files Editing and Data Separation

I have 10 .csv files that need editing and reformatting. The requirements are as follows: - Remove duplicates from the data - Split full names into First Name and Last Name - Split City/State into separate columns - City and State - Carefully isolate zip codes from the data. It's important not to overlook zip codes that start with zero - Change the headings to match the following format: fn, ln, ct, st, zip, phone email, .csv UTF-8 (Comma delimited) The successful freelancer should be proficient in Microsoft Excel as the work will be done in it. I'm looking for a professional who can work effectively and efficiently with a spreadsheet. Your application should highlight your experience with similar tasks and your ability to handle data manipulation in spreadsheets. I look forward to reviewing your application.