How to convert Excel to ICS

Step 1: Format Your Excel Columns

Ensure your spreadsheet is clean and organized. Make sure your dates and times are in a recognized standard format. Your Excel sheet should have at least these essential columns (headings in row 1):

  • Subject (or Title)
  • Start Date (e.g., YYYY-MM-DD or MM/DD/YYYY)
  • Start Time (e.g., HH:MM:SS. Optional)
  • End Time (e.g., HH:MM:SS. Optional)
  • Location (Optional)
  • Description (Optional)

Step 2: Convert Excel Calendar to iCal feed

  1. Upload excel to https://qing.day .
  2. Copy the link.

Step 3: Subscribe

Open your preferred calendar app, find the option to add or subscribe to a new calendar (often labeled “From URL” or “Add Calendar”), and paste the link.

How iCal Feeds Work

  • One-Way Sync: The feed acts as an active, read-only connection. When the host calendar is updated, your subscribing calendar fetches the new or changed events automatically.
  • No Manual Uploads: You subscribe to the web link just once, bypassing the need to constantly download and re-import files.

Common Use Cases

  • Team Schedules: Pulling employee shifts or availability into your personal work calendar.
  • Bookings: Syncing Airbnb or booking platform reservations.
  • Events & Sports: Subscribing to public holiday lists, concert schedules, or sports fixture lists.
  • Personal Organization: Viewing your personal work calendar inside your family’s shared calendar