An Instagram follower list compare task needs two comparable lists and a clear definition of the difference you want. Comparing followers with following finds current nonreciprocal relationships. Comparing an earlier follower list with a later follower list finds observed arrivals and departures between snapshots. These are not the same result. This walkthrough uses the second task and shows how to build a small spreadsheet comparison you can check by hand.
Prepare two inputs with matching scope
Use lists for the same account and relationship direction. Name one Earlier and the other Later, and preserve the source and observation information for each. Confirm that both are complete enough for the intended comparison. If one is capped, filtered or interrupted, record that limitation before interpreting differences as audience changes. See the export preparation guide for organizing the original files.
Keep the raw data unchanged and work in copied sheets. Place one identifier per row with a header in row one. Stable account identifiers are preferable when the source provides them. If you only have usernames, use them consistently and maintain a separate exception list for suspected name changes. A display name is not a reliable key because different accounts can use the same visible label.
Clean the keys consistently
Remove surrounding spaces and use the same treatment of a leading @ in both tables. Keep an original-value column so the transformation is reviewable. Deduplicate exact keys in the working copy and count the removed duplicates. Do not combine punctuation variants just because two handles look similar; a period or underscore may distinguish different accounts.
For a small project, you can inspect the cleaned keys directly. For larger lists, preserve a short cleaning log describing the steps and counts. If an imported identifier was converted into a number or scientific notation, return to the original data and import it as text. Comparing damaged keys can produce a perfectly calculated answer to the wrong question.
Mark additions with an exact membership check
Assume the Earlier keys occupy A2:A1000 and the Later keys occupy A2:A1000 on their respective sheets. In the Later sheet, use a COUNTIF check against the Earlier keys to label entries found zero times as newly present. For example, =IF(A2="","",IF(COUNTIF(Earlier!$A$2:$A$1000,A2)=0,"Newly present","Present in both")) expresses the logic. Adjust ranges and separators to your spreadsheet and dataset.
This formula assumes clean, nonblank keys and a source where the key comparison is appropriate. Some spreadsheet functions interpret wildcard characters, so inspect unusual identifiers rather than applying the formula blindly. Copy the formula down only through the relevant rows, then spot-check a few “newly present” results against the Earlier sheet. Formula output is a working label until the inputs are verified.
Mark departures in the opposite direction
On the Earlier sheet, check each key against the Later keys. Entries with zero matches are newly absent from the later observation. Keep that list separate from additions. Do not call a missing entry a confirmed intentional unfollow without considering source coverage and account identity changes. The spreadsheet establishes a difference between lists, not the motivation behind it.
Count entries present in both sets as retained observed members. After deduplication, the totals should reconcile: earlier unique members plus additions minus departures equals later unique members. If they do not, investigate blank rows, range boundaries, duplicate handling and formula fill before inventing an explanation about Instagram. This arithmetic check catches errors that a quick glance at the final lists can miss.
Worked example: a comparison you can verify manually
Let Earlier contain @alder, @birch, @cedar and @dahlia. Let Later contain @birch, @cedar, @elm, @fern and @ginkgo. The new set has three additions: @elm, @fern and @ginkgo. The absent set has two entries: @alder and @dahlia. Two accounts remain in both snapshots. The unique total moves from four to five, matching four plus three minus two.
Now imagine that the Later import accidentally includes @elm twice. The raw row count becomes six, but the unique total remains five. If you report the raw count, your reconciliation appears to fail. This example shows why deduplication and a raw-versus-unique count belong in the worksheet. The problem is not the set comparison; it is the meaning assigned to the imported rows.
Report the result with its limits
Use a compact summary containing the account, direction, source dates, unique totals, additions, departures and coverage notes. Keep suspected handle changes in an exceptions section. Label the time range as the interval between comparable observations unless the source establishes event times. An account could enter and leave between snapshots without appearing in the difference lists, so the result is not a complete action history.
The sample following timeline illustrates how an interval differs from a precise timestamp. For reporting incoming campaign changes, read Instagram recent followers. You can apply this spreadsheet method to authorized records, but the present website does not upload, store or compare your real account files for you.
Comparison questions
What does following minus followers tell me?
It identifies accounts you follow that are absent from your current follower list, assuming comparable complete inputs. They may never have followed you. That result is not a historical unfollower list.
What if a username changed between exports?
Use a stable identifier if available. Otherwise flag the possible change for review instead of automatically counting one departure and one addition as two different people.
Can I use partial lists for a quick estimate?
You can compare the observed subsets, but label them as partial. Do not extrapolate complete audience changes without a defensible sampling method. A larger-looking spreadsheet does not repair missing coverage.