Hashtags · per comment · top list
Export the hashtags used in Instagram comments
Hashtags in comments are a signal most people never look at: campaign tags entrants add to enter, branded tags fans reuse, and topics a community cares about. IGComments extracts them into their own column and ranks the top ones for free. Free up to 200 comments.
Where hashtags show up in comments
On most posts, hashtags in comments are rare, and that is a result in itself. They concentrate in a few situations:
- Hashtag-to-enter giveaways. “Comment with #MyBrandGiveaway to enter.” The tag is how entries are recognised.
- Campaigns and challenges. Fans reuse a branded or event tag in their own comments.
- Communities. Travel, fitness or book accounts often get comments that are mostly topic tags.
- Spam. Strings of unrelated tags, often copied between posts, are a common pattern. See spam patterns in comments.
Hashtags in the post caption are not part of the comment export. This page is about tags written by commenters.
The hashtags column
The hashtags column (column L in the CSV and Excel file) lists every hashtag in the comment text, each starting with #, separated by a space and listed once per comment. Hashtags are written in lower case, so a comment reading “love this #Fall #FALL #cozy” gives #fall #cozy, and counts of one tag are not split by capitalisation. Comments with no hashtag have an empty cell.
The column comes from the comment text. It does not tell you whether a hashtag is popular on Instagram, only how often your commenters used it.
The free top hashtags list
Before you export, the stats panel lists the top hashtags used across all comments on the post, next to unique commenters, most active commenters, most mentioned accounts, top words and questions. For many posts that list is all you need. It is calculated from the comments read, so on a post above the free limit it covers the free preview until the full post is fetched. See the comment analyzer for the rest of the panel.
Count a specific hashtag in a spreadsheet
To count the comments that use one tag, for example for a hashtag-to-enter giveaway, use this in Excel or Google Sheets. It is not case-sensitive, and it counts comments, not uses:
=COUNTIF(L2:L5000, "*#mybrandgiveaway*")
The asterisks match any text before and after the tag. A hashtag can be a prefix of a longer one (#fall would also match #fallfashion), so for exact matching add a space around the cell: =SUMPRODUCT(--ISNUMBER(SEARCH(" #fall ", " "&L2:L5000&" "))).
To keep only the qualifying entries, add a helper column with =ISNUMBER(SEARCH("#mybrandgiveaway", L2)) and filter for TRUE. Combine it with the one per person filter on the results page if each person gets one entry.
A full ranking of hashtags
For more than the top list, split the hashtags into rows and count them. In Google Sheets, with hashtags in column L:
=QUERY(FLATTEN(ARRAYFORMULA(SPLIT(L2:L, " "))), "select Col1, count(Col1) where Col1 is not null group by Col1 order by count(Col1) desc label count(Col1) 'uses'")
In Excel 365, use Power Query: select the column, Split Column, By Delimiter, Space, Into Rows, then Group By the column with a Count Rows operation, and sort descending.
What to do with the result
- Validate a campaign. How many different people used the branded tag, and how many used it once versus repeatedly?
- Find vocabulary. Tags people choose themselves show how the audience names your topic. Reuse them in captions.
- Spot copy-paste tagging. The same long tag string appearing from many accounts is worth a closer look; see analyzing comments without AI for next steps.
Frequently asked questions
Does the export include hashtags from the post caption?
No. The hashtags column covers hashtags written in comments and replies, not the caption.
Is a repeated hashtag in one comment counted twice?
No. Each hashtag is listed once per comment in the column.
Can I find the most used hashtag in the comments?
Yes. The free stats panel shows the top hashtags. For a longer ranking, split the hashtags column into rows and count them.
Can I count entries for a hashtag-to-enter giveaway?
Yes. Count rows whose hashtags column contains your tag, and optionally keep one comment per person with the one-per-person filter.
Are hashtags case-sensitive?
On Instagram they are not. The hashtags column is written in lower case, so #Fall and #fall are counted as the same tag.