Get YouTube comments into Google Sheets

Export the comments as a CSV file below, then import it into Google Sheets. It's a one-time copy, not a live sync, and it takes about a minute.

Step 1: Export the comments as CSV

  1. 1 Copy the YouTube video's link and paste it into the box above.
  2. 2 Choose CSV as the export format and click Extract Comments.
  3. 3 Click Download File to save the .csv file.

Step 2: Import the CSV into Google Sheets

  1. 1 Open Google Sheets and create a blank spreadsheet.
  2. 2 Go to File → Import → Upload and select the CSV you downloaded.
  3. 3 For Import location choose Replace spreadsheet (or Insert new sheet), leave Separator type on Detect automatically, and click Import data.

One-time export or live sync?

ClipComments exportAutomation tools and add-ons
What you getA copy of the comments at that momentA sheet that refreshes on a schedule
SetupNone — paste a linkAn account with the tool, and access to your Google account
CostFreeUsually a subscription
To updateExport againAutomatic

Frequently asked questions

Can the sheet update automatically when new comments arrive?

No. The export is a one-time copy. Export again and re-import to get newer comments.

Will emoji and non-English comments import correctly?

Yes. The CSV is UTF-8, which Google Sheets reads directly.

Why do some comments start with an apostrophe?

Comments that begin with =, +, - or @ get a leading apostrophe so spreadsheets treat them as text instead of running them as formulas.

How many comments can I bring into Sheets?

Up to 5,000 per export.

Related guides