Why you would want to download YouTube comments
YouTube Studio lets you see comments, but getting them out — to share with a colleague, drop into a sheet, or feed a downstream workflow — is surprisingly hard. The native option only dumps your own channel's raw data, with no regard for intent, spam, or which leads you have already contacted.
For a B2B or technical creator, the comments worth acting on are a subset: the high-intent questions, the bug reports, the partnership pings. That is what a proper YouTube comment manager is for — and downloading or exporting that curated set to CSV is the natural next step.
Download what you see, not a raw firehose
The whole point of an export is that it should match your inbox, not a raw dump. In VocLens the Export CSV button reuses the exact filters the inbox is currently showing:
- Intent — high / support / general
- Channel — one channel or all owned channels
- Sub-intent — the General sub-type
- Status — unread / routed / contacted
- Search — free-text over comment text and author
Apply a filter, hit export, and the CSV downloads precisely those rows. This is true whether you think of it as downloading YouTube comments or exporting YouTube comments — same button, same file, scoped to the channels you are authorized for.
The 15 columns, and why they matter
A useful export is more than author, text. VocLens writes fifteen columns so a row is actionable on its own:
| Column | What it gives you |
|---|---|
id |
Stable lead id, also used in the app deep link |
publishedAt |
Real publish time, ISO-8601 |
author / authorChannelId / authorUrl |
Who said it, and a clickable channel |
channelName |
Which of your channels it landed on |
videoId / videoTitle |
The video it was on |
text |
The full comment |
intent / subIntent / intentSource |
Classification, and whether model- or human-labeled |
contacted |
true once you have followed up |
youtubeUrl |
Deep link straight to the comment on YouTube (watch?v=…&lc=…) |
appUrl |
Deep link back to the lead inside VocLens |
The two deep-link columns are the part people underestimate. One click from the spreadsheet and you are back at the exact comment — or at its lead in your YouTube-to-CRM view.
Excel-safe by default
Two details that save you pain the first time you open an export in Excel:
- UTF-8 BOM. Without it, Excel mis-reads Chinese, Japanese, Arabic and emoji as mojibake. The file is prefixed so it just works.
- Formula-injection guard. A comment like
=cmdor+SUM()would, in a naive CSV, execute as a formula the moment the cell is opened. Each cell is CSV-escaped and any value starting with= + - @is wrapped in quotes, so the text stays text.
Bulk download limits (the 50k cap)
For most inboxes a single export is instant. To keep the download bounded on very large accounts, one export streams up to 50,000 matching comments; if the filtered set is larger, the file ends with a # truncated marker line so it always completes. Narrow the filter (a tighter intent or a single channel) to page through the remainder.
This is the same streaming path that powers monitoring multiple channels — the export never holds the whole dataset in memory.
How to download & export in VocLens
- Open the Lead Inbox.
- Set the filters you want (intent, channel, status, search).
- Click Export CSV in the top bar. The button is disabled when there are no matching comments, and shows Exporting… while it streams.
- Open the downloaded
leads-YYYYMMDD.csvin Excel, Sheets, or your BI tool.
No extra setup, no separate export screen, no waiting on a background job for a typical inbox.
Pair it with routing
Export is the escape hatch; routing is the daily workflow. If you would rather push high-intent comments to Slack, Notion or Discord automatically, set a routing rule and let the inbox drain itself — then download the slice you need for a report.
For seven days, open your comment manager instead of Studio, filter to high-intent, and export the result once. Most B2B creators find the CSV alone surfaces pipeline Studio never let them see.