← back to tools

Bulk Date Format Converter

Paste a whole column of dates — convert every single one instantly. No formulas, no pain.

Reliability-first build: Auto-detect and text-month formats (e.g. "January 15") have been removed because they cannot parse reliably without ambiguity. Select your exact input format from the list for guaranteed correct output.
Input Format
Tokens: YYYY MM DD HH mm ss (all must be 2-digit padded)
→
Output Format
Tokens: YYYY MM DD HH mm ss (all must be 2-digit padded)
Skip empty lines
Show errors inline
Trim whitespace
Comma-separated (CSV)
Sample Data
ISO → US US → ISO UK → ISO ISO → UK Unix → ISO Excel → ISO ISO datetime → US
Preview →
Input Dates 0 lines
Converted Output 0 lines
📖 Format token reference
TokenMeaningExampleNotes
YYYY4-digit year2024Always use 4-digit years
MM2-digit month (zero-padded)01 – 12Must be padded
DD2-digit day (zero-padded)01 – 31Must be padded
HH24h hours (zero-padded)00 – 2324-hour clock
mmMinutes (zero-padded)00 – 59Lowercase mm
ssSeconds (zero-padded)00 – 59Optional