Douban Collection Export
Export your entire Douban book, movie, music, and game history to Excel-friendly CSV files — no login required.
UtilitiesBeginner★ 1,323⑂ 212AI score 8/10Last updated: Aug 8, 2026
What it does
Douban (豆瓣), China's largest books/film/music community, offers no official data export (its public API shut down in 2018). This skill uses the Frodo API — the endpoint Douban's own mobile app calls — to pull your full collection and write it to four CSV files.
- Full export of books (read/reading/want-to-read), movies & TV, music, and games
- Columns:
title, url, date, rating, status, comment; UTF-8 BOM so Excel opens Chinese text correctly - No login, cookies, or browser needed; Python 3.6+ standard library only
- Optional RSS incremental sync (latest ~10 items) for daily top-ups
- Pre-flight user ID validation so bad IDs fail fast
- Cross-platform default output under
~/Downloads/douban-sync/<user_id>/
Limits: long reviews, reading notes, and broadcasts are not exported; private profiles silently return 0 items. The docs explicitly warn against web scraping because Douban's pages are protected by Proof-of-Work challenges.
Who it's for
- Douban users who want a personal backup of hundreds or thousands of logged items
- People migrating Douban data into Notion, Obsidian, spreadsheets, or a personal blog
- Anyone who wants to analyze their reading/watching stats from rating data
- Users worried about account bans or platform changes wiping their history
Examples
- Full backup: "My Douban profile is douban.com/people/abc123/ — export everything to CSV" → creates 书.csv, 影视.csv, 音乐.csv, 游戏.csv in your Downloads folder
- Stats: hand the exported 书.csv back to Claude and ask for books-per-year and average rating charts
- Daily sync: run the full export once, then cron the RSS script to append newly marked items
· · · Install guide · · ·
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 && cp -r claude-code-skills/douban-skill ~/.claude/skills/⚠ This is a third-party skill. Check the source repository before installing.
- Open a terminal and confirm Python is available:
python3 --version(3.6 or newer). - Clone the repository:
git clone https://github.com/daymade/claude-code-skills.git - Copy the skill into Claude Code's skills folder:
mkdir -p ~/.claude/skills && cp -r claude-code-skills/douban-skill ~/.claude/skills/ - Restart Claude Code and say something like "export my Douban collection" — the skill triggers automatically.
- Find your user ID in your profile URL
douban.com/people/<ID>/and give it to Claude (a full URL works too). - To run it manually:
DOUBAN_USER=<ID> python3 ~/.claude/skills/douban-skill/scripts/douban-frodo-export.py - Check the output in
~/Downloads/douban-sync/<ID>/, or setDOUBAN_OUTPUT_DIRto change the location. - (Optional) For RSS incremental sync you need Node.js:
DOUBAN_USER=<ID> node ~/.claude/skills/douban-skill/scripts/douban-rss-sync.mjs
View source on GitHub ↗License: MIT