Skip to main content
Excel XLSX to iCalendar

Excel to ICS Converter

Turn an Excel schedule into an ICS calendar file for Google Calendar, Outlook or Apple Calendar. Conversion runs in your browser.

Conversion focus

Workbooks stay in your browser during conversion. Use Clear to reset the sheet, mappings and result before starting another file.

Dates and times for Excel → ICS

All-day: YYYY-MM-DD. Timed: a full date and time with a mapped TZID (for example Asia/Karachi), a UTC stamp ending in Z, or an explicit offset such as +05:00. Excel Date/Time cells are supported. Avoid ambiguous strings like 03/04/2026.

Changing the worksheet, headers, row limits or mappings clears the previous result—convert again before downloading.

Excel workbooks are read from a file only (no text paste).

Excel workbook

Drop an .xlsx file here, or click to browse

Choose a worksheet after upload. Max 25 MB.

Need Sample Files?

Pick which sheet to convert. Changing the sheet reloads column detection and clears any previous result—convert again before downloading.

Map each ICS field to a normalized table column. Use Include to choose output lines; Check all / Uncheck all sit under the mapping table.

# ICS Field Mapping Include
Provide input above to load mapping options.
Include column:

Use this output next

CSV to ICS

Convert CSV event rows to an ICS calendar file.

JSON to ICS

Build calendar events from JSON instead of Excel.

ICS to Excel

Review calendar events back in Excel.

Choose the right output

When Excel to ICS helps

  • You manage schedules in Excel and need a calendar import file.
  • Teachers, office admins or organizers need events in Google Calendar, Outlook or Apple Calendar.
  • You can map columns for title, start and end (and optional TZID, location, description or RRULE).
  • You will convert again after changing the worksheet or mappings.

When another tool fits better

  • Your source is CSV—use CSV to ICS instead.
  • You need a printable table PDF of the sheet—use Excel to PDF.
  • You only need to review calendar events in a spreadsheet—use ICS to Excel.
  • You expect live sync after import; ICS import is a one-time snapshot.

Continue with other formats

ICS to PDF

Print or share calendar events as a PDF.

Excel to PDF

Export an Excel worksheet as a PDF table.

Excel to ICS guides and FAQs

One overview and one step-by-step guide below, plus FAQs that match the live controls on this page.

Excel XLSX to iCalendar overview

Excel to ICS overview

Built for office administrators, teachers, event organizers and anyone converting spreadsheet schedules into calendar events.

Upload an .xlsx workbook, choose a worksheet and map each row to an event. Each selected data row becomes an event in one downloadable ICS file—a snapshot of your spreadsheet, not a live sync.

Input format notes

Prepare your Excel workbook

Use one event per row and descriptive column headers. Keep the event title, start, end, location and description in separate columns. Select the worksheet containing your events.

For predictable results, use these example columns:

ColumnExamplePurpose
SUMMARYTeam planningEvent title
DTSTART2026-11-10T09:00:00Start date and time
DTEND2026-11-10T10:00:00End date and time
TZIDAsia/KarachiTime zone for local times
LOCATIONMeeting room AOptional location
DESCRIPTIONReview next week’s scheduleOptional notes
UIDplanning-20261110Optional stable event identifier

Map differently named spreadsheet columns to the corresponding calendar fields under ICS mapping options. These exact header names are examples, not a requirement.

Use .xlsx files. For CSV input, use CSV to ICS.

Output format notes

Dates, time zones and all-day events

Timed events: Use a complete date and time, such as 2026-11-10T09:00:00. Map a TZID column such as Asia/Karachi or America/New_York to give local times a named time zone.

You can also use UTC timestamps ending in Z or timestamps with explicit offsets, such as 2026-11-10T09:00:00+05:00. Real Excel date/time cells are supported. Avoid ambiguous date strings such as 03/04/2026.

All-day events: Use date-only values, such as 2026-11-12. The ICS end date is exclusive: an event covering November 12 and 13 needs an end date of November 14.

If the all-day start and end dates are identical, this converter turns that into a one-day event (exclusive end = next day).

Recurring events: For advanced use, map an RRULE column containing a rule such as FREQ=WEEKLY;COUNT=3. For recurring local-time meetings, use a named time zone. Review the resulting dates and times before importing a large schedule.

Import your ICS file

Google Calendar: On a computer, open Settings → Import & export, select the .ics file, choose the destination calendar and click Import.

For Outlook and Apple Calendar, use the application’s calendar import or open-file option.

Import into a test calendar first and check event counts, dates and time zones. Importing a file does not create ongoing synchronization. Re-importing can create duplicates depending on the calendar application.

Conversion guide

How to convert Excel to ICS

  1. Upload your .xlsx workbook.
  2. Choose the worksheet containing your events.
  3. Confirm whether the first row contains column headers.
  4. Under ICS mapping options, map your event title, start, end and any optional details. Check Include for the fields you want to export.
  5. Select Convert and review the generated calendar text.
  6. Download the .ics file and import it into your calendar application.

After changing the worksheet or conversion settings, convert again before downloading.

Help

Questions before converting

One question per row — expand only what you need.

Upload an .xlsx workbook, choose a worksheet, map the event columns, select Convert and download the .ics file.

These applications support ICS files. Import the downloaded file using your application’s import options, then check the event dates and time zones. Available import features vary by application and version.

This page accepts .xlsx workbooks through the file uploader. Use CSV to ICS for CSV files.

Use YYYY-MM-DD for all-day events. For timed events, use a complete date and time with a named time zone, a UTC timestamp ending in Z, or an explicit UTC offset. Real Excel date/time cells are also supported.

The end date is the first day after the event. For an event covering November 12 and 13, enter November 12 as the start and November 14 as the end.

Yes, through an RRULE column mapped under ICS mapping options. For example, FREQ=WEEKLY;COUNT=3 creates three weekly occurrences. Use a named time zone for recurring local-time meetings.

The current converter supplies a title such as “Event 1.” Add meaningful titles to your workbook so the imported events are easy to identify.

Do not assume it will. A stable UID helps identify an event, but update and duplicate handling depend on the receiving calendar application. Test before importing again.

The workbook is processed in your browser rather than uploaded to ConversionTab for conversion.

Select Clear to remove the workbook, mappings and generated result, then upload another workbook.