Employee Data Cleaner
Trailing spaces, shouted names, dates in three formats, salaries with currency symbols and the word N/A pretending to be data.
Reads .xlsx and .csv, entirely inside your browser. Your file never leaves your computer.
The spreadsheet
Drop a spreadsheet here
An employee roster, an export, anything with a header row.
What it will not do
It will not touch a name that is already mixed case. DeAngelo, McDonald and van der Berg were capitalized by a person, and a title-caser that overrules them destroys real information. Only values that are entirely shouted or entirely lower case are changed.
It will not turn an employee number into a number. Employee 00123 becomes 123, and then stops matching the same person in every other system. Identifier columns are left as text even when they look numeric.
It will not guess a date order. If a column contains 13/05 somewhere, the file has proved it is day first and the whole column can be read safely. If every value is 12 or under, nothing proves anything and it asks you.
It will not invent a value it could not read. Anything an operation cannot handle is left exactly as it was, counted, and shown to you.