Skip to content
ToolPlankDEV
Text Tools
100% In-Browser Execution

Updated:

CSV to ICS Converter

Paste a CSV of events and get a calendar file as you type. This csv to ics converter finds the title, date and time columns by itself, reads day-first or month-first dates, writes time zones and reminders, and flags every row it cannot use. Nothing is uploaded.

Options:

CSV

Input
0 chars · 0 lines

ICS calendar

Ready
Processing in browser...
0 chars · 0 linesUpdates as you type

Columns and events

Which columns were used, the first events and any rows that need attention appear here.

Processed on your device. Your text is not sent to our servers.

More free tools you may need next.

Quick Guide

How to use CSV to ICS

Simple step-by-step instructions to get the exact output you need.

  1. 01

    Paste or open your events CSV

    Paste the CSV into the left box, press Paste, or open a .csv file. The first row must be a header row with at least a title and a start date. Example loads three events, and Google Calendar import layout, Day-first dates and One column per time load other layouts.

  2. 02

    Check the columns, events and warnings

    The panel under the result shows which column was used for what, the first events as they will be saved, and a warning for every row with a date or time the tool could not read.

  3. 03

    Set date order, time zone, length and reminder

    Keep Auto for the date order unless the notes say a date was ambiguous. Leave the time zone empty for floating times or enter a name such as Europe/Berlin. Set the default length for events with no end time and an optional reminder.

  4. 04

    Download the ICS file and import it

    Press Download to save calendar.ics, then import it into Google Calendar, Outlook or Apple Calendar. Press Copy to use the text elsewhere.

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:

csv
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 hands

It 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:

Text
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:VCALENDAR

Time 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.

Frequently Asked Questions

Technical Q&A for CSV to ICS

Common questions about edge cases, character encoding, and privacy guarantees.

Paste the CSV with its header row into the left box and the calendar appears on the right. Press Download to save calendar.ics.

In Google Calendar open Settings, then Import and export, choose the .ics file and pick the calendar to add it to.

Open the .ics file, or use File, Open and Export, Import/Export in Outlook and choose the iCalendar file. The events are added to your calendar.

Save the sheet as CSV UTF-8 from Excel, with a header row, and paste or open that file here.

Subject, Title or Summary for the title, Start Date and Start Time for the start, End Date and End Time for the end, All Day Event, Location and Description. The Columns panel shows what was used.

A date like 03/04/2026 can be day first or month first. Choose the date order if the notes say a date was ambiguous. Year-month-day dates are never ambiguous.

Leave it empty for floating times, type UTC, or type a name such as Europe/Berlin. A name that is not a real time zone is rejected.

Yes. Enter the minutes before the start under Reminder and every event gets a display alarm.

No. The conversion runs in your browser and nothing is sent to a server.