What a CommentCrate comments export looks like
Download a sample, open it in your spreadsheet and look at every column before you install anything.
The sample files
Both files hold the same 25 invented comments from an imaginary giveaway post. We wrote them with the exporter the extension itself uses, so the columns, their order and the formatting are what a real scan gives you.
What the columns mean
idandparentId: every comment has an id. A reply carries the id of the comment it answers inparentId(replies are exported with Pro).authorandtext: the username and the comment as it was written, emoji and accented letters included.likeCount: the likes, when the site shows them.createdAt: the time in UTC, for example 2026-10-12T18:40:00.000Z. YouTube only shows relative times, so a YouTube file has apublishedTextcolumn with values like “2 weeks ago” instead.hiddenandpostUrl: whether the site had hidden the comment, and the address of the post.
Opening it
Double-click the CSV to open it in Excel. If accented letters look wrong, use the import dialog (see fix garbled characters) or open the XLSX instead. In Google Sheets, go to File → Import → Upload, as described in importing comments into Google Sheets.
Replies in the sample
Two of the 25 rows are replies: those are the rows where parentId is filled in. The free plan exports top-level comments only, so in a free export parentId is always empty.
Try it on your own post
How it works and the export guide show the steps. The free plan takes up to 200 comments per post.