Export YouTube Comments to Excel/Google Sheets

To export YouTube comments to Excel or Google Sheets, use a free comment extractor like NoteLM.ai to download comments as a CSV file, then open directly in Excel or import into Google Sheets. The exported data includes usernames, comment text, timestamps, and like counts—all ready for filtering, sorting, and analysis.

Key Takeaways

• Export YouTube comments as CSV for direct Excel compatibility
• Google Sheets can import CSV via File > Import
• Exported data includes: username, text, likes, timestamp, reply info
• Use Excel formulas for sentiment analysis and keyword counting
• Create pivot tables for engagement metrics
• Clean data by removing spam and formatting timestamps

Step-by-Step: Export to Excel

Step 1: Extract Comments

Using NoteLM.ai Comment Extractor:

1. 1.Copy the YouTube video URL from your browser
2. 2.Visit NoteLM.ai YouTube Comment Extractor
3. 3.Paste the URL and click "Extract Comments"
4. 4.Wait for processing (2-60 seconds depending on volume)
5. 5.Click "Download Excel" or "Download CSV"

Step 2: Open in Excel

For .xlsx files:

• Double-click the downloaded file
• Excel opens automatically with formatted data

For CSV files:

• Open Excel
• File > Open > Select your CSV file
• OR double-click the CSV file (may open directly)

Step 3: Format the Data

If CSV doesn't display correctly:

1. 1.Open Excel with blank workbook
2. 2.Go to Data > From Text/CSV
3. 3.Select your CSV file
4. 4.Choose delimiter (usually comma)
5. 5.Preview data and click Load

Understanding the Excel Columns

Step-by-Step: Export to Google Sheets

Step 1: Extract Comments as CSV

Same process as Excel—use NoteLM.ai to extract and download as CSV.

Step 2: Import to Google Sheets

Method 1: Upload directly

1. 1.Open Google Sheets (sheets.google.com)
2. 2.Create new spreadsheet or open existing
3. 3.File > Import > Upload
4. 4.Drag your CSV file or click "Select a file"
5. 5.Choose import location:

- Replace spreadsheet

- Insert new sheet

- Replace data at selected cell

1. 1.Click "Import data"

Method 2: Open with Google Sheets

1. 1.Upload CSV to Google Drive
2. 2.Right-click file > Open with > Google Sheets

Step 3: Auto-Detect Formatting

Google Sheets usually auto-detects:

• Column separators (commas)
• Date formats
• Number formats

If data appears in single column:

• Select the column
• Data > Split text to columns
• Choose separator (comma)

Data Cleaning Techniques

Remove Duplicate Entries

Excel:

1. 1.Select all data
2. 2.Data > Remove Duplicates
3. 3.Select columns to check (usually Author + Text)
4. 4.Click OK

Google Sheets:

1. 1.Select data range
2. 2.Data > Data cleanup > Remove duplicates
3. 3.Choose columns to analyze

Format Dates

Excel formula (if dates are text):

=DATEVALUE(LEFT(E2,10))

Google Sheets formula:

=DATEVALUE(LEFT(E2,10))

Clean Comment Text

Remove extra spaces:

=TRIM(C2)

Remove line breaks:

=SUBSTITUTE(C2,CHAR(10)," ")

Handle encoding issues:

• File > Save as > CSV UTF-8
• Re-import with UTF-8 encoding

Useful Excel Formulas for Analysis

Count Total Comments

=COUNTA(C:C)-1

(Subtracts 1 for header row)

Count Unique Commenters

Excel:

=SUMPRODUCT(1/COUNTIF(B2:B1000,B2:B1000))

Google Sheets:

=COUNTUNIQUE(B2:B1000)

Total Likes

=SUM(D:D)

Average Likes per Comment

=AVERAGE(D2:D1000)

Count Comments with Keyword

=COUNTIF(C:C,"*keyword*")

Find Comments with Questions

=COUNTIF(C:C,"*?*")

Calculate Comment Length

=LEN(C2)

Count Words in Comment

=LEN(TRIM(C2))-LEN(SUBSTITUTE(C2," ",""))+1

Creating Analysis Dashboards

Pivot Table for Engagement Metrics

Excel:

1. 1.Select all data
2. 2.Insert > PivotTable
3. 3.Create in new worksheet
4. 4.Drag fields:

- Rows: Published Date (group by month)

- Values: Count of Comments, Sum of Likes

Google Sheets:

1. 1.Select all data
2. 2.Insert > Pivot table
3. 3.Add rows: Published Date
4. 4.Add values: COUNTA of Comment Text, SUM of Likes

Chart: Comments Over Time

1. 1.Create pivot table grouped by date
2. 2.Select date and comment count columns
3. 3.Insert > Chart
4. 4.Choose Line chart
5. 5.Format with titles and labels

Chart: Top Commenters

1. 1.Create pivot table with Author as rows
2. 2.Add count of comments as values
3. 3.Sort descending
4. 4.Select top 10 rows
5. 5.Insert > Chart > Bar chart

Advanced Analysis Techniques

Sentiment Keywords

Create columns for sentiment indicators:

Positive sentiment (Column I):

=IF(SUMPRODUCT(--ISNUMBER(SEARCH({"great","love","awesome","amazing","helpful","thanks"},C2)))>0,"Positive","")

Negative sentiment (Column J):

=IF(SUMPRODUCT(--ISNUMBER(SEARCH({"bad","hate","awful","terrible","waste","useless"},C2)))>0,"Negative","")

Overall sentiment (Column K):

=IF(I2="Positive","Positive",IF(J2="Negative","Negative","Neutral"))

Extract Timestamps Mentioned

Find comments mentioning timestamps (1:23 format):

=IF(SUMPRODUCT(--ISNUMBER(FIND(":",C2)))>0,"Has Timestamp","")

Comment Length Categories

=IF(LEN(C2)<50,"Short",IF(LEN(C2)<200,"Medium","Long"))

Engagement Score

Create a custom engagement score:

=D2*10 + IF(G2="TRUE",5,0)

(Likes × 10 + bonus for replies)

Google Sheets-Specific Features

QUERY Function for Filtering

Get comments with 100+ likes:

=QUERY(A:H, "SELECT B, C, D WHERE D >= 100 ORDER BY D DESC")

Get comments from specific date range:

=QUERY(A:H, "SELECT * WHERE E >= date '2026-01-01' AND E <= date '2026-01-31'")

Get comments containing keyword:

=QUERY(A:H, "SELECT * WHERE C CONTAINS 'tutorial'")

FILTER Function

Filter top comments:

=FILTER(A2:H, D2:D>=50)

Filter questions:

=FILTER(A2:H, REGEXMATCH(C2:C, "\?"))

REGEXMATCH for Patterns

Find email addresses in comments:

=REGEXMATCH(C2, "[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}")

Find URL links:

=REGEXMATCH(C2, "https?://")

Common Issues and Solutions

Issue: CSV Opens as Single Column

Solution (Excel):

1. 1.Open Excel
2. 2.Data > From Text/CSV
3. 3.Select "Delimited" in wizard
4. 4.Check "Comma" as delimiter
5. 5.Complete import

Solution (Google Sheets):

1. 1.Select single column
2. 2.Data > Split text to columns
3. 3.Choose "Comma" as separator

Issue: Special Characters Display Wrong

Solution:

1. 1.Open CSV in text editor (Notepad++)
2. 2.Convert to UTF-8 encoding
3. 3.Save and re-import

Issue: Dates Not Recognized

Solution (Excel):

1. 1.Select date column
2. 2.Data > Text to Columns
3. 3.Choose Date format (YMD, MDY, etc.)

Solution (Google Sheets):

1. 1.Select date column
2. 2.Format > Number > Date
3. 3.OR use DATEVALUE formula

Issue: Numbers Formatted as Text

Solution:

1. 1.Select like count column
2. 2.Multiply by 1: =B2*1
3. 3.OR use VALUE function: =VALUE(B2)

Automation Ideas

Google Sheets + Apps Script

Automate regular exports with Google Apps Script:

function importYouTubeComments() {
  // This is a template - actual API integration required
  var sheet = SpreadsheetApp.getActiveSheet();
  // Add your comment extraction logic here
  // Update sheet with new data
}

// Set up daily trigger
function createTrigger() {
  ScriptApp.newTrigger('importYouTubeComments')
    .timeBased()
    .everyDays(1)
    .create();
}

Excel Power Query

Set up automatic data refresh:

1. 1.Data > Get Data > From File > From CSV
2. 2.Transform data as needed
3. 3.Close & Load
4. 4.Set refresh schedule in Data > Refresh All > Connection Properties

Sample Analysis Template

Sheet 1: Raw Data

• All imported comment data
• No modifications

Sheet 2: Summary Metrics

Sheet 3: Analysis

• Sentiment columns
• Length categories
• Engagement scores

Sheet 4: Charts

• Comments over time
• Sentiment breakdown
• Top commenters

Key techniques include: counting unique commenters, analyzing sentiment with keyword matching, creating pivot tables for time-based trends, and using QUERY/FILTER functions for advanced filtering. With your comment data in spreadsheet format, the analysis possibilities are nearly unlimited.

Related Resources:

• YouTube Comment Extractor Guide
• Download YouTube Comments as JSON/CSV
• YouTube Comment Analysis Tools