Put a spreadsheet of dates into your calendar

Typing a season of fixtures or a rota into a calendar one by one takes ages. Import them all at once from the spreadsheet.

Why use an ICS file

An .ics file holds many events at once, and every calendar app can import it.

The columns are recognised for you: Subject, Start date, Start time, End time, Location and Description.

When you might need this

• Rotas and shiftsA month of shifts from the work spreadsheet.
• Fixtures and eventsClub fixtures, school dates or a conference programme.
• DeadlinesProject milestones from a plan.

Key benefits

• UK or US datesChoose whether 03/04 means 3 April or March 4.
• All-day and timed eventsRows without a time become all-day events.
• PrivateYour schedule stays on your device.

How to do it

1. Make sure the sheet has a heading row with at least Subject and Start date.
2. Open it in CSV to ICS.
3. Choose day-first (UK) or month-first (US) dates.
4. Press Convert, then import the .ics into your calendar.

Tips

• In Google Calendar, import into a new calendar first, so you can remove it easily if something looks wrong.
• Events without an end time are made one hour long.
• Going the other way, ICS to Excel lists a calendar's events in a spreadsheet.

Questions

Tools for this job

• CSV to ICS
• ICS to Excel
• ICS to CSV
• CSV to Excel

More guides

• Work and businessTurn Zoom or Teams captions into a Word documentTurn the VTT caption file from a Zoom or Microsoft Teams recording into a readable transcript in Word or plain text, with or without times.
• Work and businessFix a CSV that opens wrongly in ExcelFix CSV files that open in Excel with garbled accents (é instead of é) or with every value squashed into one column. Free, and nothing is uploaded.
• Work and businessTurn JSON into a spreadsheetTurn a JSON export or API response into an Excel spreadsheet or CSV, with nested fields as columns, so anyone can sort, filter and chart it.