You can export Telegram group members to CSV using Telegram Scrap. Paste your group URL, run the extraction, download the file - done in under 5 minutes.

No Python scripts. No API keys to configure. No risk of getting your account banned. Just a clean, structured file ready for your CRM, outreach tool, or spreadsheet.

What You Get in the CSV

Before we walk through the steps, here is exactly what the exported file contains:

user_id	first_name	last_name	username	phone	role
123456789	Mikhail	Petrov	mikhail_p	+79001234567	member
987654321	Sarah	Connor	sarahc		admin
555000111	John	Doe	johndoe_tg	+14155552671	member
334455667	Ana	Lima		+5521987654	member
112233445	Kevin	Tran	kevintran		member

Column breakdown:

user_id - Telegram's unique numeric ID for each account. Stays the same even if the user changes their username.
first_name / last_name - Display name as set by the user. Always present.
username - The @handle. Optional on Telegram, so many users leave it blank.
phone - Only visible if the user has made their number visible in their Telegram privacy settings. Captured when available.
role - Whether the user is a member, admin, or creator in the group.

The Full Member Extract includes all columns for up to 10,000 members. The Admin Extract returns only users with admin or creator roles. Both are included in all subscription plans.

Step-by-Step: How to Export Telegram Group Members

Step 1 - Open Telegram Scrap

Go to telegramscrap.com and sign in to your account. If you do not have one, registration takes about 30 seconds.

Step 2 - Paste the Group URL or Username

In the extraction dashboard, paste your target group's public link (e.g., t.me/yourcommunity) or just the @username. Private groups require you to be a member - Telegram Scrap uses the official API, which means it operates within the same access rules as the regular app.

Step 3 - Choose Your Extraction Type

Select either:

Admin Extract - Pulls only admins and the group creator. Fast, ideal for finding who runs a community.
Full Member Extract - Pulls all members, up to 10,000 users. This is the option for lead generation.

Both types are included in all plans.

Step 4 - Run the Extraction

Click Start Extraction. Depending on group size, this takes 30 seconds to 3 minutes. You will see a live progress indicator. Telegram Scrap respects API rate limits automatically - you do not need to worry about flooding or triggering Telegram's anti-spam systems.

Step 5 - Download Your CSV

When extraction completes, click Download CSV. The file is UTF-8 encoded, comma-separated, and opens correctly in Excel, Google Sheets, LibreOffice, and any CRM import tool.

How to Open the CSV in Excel and Google Sheets

This is the step that trips people up most often. CSV files sometimes open as a single column of garbled text if you double-click them directly.

Excel (Windows)

Open Excel and go to Data → Get External Data → From Text/CSV (or Data → Get Data → From File → From Text/CSV in newer versions).
Select the downloaded file.
Make sure the delimiter is set to Comma and encoding is UTF-8.
Click Load.

Every column - user_id, first_name, username, phone, role - will appear in its own column with a proper header row.

Google Sheets

Open Google Sheets and go to File → Import.
Upload the CSV file.
Choose Comma as the separator type.
Select No for converting numbers (to preserve phone numbers with leading +).
Click Import data.

Done. Phone numbers like +79001234567 will not be mangled into scientific notation.

How to Filter Your Leads in the CSV

Once your data is in a spreadsheet, filtering turns a raw list into a usable lead pipeline.

In Google Sheets or Excel:

Click any cell in the header row.
Go to Data → Create a filter (Sheets) or Data → Filter (Excel).
A dropdown arrow appears on each column header.

Useful filters to apply immediately:

Filter by phone - Click the dropdown on the phone column, select Filter by condition → Is not empty. This isolates members who have public phone numbers, your warmest leads.
Filter by role - Show only admin entries to find group managers. These are often the decision-makers for B2B outreach.
Filter by username - Remove blanks to keep only users you can actually contact via Telegram @mention.

For more advanced segmentation, copy the filtered results to a new sheet and import directly into your outreach tool or CRM (HubSpot, Pipedrive, Apollo, and Instantly all accept CSV uploads).

Frequently Asked Questions

Q: Will I get every member's phone number?

A: No - and this is true of any tool that uses the official API. Telegram lets users hide their phone number in privacy settings. Telegram Scrap captures phone numbers only when a member has set them to public. In active community groups, expect 20–40% of members to have a visible number.

Q: Is there a free trial?

A: Yes - all plans include a 30-day free trial. No charge until the trial ends. Extractions are included in your monthly plan quota, so there are no per-extraction fees.

Q: Can I export members from a private group?

A: Yes, as long as your Telegram account is a member of that group. Telegram Scrap uses your account credentials via the official API, so it has access to everything your account can see. If your account cannot see the group's member list, neither can Telegram Scrap.

Ready to Export?

Start your 30-day free trial - no charge until the trial ends.

You get a clean CSV with names, usernames, phone numbers, and roles for up to 10,000 members per extraction. No coding required. Plans start at $29/month.

Start your extraction on Telegram Scrap →