How to Export Your Facebook Friends List to a CSV
Most people never think about their Facebook friends list as data. But if you use Facebook for business — networking, outreach, keeping track of clients and prospects — having your friends list in a spreadsheet changes what you can do with it. You can segment it, back it up, and spot patterns you'd never see scrolling.
Why export your friends list
- Backup. If your account is ever restricted or hacked, your network is the hardest thing to rebuild. A CSV is cheap insurance.
- Segmentation. Sort friends by how you know them: clients, prospects, peers, personal. You can't message the right people if you can't see the groups.
- Cleanup prep. Before you remove inactive friends (more on that below), an export lets you review the full list calmly instead of deciding one profile at a time.
Step 1: Install Friend Connector Pro
Facebook doesn't offer a native "export friends to CSV" button. Friend Connector Pro is a Chrome extension that can scan your friends list and export it to a CSV file you can open in Excel or Google Sheets.
Install it from the Chrome Web Store, pin the extension icon so it's easy to reach, and open your Facebook friends page.
Step 2: Run the scan
Open the extension and start the friends scan. It pages through your friends list the way you would by scrolling, but it does it systematically and records each profile: name, profile URL, and available public details. For large lists (a few thousand friends), let it run in the background — don't close the tab mid-scan.
Step 3: Download and open the CSV
When the scan finishes, download the CSV and open it in your spreadsheet app. You'll typically get one row per friend with columns for name and profile link. From there, add your own columns: relationship (client, prospect, peer, personal), last interaction, notes. This is where the export becomes genuinely useful — the raw list is just the starting point.
Step 4: Decide what to do with it
A few practical uses:
- Flag people you haven't interacted with in over a year as cleanup candidates.
- Build a list of prospects to message personally (one at a time, genuinely — not a blast).
- Cross-reference with your email list or CRM to find contacts missing from one side.
Keeping the export current
A friends export goes stale fast. People change names, deactivate accounts, and your list grows every month. Re-run the export quarterly and save each version with a date in the filename — friends-2026-10.csv, friends-2027-01.csv, and so on. Keeping the history matters more than you'd think: comparing two exports shows you exactly who you've added and who disappeared, which is useful context before a cleanup pass.
Store the CSVs somewhere sensible, not just your downloads folder. If you use cloud storage, put them in a private folder — a spreadsheet of your personal network is exactly the kind of file that shouldn't be floating around unprotected. And if you maintain segments in the spreadsheet (clients, prospects, peers), carry those annotations forward when you refresh: open the old and new exports side by side, and copy your notes onto the matching rows. Twenty minutes of maintenance per quarter keeps the whole system trustworthy.
Honest limitations
- You can only export your own friends list. Exporting other people's friends or group member lists you don't admin is not what this is for.
- The export captures what's visible on profiles. Private details stay private.
- Facebook changes its interface regularly. If the scan stalls after a Facebook update, check for an extension update or contact support@tier5.us.
- A CSV of names is not a marketing list. Don't import Facebook friends into an email tool and start blasting them — that's a fast way to get marked as spam.
If your real problem is a bloated list full of people you never talk to, the next step after exporting is cleaning it up — Friend Disconnector finds your inactive friends so you can review and remove them. Not sure which tool you need? The 30-second tool finder will point you the right way.