Blog

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…

Project Title: Data Organizing and Processing Service Project Description: We’re looking for a data processing specialist to transfer Data from Excel files to Database CRM. We want a long term relation, someone to help the Customer Success Team. Deliverable: – Transfer customer data from Excel Files into Customer Database CRM – Compile and organize customer data into one standardize CSV File ready for CRM Importation…

Project Title: Cleaning Client Contacts Database Project Description: I am looking for assistance with cleaning a database of around 600 client contacts. I need assistance with checking details for accuracy and then working to source accurate contact details (email and telephone number) where possible. The list consist of clients who have bought a financial services product from my client in recent years. Some contact may…

Project Title: Contact List Cleansing & Formatting Project Description: I have a CSV containing 2130 contacts. We need to cleanse and format these contacts so they are ready to use in our upcoming marketing campaign. This means: 1. Removing contacts with irrelevant titles or from irrelevant companies. 2. Ensuring names are appropriately formatted. 3. Ensuring company names are “conversational” (i.e. updated so they look natural…