CommentCrate ENTRESFR

How to import Instagram, YouTube or TikTok comments into Google Sheets

Export the file, bring it into Sheets, and a few formulas answer most questions.

Importing the file into Google Sheets

  1. Export the comments from CommentCrate as CSV or XLSX. XLSX is the safer choice because there is no encoding or separator to get wrong.
  2. In Google Sheets, go to File → Import → Upload and pick the file.
  3. Choose whether to add a new sheet or create a new spreadsheet, make sure the separator is a comma, and press Import data.

Which column is which

The export has these columns, in this order: id (A), parentId (B), author (C), text (D), likeCount (E), createdAt (F), hidden (G), postUrl (H). Check them against your header row before you use the formulas below. More in the export guide.

Formulas worth having

Try each one on a few rows first. If your spreadsheet is set to another locale, use semicolons instead of commas between arguments.

  • Every commenter once: =UNIQUE(C2:C)
  • Comments per person, most active first: =QUERY(A:H,"select C, count(C) where C is not null group by C order by count(C) desc label count(C) 'comments'",1)
  • Most liked first: =SORT(A2:H,5,FALSE)
  • The time as a date. This shifts UTC to UTC+3, so change the 3 to your own offset, then format the column as Date time: =DATEVALUE(LEFT(F2,10))+TIMEVALUE(MID(F2,12,8))+TIME(3,0,0)

About the data

CommentCrate does not upload your comments, but once you import the file it sits in your Google account. The comments belong to the people who wrote them, so use the sheet for what you need and delete it when you are done.

Where to go next

For charts and common words, see comment analysis. If characters look broken, this page fixes it. For a giveaway you can pick a winner with a formula or use the giveaway picker.

More guides

See pricing