I Got Tired of Manually Copying Instagram Comments Into Spreadsheets. Here's What I Use Instead.

chloe chen — Tue, 09 Jun 2026 02:37:07 +0000

Let me describe a workflow I used to have.
Open Instagram post. Scroll to comments. Copy comment text. Switch to spreadsheet. Paste. Note the username. Go back. Scroll down. Repeat. For two hours.
I was doing this to collect comment data for a side project — basic NLP work, sentiment tagging, nothing fancy. Just needed the text in a CSV. It was the most boring two hours I'd spent in front of a computer in a long time, and I knew somewhere in the back of my mind that this was a solved problem I just hadn't looked up yet.
So I looked it up.

**The Actual Problem

Instagram has no public API for comment extraction. This is the source of most of the pain.
If you've tried to build around this with Python, you know the drill: requests gets you blocked almost immediately. Selenium works briefly before Instagram's bot detection catches on. The headless browser detection Instagram runs looks at TLS fingerprints, JavaScript execution context, request interval regularity — stuff that's hard to spoof convincingly at the client layer without significant ongoing maintenance.
The detection isn't looking for "are you using requests" — it's looking for behavioral and fingerprint signals that distinguish real browser sessions from simulated ones. That distinction matters for how you think about solving the problem.

Why a Browser Extension Is Architecturally Interesting Here
A Chrome extension runs inside a real browser process. Not a headless simulation, not a Python session pretending to be a browser — an actual Chrome instance with real:

User-Agent strings
TLS fingerprints
Cookie and session context
JavaScript execution environment

From Instagram's infrastructure perspective, traffic from a Chrome extension is structurally identical to traffic from a person manually scrolling through comments. There's nothing to detect because there's nothing being faked.
This is the core reason browser-based collection is more reliable for this specific use case than server-side approaches. It's not cleverer bot evasion — it's just not triggering the detection in the first place.
The secondary property worth noting: everything runs locally. The data goes from Instagram's servers directly to your machine. No intermediate server, no third-party database, no data leaving your browser environment. For any project handling user data or working under privacy constraints, that architecture is meaningfully better than cloud-based alternatives.

**The Tool
The extension I landed on is Instagram Comments Scraper.
The workflow is about as minimal as it gets:

Click extension icon in Chrome toolbar

Click "Export Instagram Data" → opens option page

Paste the Instagram post URL

Click "Start Parsing"

Download CSV or Excel when complete

Output structure per row:

id | unique comment identifier
text | full comment text
username | commenter's handle
profile_url | link to their profile
profile_pic_url| avatar URL
date | timestamp
Clean enough to load directly into pandas without any preprocessing:
pythonimport pandas as pd

df = pd.read_csv('instagram_comments.csv')

Immediate usability

print(df.shape)
print(df['text'].head(10))

Basic frequency pass

from collections import Counter
import re

words = []
for comment in df['text'].dropna():
words.extend(re.findall(r'\b\w+\b', comment.lower()))

print(Counter(words).most_common(20))

**Rate Limit Handling — The Part Worth Looking At
**Instagram rate-limits comment loading. The thresholds aren't documented and vary by IP. Any tool that ignores this will fail on large posts.
The extension handles it with what amounts to adaptive exponential backoff:
Normal Mode
→ rate limit detected
Cooldown Mode (countdown timer displayed, no requests sent)
→ timer expires, retry
├── success → back to Normal Mode
└── failure → cooldown period × 2 → repeat

This is the same pattern you'd implement if you were building against any undocumented API with dynamic rate limits. The doubling cooldown matters because fixed-wait approaches fail when the restriction window is longer than your fixed interval. Exponential backoff converges regardless of where the actual limit sits.
Practically: you can start a collection job on a post with several thousand comments, minimize the browser, and come back to a completed file. No babysitting, no manual restarts, no incomplete datasets.

**What I Actually Did With the Data
For my use case — basic sentiment analysis on a niche topic — the workflow after export was:
pythonimport pandas as pd
from textblob import TextBlob

df = pd.read_csv('instagram_comments.csv')
df = df.dropna(subset=['text'])

Quick sentiment pass

df['polarity'] = df['text'].apply(
lambda x: TextBlob(str(x)).sentiment.polarity
)
df['sentiment'] = pd.cut(
df['polarity'],
bins=[-1, -0.1, 0.1, 1],
labels=['negative', 'neutral', 'positive']
)

print(df['sentiment'].value_counts())
print(df.groupby('sentiment')['text'].head(3))
Not production NLP. But for a side project where I just needed to understand the rough distribution of responses to a specific post, it was more than sufficient — and the data collection that would have taken hours took about four minutes.

Limitations Worth Being Honest About
Chrome only. Chromium-based browsers work. Firefox doesn't.
Volume ceiling. Posts with 50k+ comments will finish, but the rate limit cooldowns add up. Large jobs are better left running overnight.
Frontend dependency. Like any tool that doesn't use an official API, it depends on Instagram's current HTML structure. Instagram updates its frontend; the extension may need updates in response. This is a shared limitation of every non-API approach.
Public posts only. Private account content is inaccessible. Expected behavior, but worth stating.

When This Is and Isn't the Right Tool
Good fit:

Side projects and personal research
One-off data collection tasks
Small team audience analysis without enterprise budget
Influencer evaluation before a campaign
Quick competitive comment audits

Not the right fit:

Production data pipelines that need to run on a schedule
Multi-account or multi-post parallel collection at scale
Teams that need API-level reliability guarantees

For anything in the second list, you're looking at a proper scraping infrastructure with proxy rotation, or paying for a social data API. The extension fills the space below that threshold — and that space is where most individual developers and small teams actually live.

One Other Thing
The extension doesn't ask for your Instagram password. It doesn't access your account, your feed, your DMs, or anything connected to your profile. It reads public comment data from the URL you provide and nothing else.
I checked this the obvious way — opened DevTools Network tab, watched the traffic while it ran. No outbound requests to any third-party endpoint. Everything stays local.
For a tool interacting with a social platform, that's worth verifying before you install it.

Anyway. That's the tool. If you're doing any kind of Instagram data work and still copying things by hand, there's a better option. The Instagram Comments Scraper extension has been reliable for what I needed — hopefully it's useful for someone else's project too.
Happy to discuss the rate limit handling approach or alternative architectures for this problem in the comments if anyone's interested.

DEV Community: chloe chen

I Got Tired of Manually Copying Instagram Comments Into Spreadsheets. Here's What I Use Instead.

Immediate usability

Basic frequency pass

Quick sentiment pass