How to resolve uk vs us date format conflicts in excel spreadsheets
- Step 1Export your CRM data — Download the Excel export containing mixed regional date formats from your CRM.
- Step 2Upload and run the standardizer — The tool detects and converts all parseable dates. Ambiguous dates are flagged in the findings report.
- Step 3Review and download — Check the findings report for flagged cells, correct if needed, and download the ISO 8601 output.
Frequently asked questions
How does the tool decide if a date is UK or US format?+
chrono-node uses contextual clues. When a day value exceeds 12 the format is unambiguous. When both values are 12 or below the tool flags the cell for manual review.
Can I force all dates to be treated as UK format?+
A locale preference option is on the roadmap. Currently the parser uses the most statistically likely interpretation.
Does it fix Excel serial-number dates too?+
Yes. SheetJS decodes Excel serial numbers to JavaScript Date objects before reformatting to ISO 8601.
Privacy first
Every JAD Excel tool runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets, formulas, and data never leave your device — verified by zero outbound network requests during processing.