UPDATE: This stopped working for some reason. If someone wants to give it a try and see if it works again, let me know in the comments. But mine quit working.
Nutshell: Turn an RSS feed into an iCal format file that you can read through Google Calendar. For my purposes, I needed this to make a content calendar, where I could see what content we’ve published and when.
My problem: well, I have plenty of problems, but one of them was that I needed to keep a content calendar at work. Keeping track of upcoming events was going to be a (mostly) manual process no matter what. But having an automatic calendar of everything we had published in the past should be easy, right? We had an RSS feed that spit out an entry for every blog post, event, publication and staff and job listing we put on our website. Surely I could use that instead of having to manually keep track of everything we’d tracked, right?
Not so fast, Chester. Most calendar applications can only subscribe to files formatted as iCalendar, so you can’t go throwing in RSS feeds into it and expect it to work. I searched high and low and couldn’t find anywhere that could tell me how I could convert an RSS feed to something that could be read by calendar applications that needed it formatted in iCal.
Dapper to the rescue again. God, I’m really beginning to love them. In a purely electronic way, of course.
To convert an RSS feed to iCal so that you can calendarize it and see everything that’s been published on your web site in the last __ days:
- Go to Dapper.net
- Select “Create a New Dapp”. You’ll need to create a user or login first so that you’ll be able to save it.
- Select the “In An Existing Feed” tab and put in your RSS feed’s address. On the next page, you can choose to rename the overall feed and/or de-select the parts of the feed that you don’t want coming through. But that’s totally optional.
- Save the Dapp.
- On the final page, go to the Choose Format dropdown on the right side and choose “iCalendar”, and then click Go.
- You’ll be prompted to select the content in the RSS and what it corresponds to in the calendar. This is because RSS and iCals need to have the information in different formats. I chose “Publication date” for both start and end date, since all I’ll want to see on the calendar is when the article was published. Title goes to Title, Description goes to Description, and Event Location I left blank.
- Make a service of it, which you’ll find at the bottom right of the final page under (confusingly) “Get A Nice Short URL”. The long URL that Dapper supplies when you turn it into an iCal doesn’t work when you plug it into Google, so the only way I could figure out how to make it work is to turn it into a public service. If anyone knows a way around this, let me know.
- Go to your Google Calendar
- Click on Add > Add by URL in the dropdown of the calendars box on the right side
- Paste in the Dapper service URL, hit “Add” and you’re all keyed in.
Here’s what it looks like in Google Calendar:

But all of these sorts of things have problems, just like me, and this one is no exception. The problems:
- It’s premature. I’ve gotten all excited about it, but I’ve only been using it for a few days, so I can’t say if there’s any problems with it. I have noticed that it doesn’t update very quickly, but since it’s a past calendar, that’s not such a big deal…at the moment.
- Google Calendar. You can see the past content, but you can’t print out in “Agenda” view for more than 10 days, so I can’t present my boss with a calendar of what’s been published where. This may not be a problem for you, but it’s kind of a big one for me.
- Lack of labels and links. As of now, everything just comes through with its title and time. What I would love to be able to do is label each one with text preceding the title that says what section of the site it comes from (ex: Publications, Press Releases, etc) and then have a link that could take me to page on the site. I may be able to do the labels with Yahoo Pipes, but so far…
- The descriptions are too long. It’s helpful to have the descriptions come through into my calendar feed, so I don’t want to remove it from the Dapp, but I also don’t need the entire article to come through in the “Details” section of my Google Calendar. I might be able to truncate the descriptions using Yahoo Pipes, but I haven’t done that just yet.
If anyone has any further info or has discovered other ways to make this useful, the comments are open and standing by.