Tag-a-friend giveaways · who tagged whom
Export every @mention from Instagram comments
Tag-a-friend giveaways turn the comment section into a list of pairs: the person who commented and the accounts they tagged. IGComments gives you a mentions column for every comment, a filter for comments that tag someone, and a stats list of the most mentioned accounts. Free up to 200 comments.
What the mentions column contains
For every comment, the mentions column lists each @username that appears in the comment text, separated by a space, in lower case, and with each name listed once even if it was typed twice. A comment reading “@sam.rivera you need this @jo_kim” has @sam.rivera @jo_kim in that column. A comment with no tags has an empty cell.
The mentions column is read from the comment text, so it reflects what the commenter typed. IGComments does not check whether a tagged account exists or whether the tag was a working link.
Replies work the same way. In a thread, a reply usually starts with an @mention of the person being answered. That is why the replies filter and the mentions filter are worth combining; see below.
Filter to comments that tag someone
Before exporting, switch on the has @mentions filter. The results list, the stats and the download then cover only comments with at least one tag. Useful combinations:
- Top-level + has @mentions: the entries to a tag-a-friend giveaway, without the replies where people answer each other.
- Replies + has @mentions: people pulling someone into a thread, and the account owner answering by name.
- One per person + has @mentions: one qualifying entry per commenter.
If a rule says “tag two friends”, the filter finds comments with at least one tag, not at least two. Counting tags per comment is a spreadsheet job, shown next.
Count tags per comment in a spreadsheet
The mentions column is column K in the CSV and Excel file. Number of tags in the cell, in both Excel and Google Sheets:
=IF(K2="", 0, LEN(TRIM(K2)) - LEN(SUBSTITUTE(TRIM(K2), " ", "")) + 1)
That counts the spaces between names and adds one. Filter the new column for 2 or more and you have every comment that tagged at least two accounts. Because each name is listed once per comment, someone who types the same friend twice counts as one tag.
Turn one row into one tag: who tagged whom
To get a clean two-column list of commenter and tagged account, you need one row per tag. The simplest route in current versions of Excel (365) and Google Sheets is to split the cell and reshape.
Google Sheets. Put this in an empty cell. It returns a list of pairs for every comment on the sheet, with column C as the commenter and K as the mentions:
=QUERY(ARRAYFORMULA(SPLIT(FLATTEN(C2:C&"|"&SPLIT(K2:K," ")),"|")),"select * where Col2 is not null")
If your sheet gives an error, use the other route: copy the mentions column, then Data, Split text to columns on the space, and use a pivot table on the result.
Excel 365. In Power Query (Data, From Table/Range), select the mentions column and choose Split Column, By Delimiter, Space, Into Rows. The username stays on each row. Close and load, and you have one row per commenter and tag.
Once you have pairs, a pivot table with the tagged account in Rows and a count of rows in Values gives the most tagged accounts. The free stats panel already lists the most mentioned accounts for the post, so use the pivot only when you need more than the top list.
Checks that matter for a giveaway
- Self-tags. Compare the commenter with the tagged names. A row where
usernameequals a name inmentionsis someone tagging themselves. - The same friend over and over. If a single account is tagged by dozens of different commenters, look at those comments. It may be a popular account, or it may be a pattern worth a look.
- Tags of the host account. Many people tag the account running the giveaway. Search for the host’s username and decide whether your rules count that.
- Rules about replies. If tags in replies do not count, filter to top-level only first.
For the draw itself, Pickfetti picks a verifiable random winner from the same comments. For a fuller giveaway workflow, see exporting giveaway comments.
Limits
The export reads public comments. Comments that Instagram does not serve to anyone, such as spam-filtered, hidden-word filtered and restricted comments, are not in the file, and some tag-a-friend entries may be among them. Mentions inside an image or a Story are not comments and are not included. Mentions in the post caption are not in the comment export either.
Frequently asked questions
Can I export only the comments that tag someone?
Yes. Turn on the @mentions filter before downloading and the file contains only comments with at least one @mention.
Is each tagged account listed once per comment?
Yes. If a commenter types the same @username twice in one comment, it appears once in the mentions column.
Can I see which accounts were tagged the most?
Yes. The stats panel lists the most mentioned accounts. For a longer list, split the mentions column into rows and count them with a pivot table.
Does the export check that the tagged accounts exist?
No. The mentions column is read from the comment text.
Are tags in replies included?
Yes. Replies are exported with their own mentions column, and you can filter to replies only or top-level only.