convert xls to rss?

February 15, 2007 4:57 PM

How can I create an rss feed out of the content in a spreadsheet or a database table?

I want to then marry my data with other people's data in Yahoo! Pipes or a similar service?

posted by pessoa to Computers & Internet (3 answers total)

Is this a one off thing you want to do?

I'd suggest taking a look at the actual contents of a few RSS feeds. The markup is pretty simple. You should be able to build the bulk of it in Excel using CONCATENATE statements and then add the appropriate document open and closing tags and save as text.
posted by Good Brain at 5:14 PM on February 15, 2007

Best answer: Try this: How to Create an RSS Feed With Notepad, a Web Server, and a Beer

It helped me, although the author isn't to blame for the date format errors in mine. Those are my fault.
posted by mrbugsentry at 5:32 PM on February 15, 2007 [1 favorite]

Best answer: Perl and Spreadsheet::ParseExcel with XML::RSS::SimpleGen (or XML::RSS if that's not sufficent.)
posted by Rhomboid at 6:43 PM on February 15, 2007