What is in the file
One row per top-level comment, newest first, with these columns:
comment_id: YouTube’s ID for the commentpublished_atandupdated_at: UTC timestamps in ISO 8601 formatauthorandauthor_channel_url: the public name and channel linklike_countandreply_counttext: the comment as plain textcomment_url: opens the comment on YouTube
Cells that start with =, +, - or @ are prefixed with an apostrophe so a spreadsheet never runs a comment as a formula.
CSV or JSON?
Choose CSV for Excel, Numbers or Google Sheets. Choose JSON if you are writing code; it also includes the video details and when the data was fetched.
Handle exports with care
Comments include people’s public names. Keep exports for as long as you need them for your analysis and then delete them. Do not use them to track or contact individual commenters.
Questions
How do I download YouTube comments to Excel?
Load the video, press Download CSV, then open the file in Excel. The file is UTF-8 with a byte-order mark, so emoji and accents display correctly.
How do I get YouTube comments into Google Sheets?
Download the CSV, then in Google Sheets choose File, Import, Upload and pick the file.
How many comments can I export?
The free export includes the newest 1,000 top-level comments of a video.
Are replies included?
Not yet. The export contains top-level comments with their reply counts.
Can I use the exported comments however I like?
The comments belong to the people who wrote them. Use exports for your own analysis, respect people’s privacy, and delete copies you no longer need.
Comments come from YouTube API Services and are held only in a short-lived cache (under 24 hours). By using this tool you agree to the YouTube Terms of Service. Read the privacy policy and the Google Privacy Policy.