Blog

What Every Column in Your Instagram Follower Export Means

3 min read

Key takeaways

  • Username is the only stable identifier for humans; user ID is the stable one for machines. Usernames can change; the numeric user ID never does. Keep both.
  • Full name is user-entered and often blank. It's a display field people can set to anything or leave empty. Don't rely on it for matching.
  • The private and verified flags are snapshots. They were true at export time. Someone can flip their account private or lose a verified badge the next day.
  • Profile URL is just the username in a link. https://instagram.com/username. Useful for click-through, carries no extra data.
  • Bio, email, phone and website need a per-profile lookup. They're not in the basic list. And public email/phone exist only on business and creator accounts that chose to publish them — expect them on a minority of rows.

Open a follower export and you get a handful of columns. Here's what each one actually is, how much to trust it, and why the interesting-looking fields are usually empty.

The columns in every export

username — the @handle, without the @. This is what you use to find someone, and it's the field most tools key on. One catch: usernames can be changed. If you're comparing two exports taken months apart, someone who renamed their account will look like they left and a new person joined.

full_name — the display name a user sets in their profile. It's free text, it's optional, and a large share of accounts leave it blank or set it to something unhelpful ("🦋", a business tagline, an emoji string). Fine for skimming a list to recognise people; don't use it for matching or deduplication.

user_id (sometimes pk or id) — a permanent numeric identifier Instagram assigns when the account is created. Unlike the username, it never changes. If you plan to compare exports over time — tracking who unfollowed, who's new — this is the column to match on, not the username. It's also roughly chronological: lower IDs are older accounts.

is_private — whether that follower's own account was private at the moment you exported. A point-in-time snapshot; someone can flip it the next day. Useful as a filter (e.g. "which of my followers are businesses" tends to correlate with public).

is_verified — the blue check, as of export time. Same caveat: verification is granted and removed, so an old export's flags can be stale.

profile_url — just https://instagram.com/username. It carries no information the username doesn't; it's there so you can click straight through from a spreadsheet. If your tool omits it, you can build it yourself with ="https://instagram.com/"&A2.

The columns that need a separate lookup

The basic follower list does not include bios or contact details. Those live on each individual profile, so a tool has to fetch every profile one by one — slower, and more rate-limit expensive. Tools call this mode "detailed lookup" or "enrichment," and it's typically a paid feature because it costs real request budget.

When you do run it, expect:

biography — the bio text. Present on most active accounts. Genuinely useful for filtering an audience by keyword.

category — the business/creator category label ("Digital creator", "Clothing store"). Only on accounts that set up a professional profile.

public_email, public_phone, external_url — the contact button fields on a business or creator profile. This is the part everyone over-expects. Personal accounts have none of these. Only business and creator accounts have a contact button, and only if the owner filled it in. On a general follower list, a fill rate of 5–20% is normal; a niche B2B audience might hit 40%. A tool promising "email for every follower" is not being honest about how Instagram works.

ListLift's detailed lookup states this yield openly on the results screen rather than implying every row will have contact data. See ListLift.

Putting it together

ColumnStable?Trust for matching?Notes
usernameNo (renameable)OK short-termThe human-readable key
user_idYes, permanentYesUse this to compare exports over time
full_nameNo, user-setNoOften blank or decorative
is_privatePoint-in-timeSnapshot at export
is_verifiedPoint-in-timeSnapshot at export
profile_urlDerivedJust the username in a link
biographyChanges freelyNoLookup-only; good for filtering
public_email / phone / urlLookup-only; business/creator accounts only, mostly blank
FAQ

Questions this comes up with

Skip the manual work — use ListLift

Follower & Following Exporter — see the real count before you export.