Bilibili comments hold rich Chinese-market signal — extract them as structured data instead of scrolling forever.

Why export Bilibili (哔哩哔哩) comments

Bilibili is China's largest video community, but its comment UI is paginated and lazy-loaded, with replies nested deep. For brands tracking Mandarin sentiment, China-market researchers, and creators studying competitor engagement, an export turns hours of manual reading into a spreadsheet you can filter and pivot.

  • Brand sentiment in the CN market — Quantify how Chinese viewers react to a campaign or product video.
  • Creator competitive audit — Compare top-comment themes across competing UPs (uploaders).
  • Localisation research — See which regional dialects and city tags dominate a video's audience.
  • VIP / Big-VIP segmentation — Filter the export by VIP status to find high-value commenters.

How to export — step by step

Step 1: Copy the Bilibili video URL

Both BV-form (e.g. BV1xx411c7mD) and the legacy AV-form video URLs work — paste either.

Step 2: Paste on ExportComments.com

Open the Bilibili Comments Exporter and paste the URL.

Step 3: Click "Start Export Process"

The exporter resolves BV → AV, paginates through every top-level comment, and expands every reply tree.

Step 4: Download Excel / CSV / JSON

Mandarin text is preserved verbatim; field labels are in English.

Inside the export — what fields you get

  • Author Name — Bilibili display name.
  • Author ID — Persistent Bilibili UID — survives username changes.
  • Author URL — Direct link to the commenter's space (个人空间).
  • Date — ISO timestamp.
  • Likes — Like (👍) count.
  • Comment — Full comment text in original Chinese.
  • Reply Count — Number of replies nested under this comment.
  • Reply To — Empty for top-level comments; populated with parent comment ID for replies.
  • Level — Bilibili user level (0–6 + LV6+).
  • VIP — VIP / Big-VIP / none.
  • Location — IP-based region tag Bilibili attaches to comments.

Common workflows

  • CN sentiment via AI — Pipe Mandarin comments through the AI Sentiment Analysis add-on — it handles Chinese natively.
  • Bot filter — Sort by Level — Level 0–1 accounts are statistically more likely to be promotional/bot.
  • Regional heatmap — Group by Location to see which provinces over-index for engagement.

Plan limits & API access

Free 100 / Personal 5,000 / Premium 50,000 / Business 250,000 comments per export. See pricing for the full breakdown. The REST API is available on Premium and Business plans.

FAQ

  • Is a Bilibili account needed?
    No. Public videos export without sign-in. Member-only (大会员) videos are not supported.
  • Does it support live-stream chat?
    This exporter is for video comments. Live-stream chat is a different format and isn't included.
  • Are emoji and stickers preserved?
    Yes — Bilibili-native emoji like [doge] survive as text tokens; Unicode emoji pass through cleanly.
  • How many comments per export?
    Up to your plan cap — Free 100, Personal 5,000, Premium 50,000, Business 250,000.

Open the exporter and try it on your own URL.