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

The time the event begins. If omitted, the event is treated as an all-day event.

Start Time 09:00 AM 14:30

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.

All Day Event

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

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.

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.