About csvDates

Drop a CSV and each date column is read the way it was written: day/month or month/day proven by values like 15/04 or by a weekday that only fits one reading, never guessed, so a column where every value reads both ways asks you which it is (with a hint when the rows are in date order only one way). Excel serial numbers (1900 and 1904 systems, without Lotus's 29 February 1900), Unix seconds and milliseconds, two-digit years with Excel's or PostgreSQL's cut-off, times, AM/PM and offsets are handled. Download the file with YYYY-MM-DD dates, in place or as new columns, and a list of every value it couldn't decide. Runs in your browser.

Runs entirely in your browser: your SQL and files are not uploaded. Signed-in members can keep a history of runs and results.

Built on open-source libraries: Papa Parse, ExcelJS.