This is a smart Data cleaning tool for MS Excel files. Purpose of this automation tool is to assist users in carrying out data cleaning tasks in MS excel files in time efficient manner. Tool is very adept at data cleaning tasks and is equipped with different Text cleaner, Duplicate remover and Data organizer options to carryout Data cleaning tasks like Removing and replacing characters, Removing empty rows, columns and worksheets, Removing excessive spaces, Removing duplicate entries, changing to upper or lower case, changing to proper case etc. in excel files efficiently. Tool provides distinct commands to carryout these operations. User can seamlessly Remove user defined characters, alphabets, numbers, extra spaces, upper case, lower case, empty rows, columns and sheets etc. using this tool. Apart from data cleaning options this tool also provides counting feature that lets the user to count number of cells, active sheets, worksheets, duplicate rows, unique rows etc. This Excel Data cleaner minimizes manual intervention to make data cleaning tasks fast and accurate.
Widespread use of MS excel to store, organize and process data necessitates use of excel addins. Excel Data Cleaner is one such excel addin. If user needs to remove duplicate from excel files then this excel utility software can be very useful. Apart from removing duplicates users can effortlessly remove alphabetic or numeric characters, extra spaces, upper or lower case characters and carryout many other similar operations using this data remover tool. Tool has been provided with many useful commands that include Empty rows remover command, space remover command, Case changing command, Empty worksheet remover command, Cell counting command, Worksheet counting command etc. Software provides high processing speed and is compatible with different windows operating systems like Windows XP/Vista/2007/2008 etc.