Online Date Decomposer (Year, Month, Day, Weekday, ISO Week)

Drop a CSV with a date column to automatically extract year, month, day, day of week, and ISO week number.

Before
Date
2024-01-15
2024-03-08
2024-07-21
2024-12-25
2025-02-03
After
Dateyearmonthdayday_of_weekiso_week
2024-01-152024115Monday3
2024-03-08202438Friday10
2024-07-212024721Sunday29
2024-12-2520241225Wednesday52
2025-02-03202523Monday6

Drag & drop CSV files here, or browse files

.csv format (up to 10 files, 500 MB each)

Required Columns

Date

Your data stays in your browser. By using this tool, you agree to our Terms and Privacy Policy.

How to Use This Template

Select Your File

Drag & drop a CSV file containing the required columns

Automatic Processing

Data is transformed and aggregated based on the template

View Results

Explore the aggregated results interactively on the Analyze page

Processing Details of This Template

  1. 1Extract from Date via regex → column "year"
  2. 2Extract from Date via regex → column "month"
  3. 3Extract from Date via regex → column "day"
  4. 4Extract from Date via regex → column "day_of_week"
  5. 5Extract from Date via regex → column "iso_week"