Blog/How to Export ICS Events to CSV or Excel (for Hours and Print Lists)
·5 min read

How to Export ICS Events to CSV or Excel (for Hours and Print Lists)

Export calendar events into CSV or Excel to calculate hours worked, build payroll summaries, or create clean printable event lists.

If you're working from an ICS calendar file, the calendar view is great for planning but not ideal for totals and reporting. Exporting events to CSV or Excel gives you a spreadsheet-friendly format so you can calculate hours worked, build summaries, and print event lists.

Why Export to CSV or Excel?

  • Calculate hours worked for payroll, timesheets, or freelance invoices.
  • Group events by client/project with filters and pivot tables.
  • Create printable lists for operations, travel, or staffing schedules.
  • Share clean event data with teams that prefer spreadsheets over calendar apps.

What Data Should Be Included?

A useful export usually includes:

  • Event title
  • Start date/time
  • End date/time
  • All-day flag
  • Duration in hours
  • Location
  • Attendees
  • Categories/tags
  • Description and URL (optional, but helpful for auditing)

CSV vs Excel: Which Should You Use?

  • CSV is universal and works in Excel, Google Sheets, Numbers, and most reporting tools.
  • Excel format is convenient for teams already working in Microsoft Office and printing from Excel directly.

In practice, many teams export both: CSV for portability and Excel for immediate office workflows.

Calculating Hours Worked

Once exported, add a calculation column (if one isn't already included):

=(EndCell-StartCell)*24

This converts date/time difference into hours in Excel-style spreadsheets. Format the result as a number with 2 decimals, then sum totals by day, week, or project.

Building a Printable Event List

  1. Sort rows by start date/time.
  2. Keep key columns only (Date, Time, Title, Location, Notes).
  3. Set page orientation to landscape if your list is wide.
  4. Enable repeating header row for multi-page printouts.

This gives you a clean handout for on-site operations, events teams, or field staff.

Common Pitfalls

  • Timezone confusion: Ensure all rows are in the same timezone before calculating totals.
  • All-day events: These often should not count toward worked-hour totals unless your process says otherwise.
  • Overnight shifts: Verify end date rolls to the next day correctly.

Quick Workflow

Preview your ICS in ICS Viewer, export to CSV or Excel, then run calculations and print exactly what you need.

Want to preview an ICS file right now?

Open ICS Viewer →