How to export YouTube comments to a spreadsheet
YouTube Studio lets a channel owner read comments, not download them, and it shows nothing for videos you do not own. This guide covers the export, the 30-day rule that applies only to YouTube, and what to do with the file once you have it.
Updated Nov 19, 2026 · 6 min read
Links that work
youtube.com/watch?v=dQw4w9WgXcQ, with or without extra parts such as&t=42sor a playlist.youtu.be/dQw4w9WgXcQ, the short form the Share button gives.youtube.com/shorts/…for a Short.youtube.com/live/…for a finished or running live stream. The comments under the video are read. Live chat messages are a separate thing and are not comments.
A link to a channel, a playlist or a community post is not a video and cannot be exported. Private videos, members-only videos and videos with comments turned off have no public comments to read. Videos marked as made for kids never have comments.
Export the video
- Paste the link on the YouTube to Excel page, the YouTube to Google Sheets page or the home page and press Export.
- On the export page, compare comments read with the count YouTube shows. YouTube's count includes replies, and so does the file.
- Download the Excel workbook or the CSV, or use Copy for Sheets.
Videos and Shorts with up to 5,000 comments export free, with every reply. Bigger videos show a labelled preview first; the pricing page has the options for the rest.
Why a YouTube export is deleted after 30 days
YouTube comments are read through YouTube's official Data API. Every service that uses that API agrees to YouTube's developer policies, and one of them limits how long a service may keep the data it fetched: 30 days, after which it must be deleted or fetched again. Other networks set no such clock.
What that means in practice:
- The export page for a YouTube video, its downloads and its live link stop working 30 days after the video was read.
- A file you downloaded is yours. The rule applies to the copy held here, not to the workbook on your computer.
- A Google Sheet filled by
=IMPORTDATAshows an error once the link ends. Before then, select the imported range, copy it and use Paste special, Values only so the rows stay. The IMPORTDATA guide has the steps. - Needing the comments again later means exporting the video again, which also picks up what was posted in between.
The workbook's Read me sheet carries a YouTube data line with the same reminder, so whoever opens the file months later knows why the export page is gone.
What the columns hold for YouTube
usernameis the commenter's @handle, lower case, without the @. A channel with no handle appears by its channel ID instead.user_idis the channel ID, 24 characters starting withUC. Add it tohttps://www.youtube.com/channel/to open the commenter's channel.comment_idis text such asUgxKREWxIgDrw8w2e_Z4AaABAg. A reply's ID is its parent's ID, a full stop, and its own part, so a reply can be recognised from the ID alone. These IDs are not numbers, so spreadsheets do not round them.commentis the plain text the person typed. Links and timestamps such as2:31are kept as text.likesis the like count on the comment. Dislikes are not public, and the file does not say which comments the creator pinned or gave a heart.posted_at_utcis when the comment was first posted, in UTC.
Comments are read newest first, so # 1 is the most recent thread. Sort by posted_at_utc to read from the first comment onward.
What YouTube does not show anyone
A channel can hold comments for review, either all of them or the ones YouTube judges likely to be spam. Held comments are not public until approved. A channel can also hide a user, which removes that person's comments from public view. Both kinds can still be part of what people expect to see, and neither can be read by any export. If the file is short by more than a few percent, read how to check an export is complete; the same five checks apply to a YouTube file.
A worked example: which moments do viewers talk about?
Viewers quote timestamps: "the part at 4:12". Pulling those out shows which moments of a video drew comments. In the Comments sheet, column M holds platform, so start in N.
Google Sheets, in N2, filled down:
=IFERROR(REGEXEXTRACT(E2&"", "\d{1,2}:\d{2}(?::\d{2})?"), "")
Excel (Microsoft 365 with the regex functions):
=IFERROR(REGEXEXTRACT(E2, "\d{1,2}:\d{2}(?::\d{2})?"), "")
Name the column timestamp. Then count each one. In Google Sheets:
=QUERY(N1:N, "select N, count(N) where N <> '' group by N order by count(N) desc label count(N) 'comments'", 1)
In Excel, insert a PivotTable with timestamp in Rows and Count of timestamp in Values, then filter out the blank row. The pivot table guide shows the clicks.
On a 20-minute tutorial this usually gives three or four timestamps that collect most of the mentions. Those are the places to cut a Short from, or the places where the explanation lost people. Read the comments at each one before deciding which it is.
Three more things worth doing with a YouTube file
- Find the questions. Tutorials and reviews attract them. Find questions and buying intent with REGEXMATCH turns them into a list you can answer.
- Sort by likes. On YouTube, comment likes are a real signal of what the audience agrees with. Sort the Comments sheet by
likes, largest first, and read the top twenty. - Compare with the same video's clips elsewhere. The
platformcolumn lets a YouTube export sit in one sheet with the Instagram and TikTok versions: compare comments across networks.
FAQ
Can I export comments from a video I do not own?
Yes. Any public video or Short with comments turned on can be exported. Nothing asks for a Google login.
Why is my YouTube export page gone after 30 days?
YouTube's developer policies limit how long a service may keep data fetched through its API. The export is deleted on that schedule. Files you downloaded stay with you.
Are replies included?
Yes, every reply, each on its own row with is_reply set to yes and the ID and author of the comment it answers.
Are live chat messages included?
No. Live chat is separate from the comments under a video. Only comments and their replies are exported.
Why does the username column show a code starting with UC?
That commenter has no @handle, so the row carries the channel ID, which is unique. Open youtube.com/channel/ followed by that ID to see the channel.