Toolvore

CSV Date Converter

Convert selected CSV dates between explicit numeric formats, validate Gregorian dates and keep empty cells and text identifiers intact.

This tool processes its input contents in your browser instead of sending them to a processing service. Page, asset and fixed usage-measurement requests are described on the Privacy page.

Convert selected CSV dates between six declared numeric Gregorian formats, with whole-export validation and text identifiers preserved.

How to use it

  1. 1Paste or open UTF-8 CSV and choose its delimiter; column names appear automatically.
  2. 2Select date columns and explicitly choose their source and output formats.
  3. 3Convert, correct any invalid date, then download the complete CSV and count report.

Example

Input
id,date 001,03/04/2026
Output
id,date 001,2026-04-03

Select date, declare DD/MM/YYYY and choose YYYY-MM-DD. The ID stays 001. The date is interpreted from your choice, never guessed.

What happens to your data

Date parsing and CSV generation happen locally. Reports contain settings/counts without source values, headings or filenames; optional usage measurement excludes your data.

Last updated November 2026

Change the format of selected date columns without letting a spreadsheet guess the day and month. Declare the source format, choose an output format and convert the whole table locally. A DD/MM/YYYY value of 03/04/2026 becomes 2026-04-03, while an ID such as 001 remains text.

How it works

The supported formats are YYYY-MM-DD, YYYYMMDD, DD/MM/YYYY, MM/DD/YYYY, DD-MM-YYYY and MM-DD-YYYY. Every numeric part must have the shown width. Dates use the Gregorian leap-year rules throughout years 0001–9999, including dates before a country's historical Gregorian adoption. This is a format transformation, not a reconstruction of historical calendars.

Only selected columns are interpreted as dates. Exactly empty cells remain empty; spaces, timestamps, month names and two-digit years are not silently trimmed or inferred. Every selected nonempty value must match the declared format and be a real date. For example, 29/02/1900 fails and 29/02/2000 is valid. One invalid date stops the complete export with its CSV record and column number; the source value is not included in the error. A record number counts logical CSV records, so a quoted multiline field does not become extra records.

There is no timezone conversion or automatic regional interpretation. If two selected columns use different source formats, convert them in separate deliberate passes. Selecting the same source/output format still validates dates, with an explicit unchanged outcome when no selected cell changes. Headers, unselected values and row order are preserved.

Use UTF-8 input up to 500 KiB, 10,000 records including the header, 128 columns and 200,000 cells. Choose comma, semicolon or tab explicitly. Headers must be nonempty and unique, and each record must have the same number of fields. Invalid quotes, unequal widths or an excessive complete output stop the job; no partial CSV is presented as a completed result. Output is limited to 2 MiB and retains the row and column counts. It uses UTF-8 without a BOM and CRLF record endings; logical quoted cell values stay intact even when quoting changes.

The page shows the first eight changed cells and a shortened output preview. Copy and download contain the complete result. The separate JSON report includes column indexes, settings and totals without source cell values, headings or filenames. Edits clear previous exports. Formula-like text is counted and preserved, without an automatic apostrophe or replacement. Spreadsheet applications may evaluate it or reinterpret identifiers; review the file and import affected columns as text. Processing stays in this tab, with no source upload or saved input history.

Worked example: Convert a declared day-first date

Input
id,date 001,03/04/2026
Result
id,date 001,2026-04-03

Select date, declare DD/MM/YYYY and choose YYYY-MM-DD. The ID stays 001. The date is interpreted from your choice, never guessed.

Common use cases

  • Prepare an explicitly day-first export for an ISO-date import.
  • Normalize selected date columns while retaining product codes and account IDs.
  • Find invalid calendar dates before passing a table to CSV Schema Validator.
  • Convert compact YYYYMMDD report dates without local timezone changes.

Frequently asked questions

Does 03/04 mean March 4 or April 3?+

You decide by choosing MM/DD/YYYY or DD/MM/YYYY. The converter does not guess from your location or the other rows.

What happens to an invalid date?+

The complete export stops, with the logical CSV record and column number. Correct the source or declare the correct source format, then run again.

Are blanks or spaces treated as dates?+

A cell with no characters remains empty. A space is a nonempty value and fails date validation. Clean spaces deliberately first if that is appropriate for your source.

Can I convert times or Excel serial dates?+

This tool handles the six numeric Gregorian date formats only. Use Timestamp Converter or Excel Date Converter for their supported representations.