CSV to ICS: Spreadsheet to Calendar File
Convert CSV or Excel rows to an .ics calendar file for Google Calendar, Outlook or Apple Calendar: columns matched for you, dates checked, time zone, reminders and repeats. Free, no upload.
Loading only the code needed for this tool…
PDF organization
Organize pages before you publish or share
Use the page controls to put the document in the order you actually need. For multi-file operations, confirm every source is included before creating the final PDF.
Input
.csv, .tsv, .txt, .xlsx
Output
ICS
Batch
1 file per run
1 file per run. Only use one run when files share the same operation.
Move into a related operation instead of re-finding the tool.
Download a destination-ready result and verify it before sharing.
20 MB max.
Natural next steps
Continue with a related tool using the same file workflow.
CSV, TSV, TXT, XLSX
ICS
Process one source at a time
Review the result before sharing
Smart workflows
Finish the job, not just the file
Use the existing tool graph to continue into useful next steps. Bulk and output-packaging capabilities are surfaced automatically where the underlying tool supports them.
Continue with Ics To Pdf
Bulk-readyFinish the job after Csv To Ics with a relevant MAXScanner tool, without creating a duplicate converter page.
- Csv To Ics
- Ics To PdfBulk processing · ZIP-ready output · Workflow-ready
Best when Csv To Ics is only the first step in your workflow.
Continue with Calendar Maker
Finish the job after Csv To Ics with a relevant MAXScanner tool, without creating a duplicate converter page.
- Csv To Ics
- Calendar MakerWorkflow-ready
Best when Csv To Ics is only the first step in your workflow.
About This Tool
Choose a CSV or Excel file (or paste rows), check that each column has the right meaning, confirm how the dates are written, and download the .ics file. One file imports into Google Calendar, Outlook and Apple Calendar alike, with your time zone, reminders and repeating events. Rows that cannot become events are listed with the reason, so nothing disappears quietly. The spreadsheet is read by your browser and never uploaded.
What a sheet needs
Two columns are enough: a title and a start date. Everything else is optional and recognised from its column name in the 13 languages of this site, including the layouts of Outlook's CSV export and Google Calendar's CSV import:
| Column | Examples of what it can hold |
|---|---|
| Start date (or date and time) | 2027-03-06, 06/03/2027, 6 Mar 2027, 2027年3月6日, an Excel date cell |
| Start time, end time | 09:30, 9:30 AM, 14h30, 午後2時30分; an end before the start below 16 hours ends the next morning |
| End date, or duration | a last day (multi-day events), or 90, 1:30, 1.5 h, 2 days |
| All day | yes/no, TRUE/FALSE; rows without a time are all-day anyway |
| Location, description, category | any text; a category can split the output into one calendar file each |
| Reminder | minutes before (15), or 1 h, 1 day |
| Repeat | daily, weekly, monthly, yearly, or a rule such as FREQ=WEEKLY;BYDAY=MO,WE;COUNT=10 |
Worked example: a club season
The page's sample sheet (“Try a sample sheet”) has 5 rows: a Saturday training that repeats weekly 10 times, two matches, an all-day tournament and a parents' meeting, with dates such as 13/03/2027 and a Reminder column of 60, 120 and 1440 minutes. The tool read the dates as day/month/year, because 13/03 only works that way, and wrote a 2,117-byte .ics with 5 events in the Europe/London zone. Read back, the file gives 14 calendar entries from 6 March to 8 May 2027, the timed ones with their reminders, and the training stays at 09:30 after the clocks change on 28 March.
The 03/04 trap, and other checks
A date such as 03/04/2027 is 3 April in most of the world and 4 March in the United States. The page reads the whole sheet with one order: a day above 12 anywhere settles it, otherwise the order that keeps the rows in date sequence, otherwise the habit of your device's language, and it tells you which rule decided. When both readings are possible the notice is highlighted; switch the order and check the preview before you download. Other checks: a missing title or date, an unreadable time, an end before the start. Each skipped row is listed by its row number.
How the file is written
Times carry the zone you choose (for example Europe/London) with its daylight-saving rules inside the file, the form RFC 5545 requires and Outlook writes itself. All-day events are written as dates, so they never shift by a day in another zone. Each row gets an ID made from its title and start, so the same row always produces the same ID and a calendar app can recognise an event it already has.
When this is not the right tool
- Old .xls workbooks are not read; save them as .xlsx or CSV first. Only the first sheet of an .xlsx is used.
- Attendees and meeting invitations are not created; the file adds events to your own calendar.
- A sheet of up to 10,000 rows is converted; split larger ones.
- To check or print the result, send it to ICS to PDF with the button under the preview.
How to Use
Add the spreadsheet
Choose a CSV, TSV or .xlsx file, or paste rows copied from Excel or Google Sheets.
Check the columns
Each column is matched from its name; change any that are wrong and mark extra columns as a notes line if you want them in the description.
Confirm dates and time zone
Check the day/month order the page detected, the time zone, the length of events without an end, and a reminder for every event.
Download the .ics
Check the preview and the skipped rows, then download one .ics (or one per category in a ZIP) and import it into your calendar app.
Use Cases
Exam timetables and course schedules
A table of dates, times and rooms becomes calendar events with a reminder the day before.
Club seasons and fixture lists
Training that repeats weekly, matches and tournaments in one file, one calendar per team if you want.
Moving events between apps
An Outlook CSV export or a planner spreadsheet becomes an .ics that Google Calendar and Apple Calendar import.
Frequently Asked Questions
How do I convert a CSV file to ICS?+
Choose the CSV here, check that the title and start date columns are matched, confirm the day/month order and time zone, and select Download .ics. The file is ready at once and nothing is uploaded.
Can I convert Excel to a calendar file without saving as CSV?+
Yes. .xlsx files are read directly (the first sheet), including Excel date and time cells. Old .xls files need saving as .xlsx or CSV first.
How do I import the .ics file into Google Calendar?+
On a computer, open Google Calendar › Settings › Import & export › Import, choose the .ics file and the calendar to add it to. In Outlook use Add calendar › Upload from file; in Apple Calendar use File › Import.
Why are my events on the wrong day?+
Usually the day and month were read the other way round (03/04 can be 3 April or 4 March). Check “Dates in the sheet are written as”, switch it if needed and look at the preview before downloading.
Will importing the file twice create duplicates?+
Each row gets a fixed ID from its title and start, the same every time you convert the sheet. Calendar apps use that ID to recognise events they already have; changing a title or start creates a new ID.
Can I add reminders and repeating events?+
Yes: choose one reminder for every event, or add a Reminder column in minutes. A Repeat column accepts daily, weekly, monthly, yearly or a full rule such as FREQ=WEEKLY;COUNT=10.