Douban Collection Export
Exports your Douban book/movie/music/game history to Excel-ready CSV files via the Frodo API, with optional RSS incremental sync.
UtilitiesBeginner★ 1,323⑂ 212AI score 8/10Last updated: Aug 8, 2026
What it does
- Exports a Douban user's full book, movie, music, and game collections to CSV.
- Uses Douban's public mobile (Frodo) API — no login, cookies, or browser needed.
- Produces four UTF-8 BOM CSV files (books, film/TV, music, games) that open cleanly in Excel on macOS, Windows, and Linux.
- Includes an RSS-based incremental sync script for daily updates of the ~10 newest items.
- Validates the user ID up front so wrong IDs fail fast.
Limitations
- Cannot export long reviews, reading notes, or broadcasts.
- Always exports all four categories at once; no per-category filtering.
- Private profiles silently return zero items.
Who it's for
- Long-time Douban users who want a personal backup of their logs.
- Anyone migrating Douban data into Notion, Excel, or a personal site.
- Data hobbyists who want raw CSVs for reading/watching stats.
Examples
- "Export all my Douban reading history" → runs
DOUBAN_USER=<id> python3 scripts/douban-frodo-export.py, writing CSVs to~/Downloads/douban-sync/<id>/. - Paste a full profile URL like
douban.com/people/xxxx/and the script auto-extracts the ID. - After the initial full export, schedule
node scripts/douban-rss-sync.mjsfor daily incremental updates.
· · · Install guide · · ·
Try it now, no install
Paste this into Claude to use the skill without installing anything.
Read the instructions in this file and follow them to help me: https://raw.githubusercontent.com/daymade/claude-code-skills/HEAD/douban-skill/SKILL.md What I want: (describe your task here)
If Claude can't open the link, open it yourself and paste the contents instead.
↓ If it works for you, download the ZIP below and install it. Then it runs on its own — no pasting each time.
Install in the Claude app (no terminal)
- Download the ZIP with the button below.
- In Claude, open Settings → Capabilities and turn on 'Code execution and file creation'. (one time)
- Go to Customize → Skills → + → 'Upload a skill' and upload the ZIP.
Install in Claude Code
Let Claude do it — paste this into Claude Code
Install the skill I found on Claude Skill Mart. Copy the douban-skill folder from the GitHub repo daymade/claude-code-skills into my ~/.claude/skills/douban-skill/. When it's done, tell me in one line what this skill can do.
Install with a command instead
git clone https://github.com/daymade/claude-code-skills.git /tmp/ccs && mkdir -p ~/.claude/skills && cp -r /tmp/ccs/douban-skill ~/.claude/skills/⚠ This is a third-party skill. Check the source repository before installing.
- Open a terminal and confirm Python 3.6+ is available:
python3 --version(alsonode --versionif you want RSS sync). - Clone the repository:
git clone https://github.com/daymade/claude-code-skills.git - Create the skills folder:
mkdir -p ~/.claude/skills - Copy just this skill:
cp -r claude-code-skills/douban-skill ~/.claude/skills/ - Restart Claude Code and ask it to "export my Douban collections".
- Provide your Douban profile URL, then verify output with
wc -l ~/Downloads/douban-sync/<id>/*.csv.
View source on GitHub ↗License: MIT