Online Tool to Convert .ICS file to Excel/CSV

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:

http://csv2sql.com/ical2csv/

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.

13 Replies to “Online Tool to Convert .ICS file to Excel/CSV”

  1. Strange – it works perfectly for me. Check that you are pasting in iCal URLs with “http://” at the start and not “webcal://”

  2. Not only does it redirect me to a blank page when I hit “go”, but how can you email me the url or file? You have in your comments – “Simply enter an iCal URL, and the resulting CSV file will be sent to you as a download!”

    When you do NOT have an e-mail field to fill in? 🙂

    Thanks for your work on this. I’m trying to convert an .ics into a .csv for re-upload into Airset, since every attempt at uploading my events .csv file (despire following the instructions) keeps saying there is something wrong with my header fields 🙂

  3. Hi BJ,

    If you use a URL for an iCalendar, then click “Go” your web browser will present you with a “Save File…” dialog – but only if the script can read your ICS URL. I can see how my wording might be confusing.

    The tool I’ve built only works for URL’s, not files (haven’t got around to those yet), so you’d need your ICS file somewhere publically available on the web for the tool to work.

    Cheers,

    Ev

  4. Would you be able to modify your CSV2SQL to generate a new record for each event instead of for each property within the ics file. Where property names would represent columns and property values would be the corresponding value.

    thanks,
    JSnow

  5. Hi,

    I would like to convert my Google Calendar to an Excel spreadsheet so I can do some spreadsheet work. Alternatively, convert the ICS file to CSV, then import to Excel.

    I don’t understand what you are asking for, when you say “provide the iCal URL? Google calendar can export the ICS file. How do I convert it to XLS or CSV? Thank you.

    Peter

  6. I am trying to migrate my yahoo calendar to Outlook 2003. The only option I can find on Yahoo calendar is to export as an ics file. If I use your conversion process will I be able to import that directly into Outlook? I know Outlook allows csv imports but I am unsure if the format will be Outlook friendly. Please e-mail for clarifications and replies.

  7. I have a .ics file to convert into an Excel file. How do I turn the .ics file into a “iCal URL” (what is it ?), and if I get a CSV file (what is it?), how do I get an Excel file?
    Yves Dumont

  8. Thanks. I was trying to convert a baseball schedule from ics to csv. eHow had directions to do it, but they didn’t know what they were talking about. Thanks again.

  9. Hi.
    Very keen to try your converter, but the link is dead.
    Have you a new one?
    Please kindly advise.
    Thx!!
    -|||| Brian |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||

Leave a Reply