WIN-J · EVERYDAY & WORK TOOLS

Excel schedule to calendar (.ics) converter

Turn an Excel schedule into a calendar .ics file. Choose a worksheet, match the event columns, and preview timed or all-day events before saving the file in your browser.

Free · no installationYour inputs are processed in this browser.

Input settings

The first populated row is the header. Choose a file up to 5 MB or load a sample. Processing stays in your browser.

How to use

  1. Open an .xlsx workbook or load the sample. Select the worksheet with your schedule.
  2. Match the event title and start columns. Match end, location or description columns if needed.
  3. Choose the time zone for the times in the worksheet, then preview the events and check any flagged rows.
  4. Download the .ics file and import it into the calendar you want to use.

Example

A Planning meeting that starts at 2026-11-12 09:30 in Asia/Seoul is saved as 2026-11-12 00:30 UTC. A date-only event stays on the written date in your calendar.

Method and limitations

Supports .xlsx files up to 5 MB (24 MB unpacked) and 40 worksheets. One worksheet is converted at a time, with up to 1,000 data rows and 100 columns. The first populated row is used as the header. Use Excel date values or YYYY-MM-DD, optionally with HH:mm or HH:mm:ss. Paste formula results as values before importing. Event times use the selected IANA zone, and ambiguous or skipped local times are flagged. Each calendar app controls how imported events are displayed.

Frequently asked questions

Which columns are required?

Match a title and start column. End, location and description are optional. Leave an end blank if the spreadsheet has no end time.

How do I make an all-day event?

Use automatic date interpretation and enter a date without a time. If the event spans multiple days, enter the final day it occupies as the end date.

Can I export a sheet with invalid rows?

Each invalid row shows its Excel row number and reason. You can fix the sheet and load it again, or explicitly choose to download the valid rows only.

How do I import into Google Calendar?

On a computer, open Settings and choose Import & export. Select the .ics file and the destination calendar, then import.

Related tools

References