Social media

How do I export my Instagram followers to a spreadsheet?

TODO for AI · updated

Instagram has an official export: Accounts Center, Your information and permissions, Export your information, then pick Followers and following and set the date range to All time. You get JSON or HTML with usernames and follow dates, for your own account only. To get a usable sheet, convert that file to CSV, or let an agent download, convert and sort it for you.

Do this for me Free plan, no card. It asks before sending or posting anything.

How to do it

  1. Request the file. Instagram app or web: Settings, Accounts Center, Your information and permissions, Export your information, Create export, Export to device. Customize: tick only Followers and following, date range All time, format JSON. Menu labels change now and then.
  2. Wait for the email. Instagram prepares the file and emails a download link. Small accounts are usually quick; large ones can take hours.
  3. Convert to CSV. Large accounts get several files (followers_1.json, followers_2.json and so on). Each entry holds a username, a profile link and the date they followed you. Merge all files and flatten them into three columns.
  4. Sort and compare. Put followers and following side by side to see who does not follow back, who followed this month, or which followers are businesses.

Your options

OptionEffortCatch
Official download, read by handRequest, wait, read JSONNot a spreadsheet
Follower export extensionsInstall, log in through itThird party sees your session; can break Instagram terms
Copy the list by handScroll and copyOnly works for small accounts
TODO for AIOne messageUses the official export, so it waits for Instagram's email

Watch the agent do it

A real run on sample files. Yours starts from here.

I attached my Instagram data export (followers_1.json and following.json). Turn it into a spreadsheet of my followers with the date they followed me, and make a second tab with everyone I follow who does not follow me back.
followers_1.jsonfollowing.json
AI
shellInspect Instagram export files
shellCompare Instagram followers and following lists
shellBuild Instagram follower export spreadsheet
shellShow Instagram followers spreadsheet title
fileinstagram_followers.xlsx

I made the spreadsheet: ~/work/instagram/instagram_followers.xlsx on the cloud computer. It's also shown above in the chat.

Tab 1, "Followers": your 38 followers, each with their username, a clickable profile link and the date and time they followed you. Newest followers are at the top.

Tab 2, "Not following back": 13 of the 43 accounts you follow don't follow you back. Each row has the username, a profile link and the date you followed them, newest first. The top three are natgeo, running.club.bp and luca.chef.

  • Times are in UTC. That's the time zone Instagram uses in the export, so they may be a few hours off from your local time.
  • Followers file: only followers_1.json was in the folder. Instagram splits large follower lists into followers_2.json and so on. Your file has 38 entries, so there's probably only one, but if your export has more, add them to the folder and I'll re-run it.

The script that builds the spreadsheet is build.py in the same folder.

Now yours. Pick a case or write your own:
Runs as your own TODO. Attach your files on the next screen.

FAQ

Can I export the followers of another account?
Not through Instagram's official tools. The official export only covers your own account. Tools that scrape other accounts work against Instagram's terms and get accounts limited.
Does the export include emails or phone numbers?
No. It contains usernames, profile links and the date each person followed you.
How do I see who does not follow me back?
Compare the followers and following lists from the same export. Anyone in following but not in followers does not follow you back.
Is the Download your information file safe to share?
It can contain messages and other personal data if you select everything. Tick only Followers and following when you request it.

Related