Import Workers from Spreadsheet
⚠️ Limited Functionality
PHPSpreadsheet library not detected. Only CSV file imports are currently available. To enable Excel file support (XLS, XLSX), install the PHPSpreadsheet library using Composer.
Installation command:
composer require phpoffice/phpspreadsheet
CSV imports will work without the library.
Step 1: Upload Spreadsheet
Step 2: Review and Import
After uploading, you'll see a preview of the data where you can:
- Review all worker information
- See which congregations were found
- View any errors or warnings
- Select which rows to import
- Fix issues before importing
📋 Required Columns
Your spreadsheet must include these columns (names are case-insensitive):
- Congregation - Name of the congregation (must match existing congregation)
- First Name - Worker's first name
- Last Name - Worker's last name
- Phone - Phone number (optional)
Alternative column names are accepted (e.g., "First" instead of "First Name")
📝 Example Spreadsheet Format
| Congregation | First Name | Last Name | Phone |
|---|---|---|---|
| Downtown Congregation | John | Smith | 555-0101 |
| Downtown Congregation | Jane | Smith | 555-0102 |
| East Side Congregation | Bob | Johnson | 555-0201 |
✅ Tips for Successful Import
- Header row required: First row must contain column names
- Congregation names must match: Ensure congregation names exactly match those in your system
- Check for duplicates: The system will warn about existing workers
- Family grouping: Workers with same last name and congregation are grouped as family
- Empty rows ignored: Blank rows are automatically skipped
- Data validation: All data is validated before import
🔍 What Happens During Import
- File is uploaded and validated
- Spreadsheet is parsed and data extracted
- Congregation names are matched against existing congregations
- Duplicate workers are detected
- Preview is shown with any errors or warnings
- You select which rows to import
- Workers are created in the database
- Success message shows number imported