Extract Date Parts
Pull year, month, day, and more from date columns
CSV Input
Try a sample:
Drop a CSV file here or
Only the first file is used if multiple are dropped.
The request is made directly from your browser. No proxy is used.
Options
Provide CSV input above to select a column.
CSV Output
Select a date column to append year/month/day columns...
More Options
CSV Format
Input
How to Use This Tool
This tool reads a date column and appends three new columns to your CSV: <column>_year, <column>_month, and <column>_day. Values are integers, matching Excel’s YEAR(), MONTH(), and DAY() functions. Useful for grouping records by year or month, building pivot tables, or feeding date-aware analyses.
- Provide your CSV — Paste CSV text into the input area, drop a CSV file onto the File tab, or enter a URL on the URL tab.
- Pick the date column — The tool auto-detects the format. If detection is ambiguous (some formats fit both MM/DD and DD/MM), confirm or change the format below.
- Download — Copy the result or save it as a
.csv. The output preserves all original columns and appends the three new ones at the end.
FAQ
3 questionsDoes this tool upload my data?
No. Date parsing runs entirely in your browser. Your CSV data is never sent to a server.
Which date formats are supported?
Five formats: YYYY-MM-DD, MM/DD/YYYY, DD/MM/YYYY, MM-DD-YYYY, and DD-MM-YYYY. Two-digit years are expanded with a 50-year window — 00–49 become 2000s, 50–99 become 1900s. The tool auto-detects the format on the column you pick, and you can override the detection if it's wrong or ambiguous.
What happens to rows that can't be parsed?
Empty cells produce empty year/month/day cells. Rows with values that don't match the selected format also produce empty cells, and a warning shows how many rows could not be parsed so you can review them before downloading.