Skip to content
/ icsp Public

Command-line iCalendar (.ics) to TSV / CSV utility. Written in Bash + AWK

License

Notifications You must be signed in to change notification settings

loteoo/icsp

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

27 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

icsp banner

Small, fast and simple command-line tool to convert calendar exports (.ics files) into TSV/CSV files for easy analysis and usage in broader use-cases

Combine this with CSV tools like xsv, q, csvkit or visidata for calendar data superpowers.

Written in pure bash and AWK. Compatible with most unix systems (ubuntu, macOS or windows with WSL).

Installation

To install icsp, you can use the install script:

bash <(curl -fsSL "https://raw.githubusercontent.com/loteoo/icsp/main/install")
Or, do a manual installation (click to expand):
  1. Download the repo (via git clone or .zip download) and keep it somewhere
  2. Create a symlink from an executable BIN directory (such as /usr/local/bin, ~/.local/bin or ~/bin) to the icsp file in the directory that you downloaded.

Example:

#         This bin directory should be in your executable $PATH
#                                     /
ln -s ~/my-repos/icsp/icsp ~/.local/bin/icsp
#                       \
#     This should be the actual icsp script file

Usage

Run icsp -h for usage.

icsp - iCalendar (.ics) parser. v1.0.0

Convert iCalendar files to (and from) TSV files.

Usage:
  icsp [-c columns] [-d delimiter] [-x component] [-nrh] [...files]

Options:
  -c <string>   Comma seperated list of fields to parse. Order is preserved, case insensitive.
  -d <string>   Delimiter character to use for seperating values. Default: '\t' (TAB character)
  -x <string>   ICS component to parse. Default: VEVENT
  -n            No date conversion (faster processing, no DURATION column, no ISO format)
  -r            Reverse conversion (Build ICS file from TSV)
  -h            Show this help text.

Basic examples:

# Simple usage
icsp calendar.ics > calendar.tsv

# Custom delimiter
icsp -d ',' calendar.ics > calendar.csv

# Display specific fields
icsp -c 'dtstart,summary,duration' calendar.ics > calendar.tsv

# Download calendar from the internet as TSV
curl https://foobar/path/to/calendar.ics | icsp > calendar.tsv

# Convert TSV file to iCalendar file
icsp -r calendar.tsv > calendar.ics

Usage notes:

For the -c option, if you don't specify it, icsp will return all fields found in the .ics file, sorted by how often they are populated. This is useful to quickly check what's in a file, but it is also usually pretty messy, so specifying the wanted columns and their order is probably recommended.

There is also a special duration column you can specify via -c that will be computed by icsp (unless already supplied by the iCalendar file). This is often useful because calendar providers usually don't provide this value directly even if it's really useful for viewing the calendar data.

The default delimiter for the -d option is a TAB character (TSV), instead of a comma (CSV), because tab delimited files have a much better chance of not needing to escape the field delimiter within the values, which makes it more likely to be command-line friendly by default.

The -x option lets you parse iCalendar objects other than events if needed. The default value is "VEVENT" for events, but other values could be, for example: "VTODO", "VJOURNAL" "VFREEBUSY" "VTIMEZONE" "VALARM".

The -n option skips external calls to the date command which makes the processing much faster and might avoid issues if you don't have a normal date command available on your system. Downside is: no ISO timestamps, and no DURATION computation.

The -r option is for creating ics files from tabular files, because why not! This will also take care of converting the ISO timestamps back into the iCalendar format if necessary. This is somewhat of a "experimental" feature right now, since there's a lot of options that this could open the door to that we don't support. For now it just creates a bare-bones, minimal ics file with zero metadata.

Advanced examples

icsp -c 'dtstart,summary,duration' calendar.ics \
  | grep '2022-06' \
  | sort \
  | column -t -s $'\t' \
  | less -S

What each line does in order:

  1. Only show the 'dtstart', 'summary' and 'duration' fields, in that order from the 'calendar.ics' file
  2. Filter to June 2022 only
  3. Sort chronologically
  4. Align columns (using column command)
  5. Display result in scrollable area (using `less`` command)

Demo commands

Canadian 2023 holidays

curl -s 'https://calendar.google.com/calendar/ical/en.canadian%23holiday%40group.v.calendar.google.com/public/basic.ics' \
  | icsp -c dtstart,summary \
  | grep 2023 \
  | sort \
  | column -t -s $'\t' \
  | less -S

Montreal weather forecast in celsius:

curl -s 'https://ical.meteomatics.com/calendar/GC37%2B87%20Montreal%2C%20QC%2C%20Canada/45.503279_-73.586855/en/meteomat.ics' \
  | icsp -c dtstart,summary \
  | tail -n +2 \
  | column -t -s $'\t'

Phases of the Moon 2023:

curl -s 'https://calendar.google.com/calendar/ical/ht3jlfaac5lfd6263ulfh4tql8%40group.calendar.google.com/public/basic.ics' \
  | icsp -c dtstart,summary \
  | tail -n +2 \
  | grep 2023 \
  | sort \
  | column -t -s $'\t'

Space flight launch calendar:

curl -s 'https://calendar.google.com/calendar/ical/nextspaceflight.com_l328q9n2alm03mdukb05504c44%40group.calendar.google.com/public/basic.ics' \
  | icsp -c dtstart,summary,location \
  | tail -n +2 \
  | sort \
  | column -t -s $'\t' \
  | less -S

Merge calendars together:

curl -s 'https://calendar.google.com/calendar/ical/nextspaceflight.com_l328q9n2alm03mdukb05504c44%40group.calendar.google.com/public/basic.ics' \
  | icsp -c dtstart,summary,location \
  | tail -n +2 \
  | sort \
  | column -t -s $'\t' \
  | less -S

I like to do these kind of manipulations on the command-line, but remember that you can always load these TSV/CSV files in your favorite programming language for maximum power and flexibility.

How to get some .ics files to try it out:

From Google Calendar Step 1 Step 2
From Outlook Step 2 Step 2 Step 3

Motivation

While common calendar software (Google, outlook, apple calendars, etc) may provide API access to your calendar data, it is usually a very involved setup that requires changing account configuration or permissions, dealing with authentication / authorization and reading company specific docs.

At the same time, they all provide very simple import/export features just a few clicks away using the iCalendar (.ics) format from 1998. If we just want to read in data, let's use that instead!

Reading

iCalendar:

Working with tabular data on the command-line:


PRs, issues and ideas are welcome.

Give the repo a star to show your support!

Crafted by millisecond studio ❤️