Leading zeros stay
Phone numbers, staff IDs and account numbers stay as text, so 0123 never turns into 123 and a long account number never turns into 1.2E+12.
Stray spaces, blank rows, the same claim entered twice, dates in five formats and “RM 1,250.00” stuck as text. Drop the file in, choose what to fix, and get a clean sheet with a log of every change.
Runs in your browser. Your file is never uploaded.
Three rules keep the values that matter exactly as they were.
Phone numbers, staff IDs and account numbers stay as text, so 0123 never turns into 123 and a long account number never turns into 1.2E+12.
Tell it how your team writes dates. A date that cannot exist, like month 31, is left alone instead of guessed.
03/04/2026 → 2026-04-03The download comes with a Change Log sheet listing the row, the column, the old value and the new one, ready for a reviewer.