OPML to CSV Converter & Viewer

OPML — Outline Processor Markup Language — is the standard way podcast apps and feed readers export and import subscriptions. It is an XML file listing each feed’s name and address, grouped in folders. Opening one in a text editor is not much help, and editing it by hand is error-prone. This tool shows what is inside, converts it to a spreadsheet, and builds a clean OPML file from a spreadsheet.

Where OPML files come from

Almost every podcast app and RSS reader can export one: Pocket Casts, Overcast, AntennaPod, Apple Podcasts on a Mac, Feedly, Inoreader, NewsBlur, NetNewsWire and many more, usually under Settings, Import/Export. Some newsletters and blog directories also publish OPML files of recommended feeds.

What the viewer shows

Open the file and every subscription is listed with its title, folder, feed address and website. Folders are taken from the outlines that contain the feeds, so a reader’s groups such as Podcasts or News appear as they did in the app; deeper nesting is joined with a slash. A count of feeds and folders, and the list’s own title, appear above the table.

Cleaning up in a spreadsheet

Download the CSV and open it in Excel or Google Sheets. That is the easiest place to sort by folder, remove shows you no longer follow, fix names, spot duplicates and reorganise folders. The columns are Title, Feed URL, Website, Folder, Type and Description.

Building OPML from a spreadsheet

Switch the direction and paste a table with a header row. Only a feed address column is required, named Feed URL, xmlUrl, RSS or URL. Title, Website, Folder, Type and Description are used when present. The result is OPML 2.0 with one outline per folder, ready to import into another app. Give the list a title, which some apps show during import.

Moving between apps

Export from the old app, optionally clean the list here, then import into the new one. Most apps take OPML in their settings; some ask you to upload it on their website. Expect subscriptions to move but not listening history.

A worked example

The sample export has two podcasts in a Podcasts folder and BBC News in a News folder. Its CSV line for 99% Invisible reads “99% Invisible, https://feeds.simplecast.com/BqbsxVfO, https://99percentinvisible.org, Podcasts, rss”. Converting the sample CSV the other way creates a Podcasts outline containing that feed and a News outline with the BBC feed.

Privacy

The file is read in your browser and no feed is fetched, so the tool never learns what you listen to. Website links in the table open only when you click them.

Checking for dead feeds

Long subscription lists collect feeds that stopped updating years ago. In the spreadsheet, look for shows you no longer recognise and open their website links; a podcast that moved host usually redirects its old feed, but one that ended simply goes quiet. Removing dead feeds before importing keeps the new app fast and its new-episode list clean.

Folder names that travel well

Apps handle folders differently: some allow nesting, some allow one level, and some ignore folders entirely. Short, single-level folder names such as News, Tech or Comedy survive every import, so flatten deeper groups in the Folder column before converting back to OPML.

Related tools

Build or check a feed with the RSS Feed Generator, convert other XML to tables with XML to CSV, pull web addresses out of any text with Extract URLs, or turn the CSV into JSON with CSV to JSON.