I have modified the code from a personal project to create a spreadsheet that makes RSS creation as easy as maintaining a list of your recent posts.
excel screenshot ø rss example ø validate rss example
If you are a website owner without an RSS feed (most Excel Sites) and is capable of logging the Title, Link, and Short Description of your latest article in an Excel spreadsheet, you can now offer your users updates via RSS.
Also, since people are notorious for keeping lists in Excel, if you would like to syndicate those lists, the following could be manipulated to do so(with some VBA know-how of course).
One Time Steps
1. Download the Spreadsheet
2. Open the Spreadsheet and enter your Domain’s URL address, Title, Description, and the name you would like for your RSS file and Save.
Create your RSS feed
1. Click the “Insert New Item” button
2. Type the Title, Link, and Description of your latest post/article
3. Click “Create RSS Feed”
That’s it. An RSS feed will be exported, with the name you’ve chosen, to the directory that you opened the spreadsheet from. Upload and write over the current version of the file to wherever you have told people your RSS feed exists.
Notes:
- Stay away from special characters and use proper punctuation for best results
- Validate Your Feeds!
- Worksheet pw: automateexcel
- This is for demo purposes only. I’ve left the VBA unprotected so you can add error checking, modify, or view as needed for your “production” version.
- Get an “RSS Heart” here
December 15th, 2004 at 8:28 pm
This is awesome!
One of the problems I’ve encountered is running the macros while in “High Security” mode – since you didn’t/don’t sign the macro, it doesn’t run.
Copying your VBA code to notepad and pasting it back into my own spreadsheet works (as I’m the owner, and I *certainly* wouldn’t write VBA code that would mess anything up).
Thanks much.
Steve
December 15th, 2004 at 9:03 pm
Thanks Steve. I’ll see about possibly signing my macros in the future. If you create anything interesting out of it let me know.
October 6th, 2005 at 2:52 am
Your tutorial has made me curious…..
I have only ever used Excel for the simplest of tasks. Never enough time to learn macros and the like.
Now I am really curios and…excited. Maybe there was a reason I planned my sites in xls after all.
*Bookmarked*
Thanks again,
Matt
August 14th, 2008 at 6:48 pm
[...] received some feedback on the Create an RSS Feed With Excel and wanted to make a quick note that its [...]
October 30th, 2008 at 9:14 pm
This is a great way to use excel. I’ve been looking for something to make RSS feeds to import into wordpress. Is it possible to add the ‘pub date’ tag into the rss feed??
-Mike
January 16th, 2009 at 9:28 pm
Your instructions do not work. Keeps asking for password after trying to add new item. Can I add a file with 12000 + lines or does this have to be done manually one item (line) at a time ?
Please help as I have been tearing my hair out for months trying to create a rss or xml for my site that only contains my products and not all the other pages on my site.
Thanks,
Bob @ Boogiebobs Records
April 13th, 2009 at 1:22 pm
Great help!
Do you also have this in Excel voor Mac (applescript).
Regards,
Philip.