How to convert CSV to ICS
A CSV is a table with one event per row. An ICS file is the calendar format that Google Calendar, Outlook and Apple Calendar import. To convert csv to ics, every row becomes one BEGIN:VEVENT block with a title, start, end, location and description, and all blocks are wrapped in one calendar.
Your schedule is private. The conversion runs in your browser and nothing is uploaded, as the Privacy Policy explains.
Which column headers are recognised
- Title: Subject, Title, Summary, Event or Name.
- Start: Start Date with an optional Start Time, or one Start column holding a date and a time such as 2026-11-13 15:00.
- End: End Date and End Time, or one End column. An event with no end uses the default length, or a Duration column in minutes.
- Other: All Day Event (Yes, True or 1), Location and Description or Notes.
These are the headers of the layout Google Calendar describes for CSV import, so a file prepared for Google works here too. The Columns panel lists every header and says whether it was used.
Date formats and the day-month problem
A date such as 03/04/2026 is the third of April in much of the world and the fourth of March in the United States. The tool cannot know. With Auto it looks at your whole file: one date like 25/11/2026 proves the file is day first, and 11/25/2026 proves month first. If every date could be read either way it reads month first and tells you in the notes, because a silent guess can move every event by months.
Year-month-day dates, such as 2026-11-25, are never ambiguous, and dates with dots, such as 01.12.2026, are read day first. Times can be 14:30 or 2:30 PM. A row with a date that is not real, such as 31/02/2026, is skipped and listed under Warnings.
A worked example
This CSV has a timed event with a comma in the description and an all-day event:
Subject,Start Date,Start Time,End Date,End Time,All Day Event,Location,Description
Team sync,2026-11-02,09:00,2026-11-02,10:30,,Room 4,"Weekly planning, bring the roadmap"
Product launch,2026-12-03,,2026-12-04,,Yes,Berlin,All handsIt becomes this calendar. The comma is escaped, the all-day event ends the day after its last day as the format requires, and each event has a fixed ID. The DTSTAMP line shows the time of the conversion:
BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//ToolPlank//CSV to ICS//EN
CALSCALE:GREGORIAN
BEGIN:VEVENT
UID:7e12c0375dc983d9@csv-to-ics
DTSTAMP:20261105T070057Z
DTSTART:20261102T090000
DTEND:20261102T103000
SUMMARY:Team sync
LOCATION:Room 4
DESCRIPTION:Weekly planning\, bring the roadmap
END:VEVENT
BEGIN:VEVENT
UID:b07e16ec9989d5be@csv-to-ics
DTSTAMP:20261105T070057Z
DTSTART;VALUE=DATE:20261203
DTEND;VALUE=DATE:20261205
SUMMARY:Product launch
LOCATION:Berlin
DESCRIPTION:All hands
END:VEVENT
END:VCALENDARTime zones: floating, UTC or a named zone
- Floating (empty): the event shows at the same clock time wherever the calendar is opened. This is the simplest choice for events that happen where you are.
- UTC: the times in your CSV are treated as UTC and written with a Z. Calendar apps convert them to the viewer's own zone.
- A name such as Europe/Berlin: the times are written with TZID. The file has no time zone definition block, so an app that does not know the name may show the times as floating.
An invalid zone name is rejected with a message instead of writing a broken file. If an event looks an hour off after import, try Floating or UTC.
Reminders, default length and repeat imports
Enter a number of minutes under Reminder and every event gets a display alarm that many minutes before the start. Events with a start time but no end get the default length, 60 minutes unless you change it, or the value of a Duration column for that row. Events with no start time become all-day events.
Each event's ID is made from its title and times, so importing the same file twice usually updates the events instead of adding copies. Apps differ here, so check the calendar after the first import. To read a calendar back into a spreadsheet, use ICS to CSV. To combine several CSV files first, Merge CSV Files helps, and CSV to VCF does the same job for contacts.
Limits
The tool does not write repeating rules, attendees or online meeting links, and it does not publish a calendar to a URL. For an all-day event, End Date is the last day of the event, and the file gets the day after, as the standard requires. A row with no title and no date is skipped silently, and any other skipped row is listed.