Data & CSV

Extract CSV date parts

Add calendar fields from a strict ISO date column.

Extract CSV date parts
Esc to restore

Your inputs

UTF-8 CSV/TSV stays on this device. First row contains unique headings; maximum 25 MB, 50,000 rows and 200 columns. Fully empty rows are ignored.

Up to 25 MB per file, 50,000 data rows, 200 columns and 2 million data cells. Fully blank rows and columns are ignored before row, column and cell limits are checked. Individual tools may have smaller result or chart limits.

Results update as you type. Larger files run when you press Update result.

Processed on your device

Your result

LOCAL & PRIVATE

Your result will appear here.

Your inputs stay in this browser. Nothing is uploaded or saved.

A clear answer. Here’s how.

Parses non-blank dates strictly as Gregorian YYYY-MM-DD in years 0001–9999, rejecting rollover dates. Adds year, month, day, English weekday, day of year and ISO week year/week (seven fields). Blank dates yield blank parts. Calendar arithmetic uses UTC so the device time zone does not shift dates; generated headings must be unique.

See a worked example

Worked example

A fixed demonstration, separate from the values you enter above.

Your CSV data
ID,Name,Department,Amount,Date
001,Ada,Design,120,2026-01-05
002,Sam,Writing,80,2026-01-06
003,Jo,Design,150,2026-01-07
004,Lee,Writing,,2026-01-08
005,Alex,Design,60,2026-01-09
Column separator
Comma
Date column (YYYY-MM-DD)
Date

Example result

Example result
IDNameDepartmentAmountDateDate.yearDate.monthDate.dayDate.weekdayDate.dayOfYearDate.isoWeekYearDate.isoWeek
001AdaDesign1202026-01-052,02615Monday52,0262
002SamWriting802026-01-062,02616Tuesday62,0262
003JoDesign1502026-01-072,02617Wednesday72,0262
004LeeWriting2026-01-082,02618Thursday82,0262
005AlexDesign602026-01-092,02619Friday92,0262

Keep going.

CSV dataset diffCSV rule validatorCSV calculated columnCSV rank and percentile