User Import Export

5 Export Formats
Export users to CSV, Excel (XLSX), JSON, XML, or SQL formats. Each format is optimized for its intended use - CSV for spreadsheets, Excel for professional reports, JSON for APIs, XML for data interchange, and SQL for database migration.

Configurable CSV Options
Choose your preferred CSV delimiter (comma, semicolon, tab, or pipe) for maximum compatibility with different spreadsheet applications and regional settings.

Professional Excel Output
Excel exports include styled headers, auto-column sizing, frozen header row, and auto-filter for professional data analysis and reporting.

Core User Fields
Export all standard Joomla user fields including ID, name, username, email, registration date, last visit date, block status, and more. Select only the fields you need for your specific use case.

User Groups & Profiles
Include user group memberships and profile data (address, phone, website, etc.) in your exports. Dynamically detects all profile fields from your database.

Custom Fields & Notes
Export custom fields defined for users and user notes. All custom field types are supported with proper value handling.

Search & Group Filters
Filter users by name, username, or email. Export users from specific user groups or with specific activation/block status.

Date Range Filtering
Export users registered within a specific date range or based on their last visit date. Perfect for targeting new users, inactive users, or specific cohorts.

Preview Before Export
Preview the first 10 records matching your filters before exporting. See exactly what data will be exported and verify your field selection and filters.

Multiple File Formats
Import users from CSV, Excel (XLSX/XLS), JSON, or XML files. Automatic delimiter detection for CSV files and support for various JSON/XML structures.

Smart Field Mapping
Auto-detect field mappings based on column headers with support for common aliases (email, e-mail, mail). Override auto-detected mappings manually for complete control.

Flexible Import Modes
Choose to add new users only, update existing users only, or both add and update. Match existing users by email or username.

Comprehensive Validation
Validate email formats, username requirements, and required fields before importing. Detect duplicates within the import file and identify existing users in the database.

Detailed Error Reporting
Get row-by-row error details with specific error messages. Know exactly what needs to be fixed before attempting the import.

Warning System
See warnings about existing users, duplicate entries, and potential issues without blocking the import process.

Export Options
Choose to exclude passwords, include hashed passwords for migration, or replace with placeholders. Never accidentally expose sensitive password data.

Import Options
Auto-generate secure passwords for new users, import pre-hashed passwords for migration, or require password reset on first login.

Hash Detection
Automatically detects if imported passwords are already hashed (bcrypt) and handles them appropriately.

Save Export Configurations
Save your export settings including format, selected fields, filters, and options as named templates. Perfect for recurring reports and standardized exports.

Template Management
View, search, filter, and manage all saved templates. Delete unused templates and run saved configurations with one click.

Quick Execution
Load a saved template and execute it immediately, streamlining repetitive export/import tasks.

Automatic Logging
Every import and export operation is logged with details including record counts, success/failure statistics, and timestamps.

Re-Download Exports
Download previously exported files directly from the log entries. Files are retained for the configured number of days.

Log Management
Clear old logs automatically with configurable retention periods (7-90 days). Associated export files are cleaned up automatically.

Dashboard Overview
See user statistics, recent exports/imports, and template counts at a glance. Quick action buttons for immediate access to export and import functions.

Drag & Drop Upload
Upload import files by dragging and dropping or browsing. Progress indicators and clear feedback throughout the process.

Sample Template Download
Download a sample CSV template with example headers and data to get started quickly with user imports.

Latest Joomla Support
Fully compatible with Joomla 5.x and 6.x using modern APIs, namespaces, and best practices. Built following Joomla coding standards.

Permission System
Granular access control with separate permissions for export, import, templates, and logs. Integrate with Joomla's ACL system.

Secure & Reliable
CSRF protection, input validation, SQL injection prevention, and proper file upload handling. Production-ready security throughout.