Facebook Group Member Scrap (extension + webpage convert)

Overview

This tool provides a web interface for converting CSV, XLS, and XLSX files to a standardized XLSX format with specific Facebook profile link processing. The converted files will have three columns: LINK, ID, and NAME.

Features

Converts CSV, XLS, and XLSX files to XLSX format
Processes Facebook profile links to extract user IDs
Generates output files with timestamp in the filename
Simple web interface for easy upload and download

Implementation

index.html The frontend interface that allows users to upload files. File upload form with restrictions to accept only .csv, .xls, .xlsx

process.php The backend processor that handles file conversion.

Key functions:

Detects file type (CSV, XLS, XLSX)
Reads file content into array format
Processes Facebook links:
- Converts group user links to profile links
- Extracts user IDs from profile links
Generates XLSX output with 3 columns (LINK, ID, NAME)
Forces download of converted file

xlsxwriter.class.php

Go to: XLSXWriter GitHub
Click Code > Download ZIP
Extract the ZIP file.
Copy xlsxwriter.class.php into your project folder
in process.php add in this [ require_once "xlsxwriter.class.php"; ]

Usage Instructions

Access the Tool
- Open index.html in a web browser
Upload a File
- Click "Choose File" and select a CSV, XLS, or XLSX file
- Supported formats are clearly indicated
Conversion Process
- The system will automatically: Detect file type, Process all rows, Convert Facebook links, Generate standardized output
Download Result
- The converted XLSX file will automatically download
- Filename format: [originalname]converted[timestamp].xlsx