I couldn’t find a decent way online to convert ICS files into an Excel type format for easy manipulation, or adding to documents etc. So I’ve built a simple one that is now available online:
This takes an iCal URL and provides you with a CSV file as a download. Makes it much easier to get a list of dates from ICS files and use them for other purposes.
Also available is the CSV2SQL converter that I made last year, taking CSV files and coverting them into INSERT/UPDATE statements for use on a database.
I’ve been working on a data import recently that required me to pull in the contents of a folder full of excel documents, all with the same structure containing data that needed to be collated into a single file. There really isn’t an easy way to read Excel (xls files) in PHP so I’ve reverted back to my old friend Perl to get the job done. (more…)