Month: August 2019

Project Title: Google Sheet and CSV File Clean up Service Project Description: I have a database in CSV format that I’d like to prepare for import into my CRM. In order to do this, I need to have the data cleaned up so that: – The names of leads are split properly (i.e. ‘Name’ becomes, say, ‘First Name’, ‘Middle Name’ and ‘Last Name’). – The…

Project Title: Verifying and Validating Email List Project Description: We have an long Email list over 2 million emails we need a company that can close this case for us. Please do a check of the list and clean up the whole list. With bounce rate and if it is not working so delete from the list. We need to be sure that any wrong…

Project Title: Checking Clean and Corrupt Files Project Description: I have a requirement to check files are clean and those which have to been corrupted (.xls, .xlsx, .doc, .docx files). A simple workflow that looks for files on the source folder, validates them by opening and closing. Successful Open and Close will be moved to ‘Checked’ folder, corrupt ones i.e. ones that cannot be opened,…

Project Title: Data-set Appending and Cleaning Project Description: I have two data sets, 1. A list of suburbs with other information 2. Suburbs with corresponding postcodes. I need to match the suburbs (suburbs sheet) with postcodes on another sheet (postcode list). Both are contained in the attached excel work book. Some of the names will not be a perfect match as there might be a…

Project Title: Excel Data De-duplication, Merging and Cleaning Project Description: I have 120 Excel documents with customer contact information I would like merged into one master document. Each document has around twelve columns and a combined total of around 1M rows. There are many duplicate entries within these documents in which I need to match all the duplicates up and complete the entry with as…