Excel to Calendar Converter
Turn your Excel schedule into calendar events. Convert an event list locally, or let AI read your existing layout. Review the result and download one ICS file. No CSV export needed.
Local conversion is free, with no account or credits required. XLSX or XLS up to 5 MB, with up to 5,000 event rows per worksheet.
Use your existing workbook layout: grids, calendars, rosters, agendas, multiple tables, or event lists. AI reads the available context, then you edit missing or uncertain details in the preview. No template required.
AI recognition uses 1 credit per successful conversion, or an available guest trial. Editing and downloading the result are free. View AI pricing.
XLSX or XLS up to 5 MB. AI reads cell data and merged ranges across worksheets. Up to 100 events per result; large files may need splitting. For schedules embedded only as pictures, use Image to Calendar.
How to convert an Excel event list locally
- Open your Excel scheduleChoose an XLSX or XLS workbook. Select the worksheet and the row containing its column headings. Keep one event per row.
- Match columns and reviewConfirm the title, dates, and times. Excel date cells are read automatically; choose the date order for text dates. Set your schedule’s time zone.
- Download and importLeave out unwanted rows and resolve marked errors. Download your selected events as one ICS file, then import it into your calendar.
How to use AI recognition
- Upload your existing workbookChoose AI recognition and open the XLSX or XLS directly. No template or column mapping is required. Starting recognition uses your available conversion allowance.
- Edit the extracted eventsCheck dates, times, time zones, and repeat rules. Fill in missing details in the event editor, then select the events you want to include.
- Download your reviewed calendarSelect the events you want, download the ICS, and import it into your calendar. Editing and downloading the same result use no additional credits.
Column format for local Excel conversion
Upload your existing event list directly; no template is required. If you are starting a new spreadsheet, download the optional Excel template. It contains two meetings and a two-day all-day retreat.
Planning shifts? Use the weekly employee schedule template for Excel, with a filled example and overnight shifts.
Native Excel dates and times work directly. For text dates such as 03/04/2026, choose the correct month/day or day/month order. Review the preview before downloading.
A timed meeting needs an end time. For a night shift, include the next day as the end date. For all-day events, leave times blank and use the last included day as the end date.
Have a CSV instead? Use CSV to ICS. Working from a photo or PDF? Try PDF to Calendar or Image to Calendar.
| Column | Example | How it is used |
|---|---|---|
| Subject / Title | Team planning | Required event name. |
| Start Date | 2026-11-09 | Required. Excel date cell or a text date in the selected format. |
| Start / End Time | 09:00 / 10:00 | Both needed for timed events. Date-time cells also work. |
| End Date | 2026-11-09 | Optional; defaults to the start date. All-day end dates are inclusive. |
| All Day Event | true / false | Optional. Rows without times become all-day events. |
| Time Zone | America/New_York | Optional per-row IANA zone; otherwise use the selected default. |
| Location / Description | Room A / Bring notes | Optional event details. |
Import your Excel events into a calendar
Excel to Google Calendar
On a computer, open Google Calendar → Settings → Import & export. Choose your downloaded ICS, select a destination calendar, and import.
Google Calendar import guideExcel to Outlook Calendar
In Outlook on the web, open Calendar → Add calendar → Upload from file. Browse to the ICS, choose a calendar, and import.
Outlook import guideExcel to Apple Calendar
On a Mac, open Calendar → File → Import. Select the ICS file and choose the calendar that should receive the events.
Apple Calendar import guideUse a separate calendar for the first import so you can check the result. An ICS file is a one-time import; later Excel edits do not update it automatically.
Excel to calendar: common questions
Can AI read Excel layouts without a template?
Choose AI recognition for grids, calendars, rosters, agendas, merged cells, multiple tables, or event lists. It reads cell data and layout across worksheets, without requiring headers or one event per row. Review the extracted events and edit missing dates, times, or repeat rules. For a schedule stored only as an embedded picture, use Image to Calendar.
How do I convert Excel to calendar events?
For an event list with one event per row, choose Local conversion, open your workbook, select its worksheet and header row, and check the matched columns. For another layout, choose AI recognition and upload the workbook directly. Both methods let you review the result before downloading an ICS file. Import that file into your calendar; no CSV export or template is required.
Which Excel files and worksheets can I use?
Both methods accept an unencrypted XLSX or XLS workbook up to 5 MB. Local conversion reads one worksheet at a time, with up to 5,000 event rows and 256 columns; the header can be in rows 1–100. AI recognition reads cell data across worksheets and returns up to 100 events per result. Large files may need splitting; the tool reports when the contents exceed its limits.
What columns does my spreadsheet need?
Local conversion needs an event title and start date. Timed events also need start and end times, either in separate columns or within date-time cells. End date, location, description, all-day flag, and time zone are optional. Match columns lets you assign your own headings. AI recognition does not require fixed columns; missing or uncertain details can be edited in its event preview.
How are Excel dates, times, and formulas handled?
Local conversion reads native Excel dates and times, including the 1904 date system. For dates stored as text, select the matching date order; times must use whole minutes. AI recognition interprets dates using the worksheet context, and you can correct them in the preview. Neither method recalculates formulas. Recalculate and save the workbook in Excel first so saved formula results are available.
Can I convert Excel to Google Calendar or Outlook?
Yes. Download an ICS file using either method, then import it using Google Calendar’s desktop Import & export settings, Outlook on the web’s Add calendar → Upload from file, or Apple Calendar on Mac’s File → Import. Choose a destination calendar and check the imported dates and times.
How do time zones and all-day events work?
Local conversion starts with UTC; open Time zone to choose the zone used by your spreadsheet. A mapped Time Zone column overrides it for individual rows. AI recognition uses a time zone stated in the source, or your browser’s time zone as a fallback; check it in each event’s preview. All-day end dates mean the last included day. For an overnight event, check that its end date is the following day.
What is free, and is my workbook uploaded?
Local conversion is free, requires no account, and keeps the workbook and ICS generation in your browser. AI recognition uses 1 credit per successful conversion or an available guest trial. Starting AI recognition uploads your workbook for processing and sends its cell data and layout to our AI provider. This app does not permanently store it. Editing and downloading the result use no additional credits. Analytics record actions and event counts, without filenames or event contents.
Will spreadsheet changes update my calendar automatically?
No. An ICS file is a snapshot, not a live Excel connection. Edit the imported events or import a reviewed replacement when the workbook changes. Repeated imports may create duplicates. In Local conversion, Skip identical events removes matching selected rows within the current worksheet; AI recognition does not use that switch.
Can I export recurring events, attendees, or reminders?
Local conversion creates one event per row and does not read repeat rules. List each occurrence separately, or use the ICS File Generator for an event with a repeat rule. AI recognition can extract explicit repeating schedules; review its repeat settings before export. Neither method creates attendee invitations or imports spreadsheet reminders or attachments.