CommentsToSheets

Spreadsheet guides

Getting the comments out is the first minute. These guides cover the next hour: importing cleanly, the formulas that answer real questions, and how to check that a file holds every comment.

How to chart Instagram comments per day

Turn the UTC timestamps of an Instagram comment export into local dates, count comments per day and per hour with a pivot table or QUERY, and chart when your audience talks.

How to check an Instagram comment export is complete

Five checks that tell a complete export from a partial one in a minute: row count, reply count, date span, top-level versus replies, and a spot check against the post.

How to clean Instagram comments in a spreadsheet

Strip @mentions and emoji, normalise case and spaces, flag questions and keep the words that matter, with SUBSTITUTE, REGEXREPLACE, TRIM and LOWER in Excel and Google Sheets.

How to find your regular commenters across posts

Stack the comment exports of several Instagram posts in one sheet and find the people who comment on most of them, with a pivot table, COUNTUNIQUE and a simple loyalty score.

How to import Instagram comments into Google Sheets

The import steps that keep comment IDs, emoji and dates intact, then the starter formulas: COUNTIF for mentions, UNIQUE for commenters, a pivot by day.

How to pick a giveaway winner in a spreadsheet

From exported comments to a fair entry list and a random winner with RANDBETWEEN or a RAND sort, plus the record-keeping that makes a spreadsheet draw defensible, and when a seeded draw is the better choice.

Why the row count and Instagram's count differ

Instagram's comment count includes comments nobody can see: spam-filtered, hidden-word, restricted and some deleted ones. What gap is normal, what gap is not, and what to do about each.