Csv To Ical Converter
Csv To Ical Converter Free
Csv To Ical Converter Pdf
Csv To Ical Converter Freeware

Create ICS File

Dispatch your Internet program (Chrome, Firefox, Internet Explorer or whatever internet browser you utilize) and go to the CSV to iCal Calendar Convertor site page. CSV-to-ICS Converter is a free and simple tool for converting calendar data from comma-separated value (CSV) and tab-separated value (TSV) formatted files into standard iCalendar (ICS) formatted. The first step is to take your XLS or CSV file and convert it into a properly formatted CSV file that can then be converted to ICS. CSV stands for comma-separated value, so a CSV file only means that whatever data it contains is separated by commas. Not all data exports or CSVs are created equal. CSV to XLS - Convert file now View other document file formats Technical Details In computers, a CSV file contains the different values in a table as a series of ASCII (American Standard Code for Information Interchange) text lines which are then organised so that each column value is separated by a comma from the next columns value and each. Convert between CSV and iCal. A simple script to convert data in CSV format to iCal format and vice versa.

There are multiple different ways how you can create information in iCalendar format and save it to the ICS file. You can either use one of the applications which allows export of calendar information into ICS file, use development library to write out iCalendar information, convert file in some other format (CSV for example) to ICS, or type ICS file manually.

Use an application to create ICS File

There are many calendar applications which allow export of events into ICS file. These include:

All of the above applications can export and import information in iCalendar (ICS) format. It is possible to move events or entire calendars between these applications.

Use development library to write out ICS file

If you need to create ICS files algorithmically you can use one of the many available development libraries which can output information in iCalendar format. These include:

LIBICAL – Free and open-source C++ library which can read, change and write back data in iCalendar format.
iCal4j – Java open-source library which can read, process and generate iCalendar data.
ical.net- .NET library which has full support for iCalendar protocol. Developed by Markus Minichmayr.

Convert to ICS from another format

Sometimes event information is received in a format different from ICS and iCalendar. In this case it is possible to use a special application which can convert that format into iCalendar. There are websites on the internet like https://manas.tungare.name/software/csv-to-ical/ which can take csv file with events and convert it to ICS files. The input CSV file should be formatted in a specific way and contain following fields:

Subject
Start Date
Start Time
End Date
End Time
All Day
Description
Location
UID

Type ICS file in text editor

Probably most complex but at the same time perfectly doable is typing ICS file manually via text editor. You can either type all the entries based on iCalendar specification or you can just take any ICS file as an example and modify fields that you want. iCalendar specification has many examples with different iCalendar components in it. Also lots of sample ICS files are available on the internet for download so it could be relatively simple to copy an information from an existing ICS file and change it accordingly to your requirements.

Bottom line: You can batch import events from a spreadsheet to iCal or Google Calendar by formatting the headers correctly, exporting / import as .csv, then export / import as .ics.

Update May 07, 2013: This post has been completely rewritten and updated here: http://n8henrie.com/2013/05/spreadsheet-to-calendar. Feel free to reference this post as well, but the new post is much more thorough and has a few new tools that I wrote to facilitate the process of getting spreadsheet events into your calendar app of choice.

NB: This process works for me using Numbers.app, Google Calendar, and iCal. I think it should also work with Excel or Google Docs spreadsheets, but I can’t say for sure.

I try to keep all of my appointments in a digital calendar that syncs across all my devices. It’s a big deal for me – I really like to be able to look in one place to find out where I ought to be at any given moment. Getting a syncing, mobile-accessible calendar for the lecture-based years of medical school was actually a major objective leading to the creation of our medical student group, SMRT. I previously used Google Calendar but have recently converted to iCal / iCloud (mostly due to issues deleting events from Google Calendar with my iPhone – a bug that persisted for years and drove me nuts).

Over the last year or so, I’ve been handed a new schedule every month or two on my rotations. Unfortunately, these have almost always been in some kind of spreadsheet format (or they’re printed from a spreadsheet, which I request be emailed to me). Because calendaring software doesn’t know how to interpret spreadsheet information directly, I’ve developed a workflow that is a bit circuitous but not terribly onerous and allows me to bulk convert and import my spreadsheet schedules.

This process requires a Google Calendar account to process one of the files and spit out another format. You don’t have to use it for calendaring, but you can. This whole process may take from 10 minutes to an hour depending on your skill with spreadsheets and a bit of luck.

Main Idea

Give the spreadsheet the appropriate headers and format it to make Google Calendar happy
Export as comma separated values (csv)
Import to Google Calendar (stop here if you’re a GCal user, continue if iCal user)
Use Google Calendar to export to iCalendar format (.ics, iCalendar is not the same as iCal)
Import the .ics to iCal

1. Headers and Spreadsheet Formatting

This is the hardest and most important step. In order for step 3 to work, you have to get the spreadsheet set up correctly. First, open up a copy of my spreadsheet template, which you can

Please note that the Numbers.app version also has some embedded instructions inrough draft format (nothing not posted here). I think these also show up in theExcel version, but not in the GDocs version.

Basically, it’s just a spreadsheet with the headers that Google Calendar willrecognize (source).These are:

Csv To Ical Converter

You should take your spreadsheet schedule and copy and paste the information into the appropriate columns. Keep in mind that Numbers can convert date and time formats pretty well by selecting the column in question and opening up Inspector (“command option i” or view -> inspector) to “cells” (a box with “42” on my version). Makes converting a bunch of “Jan 5 2002” to “01/05/2002” a snap. Leave the columns in the order you found them. Other formatting info:

Subject: The event title
Dates: MM/DD/YYYY format seems to work for me.
Times: both “7:00 PM” and “19:00” formats seem to work
All day event: Will be true / false (checked or unchecked in Numbers)
Description: The “notes” part, optional
Location: Optional
Private: Another true / false checkbox, will make events on a shared calendar private to everyone but “owners.” I think this is also optional / no response required.

2. Export as .csv

File -> export in Numbers, unicode seems to work fine. AFAIK, the equivalent functions in Excel and Google Docs should work just as well. If you have multiple sheets in Numbers, it will export to a folder with multiple .csv files. Figure out which one has the data you need with Quick Look or a text editor, you can delete the other .csv files.

3. Import to Google Calendar

Head over to Google Calendar. If this is home base for you, you can import the events directly to your calendar. If this is just an intermediary step, I recommend creating a new temporary / junk calendar for this purpose.

Optional: How to create a temporary calendar: Click the down arrow