CSV Format Reference

Complete documentation of all supported columns in the CSV-to-iCal converter.

Column Names

Column headers are case-insensitive and leading/trailing whitespace is ignored. Both Start Date and start date are accepted.

Required Columns

Subject

The event title displayed in the calendar.

Subject Team standup Doctor appointment

Start Date

The date on which the event begins. See Supported Date Formats below.

Optional Columns

Start Time, End Date, End Time

  • Start Time: The time the event begins. Optional. If omitted, the event is treated as an all-day event.
  • End Date: The date on which the event ends. Defaults to the same value as Start Date if omitted.
  • End Time: The time the event ends. If provided, Start Time must also be present.
Subject Start Date Start Time End Date End Time
New Year’s Eve 2026-12-31 6:00pm 2027-01-01 3:00am
Valentine’s Day Party 2026-02-14
Labor Day 2026-05-01

All Day Event

Set to True or Yes to mark an event as all-day regardless of whether time columns are present.

Subject Start Date All Day
New Year’s Eve 2026-12-31 false
Valentine’s Day Party 2026-02-14 true
Labor Day 2026-05-01 true

Availability

Set to Free or Busy to show whether you can be available for other events at that time, or not.

  • Free tells others that you are available for overlapping event appointments.
  • Busy indicates that your time has been blocked off.

Note that some Calendar apps, notably Apple Calendar, do not support free/busy information.

Subject Start Date Availability All Day
New Year’s Eve 2026-12-31 busy false
Valentine’s Day Party 2026-02-14 free true
Labor Day 2026-05-01 true

Location

The physical address or virtual meeting link for the event.

Location 123 Main Street, Any City, CA 90000

or

https://meet.example.com/room/abc

Description

Free-text notes appended to the event body. Newlines within a quoted CSV field are preserved.

Private

Set to True or Yes to mark the event as private/confidential in supported calendar apps.

Full Example

Subject Start Date Start Time End Date End Time Availability All Day Description Location
New Year’s Eve 2026-12-31 6:00pm 2027-01-01 3:00am busy false Longer Description San Francisco CA
Valentine’s Day Party 2026-02-14 free true Missing Times are OK New York NY
Labor Day 2026-05-01 true

Supported Date Formats

Format Example
YYYY-MM-DD 2026-03-14
MM/DD/YYYY 03/14/2026
DD-MM-YYYY 14-03-2026
DD/MM/YYYY 14/03/2026

Supported Time Formats

Format Example
24-hour HH:mm 14:30
24-hour HH:mm:ss 14:30:00
12-hour hh:mm AM/PM 2:30 PM

Delimiters

The delimiter is auto-detected from the first line of the file. Supported delimiters:

Name Character
Comma ,
Semicolon ;
Tab \t
Pipe |

Encoding

UTF-8 is recommended. Files with a UTF-8 BOM are also accepted.