convert xls to rss?
February 15, 2007 4:57 PM   Subscribe

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) 1 user marked this as a favorite
 
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


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]


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


« Older What Ever Happened to Chesspiece Face?   |   The Aerogarden. How noisy? How hackable?... Newer »
This thread is closed to new comments.