How to Export Facebook Friend List to Excel

Facebook offers the option to download a copy of your information to keep, or to transfer to another service. This option can be accessed at the following link:
https://www.facebook.com/settings?tab=your_facebook_information

You may want to see the list of all your friends in an Excel file. However, the data from this option can be downloaded in only two formats; HTML and JSON. You will be required to use the Power Query add-in in Excel to connect to external data sources and perform advanced data analyses using a JSON file.

Therefore, the easiest way is to use the HTML file and get the required data in Excel by executing some steps as follows:

1. When you download data from Facebook, Friends’ list will be available in friends.html.
2. Open friends.html in Google Chrome.
3. Friends’ list will be shown in the Browser with Friends’ Names in Bold and Date of Connection/Email and other information in the Regular Font.
4. Type Ctrl-A (Select All) on this page, then Ctrl-C (Copy).
5. Open Microsoft Excel, select cell A1, and type Ctrl-V (Paste).
6. Delete the initial rows where your name and other information appears such that the first row should be your friend’s name.
7. Right-click on First Row and select Insert.
8. Type Friends in First Row.
9. Type Ctrl-F (Find), Click Options -> Format
10. Select the Font Tab. In the Font Style, select Bold and click OK.
11. Now click Find All.
12. Select one of the results below the Find All button and type Ctrl-A (Select All).
13. Excel will select all rows that are Bold (Friends’ Names).
14. In the Home Tab, select Fill Color, and select Yellow color.
15. All friends’ names will be yellow-highlighted.
16. Close Find and Replace box.
17. Select cell A1, and click Data -> Filter
18. In the Filter Dropdown, select Filter by Color -> No Fill
19. Select all filtered rows, Right Click and select Delete Row.
20. Click OK on the prompt ‘Delete entire sheet row?’
21. Now again click Filter dropdown in Cell A1, and select Clear Filter from Friends.
22. You will now have a complete list of friends.