How to use CSV Date Format Converter
- Paste the CSV or choose a UTF-8 file, check its separator and enter the exact date-column header.
- Choose an explicit input format, English month names, the correct Excel serial date system, or Auto for unambiguous column detection.
- Choose the output format. For invalid dates, either refuse the export or keep the original values with an error report.
- Convert and inspect the converted, blank and invalid counts plus the first 200 changed-cell previews. Download converted-dates.csv and any date-errors.csv before replacing another table.
Example: CSV Date Format Converter
Convert January 5 and February 14, 2026 from ISO dates to day/month/year.
Options
- Pasted CSV
- One unique, nonblank header per column. Quoted commas and line breaks are supported. Each cell may contain up to 2,000 characters.
Supported inputs and limits
- One UTF-8 CSV/TSV source up to 20 MiB, 100,000 rows, 500 columns and 2,000,000 cells, with at most 2,000 characters per cell.
- CSV output is limited to 16 MiB.
- Auto uses column-wide evidence and refuses ambiguous or conflicting month/day order.
- English month names and explicit Excel 1900/1904 serial systems are supported; the fictitious February 29, 1900 is refused.
- Keep-and-report preserves invalid date text with a complete error CSV.
More details
Preview shows up to 200 changed cells.
Other cells stay text, though formula protection can prefix risky values anywhere in exported CSV.
Where your input is processed
This tool does not upload your inputs. See the limits for anything saved on your device.
An ambiguous spelling needs an explicit format
03/04/2026 can mean March 4 or April 3. In Auto, an unambiguous value such as 25/04/2026 can establish day-first order for that supported separator pattern. A column with no decisive evidence, or with conflicting orders, needs correction or an explicit selected format. Check a known date and the preview before using the converted file.
Keep-and-report does not repair invalid dates
An impossible date can either stop export or remain unchanged with an error report. Choosing Keep allows valid rows to convert while preserving invalid source text for review. Other cells remain text, although spreadsheet formula protection can prefix risky values. No time-zone or clock conversion is applied.
Questions about CSV Date Format Converter
Can the tool guess month-first dates?
Auto can use unambiguous dates elsewhere in the column to resolve a supported month/day order. If the evidence remains ambiguous or conflicts, it refuses those dates. Select an explicit format when you know how the source was written.
What happens to an impossible date?
Choose refusal or retain the original value with a report.
Are other columns changed?
Date conversion targets the named column. Export may add formula protection to risky values anywhere in the CSV.