Trim Down Your RSS Reading List By Removing Duplicate Feeds
If you have been following RSS feeds for a long period of time, there may be duplicate feeds present in your news aggregator that have different URLs but point to the same content on the web.
This can happen due to various reasons like:
1. Website xyz.com originally had a feed at xyz.com/feed but later moved to xyz.com/rss without redirecting the previous one. You may be subscribed to both feeds.
2. Your news reader is not smart enough to recognize duplicate feeds and doesn’t throw a warning when you try adding a feed that already exists in your subscription list.
How to Detect and Remove Duplicate RSS Feeds ? (and Reduce RSS Stress)
Whatever be the reason, it is relatively easy to remove duplicate RSS feeds from your subscriptions.
The first step is to export your entire feed subscription list as an OPML file. They are plain text files and you can view the contents in any text editor including Notepad.
The next step is to sort the content of this file. You can use the sort command in DOS / Unix or just import this OPML file into Google Docs / Microsoft Excel and use the built-in Sort feature.
If your reading list is small, simple scroll through the list to detect any duplicate subscriptions - if two or more feeds share the same values in text, title and htmlURL fields, that means they are duplicates. Make a note of such feeds and unsubscribe from them in your RSS Reader.
If you reading list has hundreds of RSS feeds, you may like to explore Excel Macros or Advanced filters that can detect duplicate records in spreadsheets.
Google Developer Expert, Google Cloud Champion
Amit Agarwal is a Google Developer Expert in Google Workspace and Google Apps Script. He holds an engineering degree in Computer Science (I.I.T.) and is the first professional blogger in India.