Analyze Your X Followers in Google Sheets

Open X Followers Exporter Pro while logged into your X account. The extension will begin loading your followers list:

1. Click the extension icon in your Chrome toolbar to open the panel
2. Wait for the extension to finish loading your followers — for large accounts this may take a few minutes as it paginates through all followers
3. Optionally apply filters such as minimum follower count, verified status, or account age to narrow your export
4. Click Export CSV to download the full list

The exported CSV includes username, display name, follower count, following count, verified status, bio, location, and join date for each follower.

Open Google Sheets and create a new spreadsheet named X Followers Analysis. Import your CSV:

1. Go to File → Import
2. Select Upload and drag in your CSV file
3. Set Import location to Replace current sheet or Insert new sheet(s)
4. Set Separator type to Comma and click Import data

Your followers list will populate with one row per follower and a column for each data field. Freeze the header row (View → Freeze → 1 row) before proceeding.

Create a helper column to classify followers by influence tier based on their follower count. In an empty column, use this formula:

=IF(D2>=100000,"Mega",IF(D2>=10000,"Macro",IF(D2>=1000,"Micro",IF(D2>=100,"Nano","Casual"))))

Where column D contains the follower count. Then use Data → Create a filter to filter or sort by tier. This lets you quickly identify:

• Mega/Macro — high-value followers worth engaging directly
• Micro — niche influencers and engaged community members
• Nano/Casual — general audience

Create a separate Dashboard sheet to aggregate metrics from each monthly export tab. Set up a table with columns:

• Date — export date
• Total followers — =COUNTA('2026-03-06'!A2:A)
• Verified followers — =COUNTIF('2026-03-06'!G2:G,"TRUE")
• Avg follower count — =AVERAGE('2026-03-06'!D2:D)
• Mega/Macro followers — count of accounts with 10k+ followers

As you add new monthly export tabs, add a corresponding row to your dashboard. Insert a Line chart on the dashboard to visualize total follower growth and average follower count trend over time.

Filter your followers sheet to extract your most influential followers for direct outreach. Apply filters:

• Follower count ≥ 5,000
• Verified = FALSE (verified accounts rarely engage with DMs from strangers)
• Following count ≤ 2,000 (lower following-to-followers ratio suggests selectivity)

Copy the filtered results to a new sheet called Outreach List. Add columns:

• Outreach Status (Select: Pending / Messaged / Responded / Converted)
• Notes — context for the relationship
• Follow-up Date — when to check back

Use this as your CRM-lite for audience relationship building.