I have finally decided to switch from the Apple Podcast app to Overcast, but I cannot find a way to move my subscriptions. A (similar question) was asked a while ago, but iTunes has changed since then, and the new MacOS app doesn't have those menus. So, I was wondering if anyone knows another way to get an OPML file.


The Podcasts app appears to store its data inside a sqlite database. Using the information inside we can create an OPML file that Overcast (or any good podcast app) will accept.

Here's a script that I made that will create the OPML file:


sql() {
    sqlite3 "${HOME}/Library/Group Containers/"*.groups.com.apple.podcasts/Documents/MTLibrary.sqlite "select ${1} from ZMTPODCAST ${2:+"where ${2} = '${3}'"};" |\
        sed -e 's/&/\&/g' \
            -e 's/</\&lt;/g' \
            -e 's/>/\&lgt;/g' \
            -e "s/'/\&apos;/g"

cat > ${opml_export} << HEAD
<?xml version="1.0" encoding="utf-8"?>
<opml version="1.0">
  <head><title>Podcast Subscriptions</title></head>
    <outline text="feeds">

sql ZUUID | while read -r uuid ; do
    feed_url=$(sql ZFEEDURL ZUUID "${uuid}")
    home_url=$(sql ZWEBPAGEURL ZUUID "${uuid}")
    title=$(sql ZTITLE ZUUID "${uuid}")
    cat <<EOT
<outline type="rss" text="${title}" title="${title}" xmlUrl="${feed_url}" htmlUrl="${home_url}" />
done >> ${opml_export}

cat >> ${opml_export} << TAIL

This will create podcasts.opml on your desktop.

  • 1
    awesome, it worked like a charm! and sorry for a late response, I have completely forgotten about this question lol – AbliusKarfax Jan 8 '20 at 3:35

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .