Windows 10 / 11 Desktop GUI + CLI • No YouTube Data API Quota Required

Extract & Batch-Translate Entire YouTube Channels into Clean CSV & TXT

Most web-based transcript grabbers only work one video at a time. Shirube YouTube Transcript Tool (v1.1.1) indexes a full channel’s video catalog via yt-dlp, extracts manual or auto-generated subtitles, batch-translates them into your target language, and saves everything locally to an incremental SQLite cache, Excel-ready UTF-8 BOM CSVs, and timestamped .txt files.

Windows Portable Distribution (GUI + CLI) v1.1.1

Requires Windows 10/11 (64-bit) & Python 3.10+ • Released 2026-10-21

Download ZIP (36.7 KB)

File: Shirube-YouTube-Transcript-Tool-v1.1.1-win64.zip (37,551 bytes)

SHA-256: 57f04ac83d204d80e82d0d702191d6f85af2e3dbad9ab444ed9d27db0777870e

Verify on Windows: CertUtil -hashfile Shirube-YouTube-Transcript-Tool-v1.1.1-win64.zip SHA256

1,023 Videos

Verified single-channel benchmark on Windows 11

8+ Languages

Batch translate into EN, JA, ES, DE, FR, PT, KO, ZH

100% Local

SQLite resume • Zero cloud middleman

Shirube YouTube Transcript Tool v1.1.1

🌐 UI: English / 日本語

Channel URL: https://www.youtube.com/@TED

C:\Users\<USER>\Desktop\youtube_transcripts

Source Priority

English Priority (en,ja)

🌐 Translate To

Japanese (ja) / English (en)

🧪 Test First 10

▶️ Extract All

🌐 Translate DB

Total

1,023

Extracted

1,022

Translated

1,022

No Sub

Errors

[00:41:11] Channel indexing complete: 20 videos discovered.

[00:41:17] [OK] Lang=en (manual) | Chars=11,630 -> transcripts/vfbNzpd6cIw.txt

[00:43:57] [OK] Translated (5,817 chars) -> transcripts/vfbNzpd6cIw.ja.txt

[00:44:03] 🎉 Batch translation finished! Saved UTF-8 BOM CSVs.

Why Researchers & Content Teams Use This Tool

Designed around real-world constraints when archiving or analyzing hundreds of YouTube videos on Windows.

01 / Bulk Channel Translation

Translate Entire Foreign Channels at Scale

Extract Japanese, Spanish, German, or Korean channels and batch-translate every video into English (or vice versa) during extraction—or run --mode translate_existing on an already downloaded SQLite database. Outputs side-by-side original and translated columns in transcripts.csv plus individual {video_id}.{lang}.txt files.

02 / SQLite State & Safe Resume

Pause Anytime & Sync Only New Uploads

Every video’s status (pending, success, no_transcript, error) is committed immediately to channel_cache.db. If you stop a 1,000-video job halfway through, clicking Extract All / Resume continues from video #501 without re-fetching completed videos.

03 / Excel 32,767-Char Safe

UTF-8 BOM CSV + Timestamped TXT Files

Long podcast or lecture videos often exceed Microsoft Excel’s 32,767-character single-cell limit. The tool simultaneously writes timestamped transcripts/{video_id}.txt files and lets you switch CSV export between Full Text, TXT Path Only, or Both.

What This Tool Can Do

✓ Index all public videos on a YouTube channel (@handle, /channel/UC..., /videos, or playlist URLs) without a YouTube Data API v3 key.
✓ Extract creator-uploaded manual subtitles (manual) and YouTube auto-generated captions (generated) according to your language priority.
✓ Batch-translate transcripts into English (en), Japanese (ja), Spanish (es), French (fr), German (de), Portuguese (pt), Korean (ko), or Simplified Chinese (zh-Hans).
✓ Automatically pause after two consecutive HTTP 429 rate-limit responses so your IP is not hammered, preserving all completed data in SQLite and CSV.

Honest Limitations & Rate-Limit Reality

• Requires Existing Captions (Not an Audio Whisper Transcriber): If a video has no manual subtitles and YouTube has not generated auto-captions (e.g., silent footage or disabled captions), the video is recorded as no_transcript. It does not download audio or run Whisper ASR.
• Per-IP Rate Limits Still Apply: Running locally avoids shared cloud-server IP bans, but YouTube still enforces per-IP rate limits (HTTP 429) when hundreds of transcripts are requested rapidly. Use the default 2.0s–5.0s interval and see our Troubleshooting Guide.
• Private / Deleted Videos: Private, deleted, or DRM-restricted videos cannot be extracted (VideoUnavailable).

Technical Guides & Research Workflows

Step-by-step tutorials with verified CLI commands, CSV schemas, and AI analysis pipelines.

View All 7 Guides →

GUIDE 01 • CHANNEL ARCHIVING