I have excel files (CSV format) which have lot of data in it ....it is generally in column A of the file...say for example approx 5 lakh records..
I fisrt need to clean this data file
need these 5 lakh records but replace and find certain characters and then remove duplicates and then sort them. Finally I need split in to multiple excel files of 50,000 records depending on the requirement and save each file as CSV with the file name as "Original file name - 1", "Original file name - 2"
Original file has 2 lakh emails. File name is [url removed, login to view]
I split this into 4 files of 50000 each and each of the 4 file is called 567 - [url removed, login to view], 567 - [url removed, login to view], 567 - [url removed, login to view] and 567 - [url removed, login to view]
Budget is $30 for this simple task....
DO NOT BID IF YOUR BUDGET IS MORE THAN $30
13 freelancers are bidding on average $6/hour for this job
Excel and VBA expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check my portfolio for: [url removed, login to view] Estate (video demonstration) [url removed, login to view] (video demonstrat Flere
Hello. Would you provide sourcr CSV files and/or let me know how many files/entries there. I can provide you sample work, even ready work based on provided data. Best regards
Having more than 6 years experience in Website management, Data entry, Data processing, Image Processing, Conversions PDF,TXT,WORD,EXCEL,JPEG Completed around 60 projects in above sectors.