Raging Goblin

CSV2CalDav

CSV2CalDav is a simple GUI program to convert CSV files to CalDav. Sometimes I find it easier to create a schedule using a spreadsheet program. In the end however I want to import this schedule in my calendar. CSV2CalDav is capable of converting a simple CSV file like this:

Start,End,Location,Title,Description
30-08-2015 15:30:00,30-08-2015 15:30:00,Amsterdam,Discussion Java for Dummies,Chapter 1
13-09-2015 14:30:00,13-09-2015 14:30:00,Haarlem,Discussion Java for Dummies,Chapter 2
27-09-2015 15:30:00,27-09-2015 15:30:00,Leiden,Discussion Java for Dummies,Chapter 3
11-10-2015 14:00:00,11-10-2015 14:00:00,Utrecht,Discussion Java for Dummies,Chapter 4
25-10-2015 15:30:00,25-10-2015 15:30:00,Amsterdam,Discussion Java for Dummies,Chapter 5
08-11-2015 14:30:00,08-11-2015 14:30:00,Haarlem,Discussion Java for Dummies,Chapter 6

into this:

BEGIN:VCALENDAR
PRODID:-//CSV//iCal4j 1.0//EN
VERSION:2.0
CALSCALE:GREGORIAN
BEGIN:VEVENT
DTSTAMP:20150914T183604Z
DTSTART:20150830T153000
DTEND:20150830T153000
SUMMARY:Discussion Java for Dummies
UID:c8bdb63d-256b-4c4f-83f2-05d28446bab2
DESCRIPTION:Chapter 1
LOCATION:Amsterdam
TZID:Europe/Amsterdam
END:VEVENT
BEGIN:VEVENT
DTSTAMP:20150914T183604Z
DTSTART:20150913T143000
DTEND:20150913T143000
SUMMARY:Discussion Java for Dummies
UID:cb65ff1e-df2b-4213-8d20-e5bfe243c867
DESCRIPTION:Chapter 2
LOCATION:Haarlem
TZID:Europe/Amsterdam
END:VEVENT
BEGIN:VEVENT
DTSTAMP:20150914T183604Z
DTSTART:20150927T153000
DTEND:20150927T153000
SUMMARY:Discussion Java for Dummies
[...]
SUMMARY:Discussion Java for Dummies
UID:2802bb19-72ae-4abf-86d8-45d0c9339cb7
DESCRIPTION:Chapter 6
LOCATION:Haarlem
TZID:Europe/Amsterdam
END:VEVENT
END:VCALENDAR

CSV2CalDav is limited to setting the following fields:

  1. Calendar name
  2. TimeZone
  3. Start date and time
  4. End date and time
  5. Summary
  6. Location
  7. Description

CSV2CalDav Gui

Requirements

  • Java Runtime Environment (jre 8 or higher)

Downloads

Downloads of binaries and code can be found on github.

Usage

  1. Download CSV2CalDav.one-jar.jar to its own subdirectory in a convenient location.
  2. On Linux run ‘java -jar CSV2CalDav.one-jar.jar’. On Windows dubble click CSV2CalDav.one-jar.jar or run ‘java -jar CSV2CalDav.one-jar.jar’.

History

  • 07-09-2015 Version 1.0
  • 24-09-2016 Version 1.1

Blog at WordPress.com.

%d bloggers like this: