ToolJovia
Data

CSV Calendar Range Expander

Expand declared date-only source records into calendar-day rows with original columns and explicit source-record provenance.

✓ Browser-local processing
Processed in this tab. Up to 100,000 characters unless this tool states a smaller limit.

Loading tool…

How to use CSV Calendar Range Expander

Prepare daily records from local interval data without guessing date formats or time zones. Each row keeps the original source values, the chosen endpoint convention is visible, and invalid or empty ranges never become invented observations.

  1. Enter input, start date column, end date column, new date column.
  2. Choose the settings for csv calendar range expander, then run the tool.
  3. Review the result and any limitations before copying or downloading it.

Good to know

  • Strict YYYY-MM-DD Gregorian years 1–9999; 366 emitted days per source record, 5,000 expanded rows and 350,000 output cell characters checked before allocating expanded rows.
  • Original CSV strings repeat with formula-prefix protection. report-skip explicitly omits invalid source records; zero-length exclude-end ranges produce no data row. This does not infer missing data, recurrence, occupancy rules, business days or a time zone.
  • Processing is local. Output is limited to 1,000,000 text characters unless a stricter file limit is stated.

Common questions

Does the end date produce a row?

Only include-end emits that date. exclude-end stops before it and makes an equal-start/end range empty. Invalid and overlong ranges follow the explicit refusal or report-skip policy.

Is this input sent to a server?

No. The application processes this input inside your browser tab and does not save it to persistent storage.

Keep going with related tools

All data →
Data

CSV Numeric Event Sessionizer

Annotate ordered events with per-group sessions using an exact numeric inactivity threshold.

Date & time

Recurring Calendar Date Generator

Generate bounded daily, weekly, monthly, or yearly dates while skipping nonexistent calendar dates.

Data

CSV Nonoverlapping Interval Lookup

Attach an observed interval record to each numeric point under an explicit endpoint closure policy.

Date & time

All-day Calendar Recurrence Evidence

Expand an explicitly supported all-day iCalendar recurrence subset and trace included or excluded dates inside a bounded start-date window.