Standardize Excel Dates
Normalize date text using an explicit source format.
Convert text amounts to numeric values in chosen columns without guessing their regional separators.
Loading workspace…
Preparing the controls for this tool. Your files have not been selected or uploaded.Working with many files? Open batch processing for supported operations. Batch uses its own basic options.
Choose XLSX or CSV, then load your worksheets. The first row is a header. Downloads contain values; original formulas and formatting are not preserved.
Your files and inputs are processed in your browser and are not uploaded. Download or copy results before leaving. Normal site and library requests still reach the hosting service.
With comma thousands and dot decimal selected, the text 1,234.50 becomes the number 1234.5. With space thousands and comma decimal, 1 234,50 is parsed using the chosen convention.
Invalid numeric text, malformed grouping and strings exceeding 15 digits of precision remain unchanged and are reported. Converting 00123 to a number removes the leading zeros. Keep account numbers, SKUs and other identifiers as text even when they contain only digits.
No. Values that do not match the supported numeric syntax are skipped. Clean currency labels deliberately before converting.
The guard avoids silently converting long digit strings to imprecise JavaScript numbers. Treat long identifiers as text.
Files and inputs are processed locally in your browser and are not uploaded. The hosting service receives normal website and library requests. Download or copy results before leaving.
Choose XLSX or CSV, then load your worksheets. The first row is a header. Downloads contain values; original formulas and formatting are not preserved.