How to export users to Excel
Club Admin · Bahasa Melayu below
Every user list has an Export button. Downloads a spreadsheet you can open in Excel / Google Sheets for offline analysis, backup, or bulk edits.
Available exports
- Trainees — Sidebar → Trainees → Export CSV/Excel
- Coaches — Sidebar → Coaches → Export CSV/Excel
- Parents — Sidebar → Parents → Export CSV/Excel
- Members — Sidebar → Members → Export CSV/Excel
- Staff — Sidebar → Staff → Export CSV/Excel
What's in each file
Every export includes: full name, ID number, DOB, gender, phone, email, categories/branches assigned, date registered, active status.
Trainees: adds parent info, school, medical, attendance %, unpaid balance. Coaches: adds certifications, IC verification status. Parents: adds number of children.
Filter before export
Export Excel downloads exactly the rows the list is showing: the status tab you picked, the branch, and your search. Change the filter first, then export.
Status tabs on each list:
- Trainees: Enrolled, Active, Suspended, Inactive, Removed, Pending, Flagged
- Members: Active, Inactive, Removed, Pending, Trial, Suspended
- Coaches: Total, Approved, Pending, Inactive / Rejected
- Parents and Staff: Active, Inactive, Removed
Example: only export inactive trainees in one branch: 1. Trainees → click the Inactive card, pick the branch, search if needed 2. Click Export Excel, the file holds only those rows
The file name also carries the tab, e.g. trainees_MyClub_inactive_20261023_1200.xlsx.
Bulk edit + re-import
- Export → edit in Excel → save
- Use Bulk Import (see Upload trainees via Excel) to bring changes back
- Match by ID number — existing records are updated, new IDs create new users
Warning: exports contain PII. Store securely and delete after use.
Cara export pengguna ke Excel
Setiap senarai user ada butang Export.
Ada
- Trainees → Export CSV/Excel
- Coaches → Export CSV/Excel
- Parents → Export CSV/Excel
- Members → Export CSV/Excel
- Staff → Export CSV/Excel
Isi file
Nama, IC, DOB, gender, phone, email, kategori/cawangan, tarikh daftar, status.
Trainee: parent, sekolah, medical, % kehadiran, baki. Coach: sijil, verified IC. Parent: bilangan anak.
Filter dulu
Export Excel muat turun baris yang sama seperti yang dipaparkan: tab status, cawangan dan carian anda. Tukar filter dulu, kemudian export.
Contoh: klik kad Inactive di Trainees, pilih cawangan, kemudian Export Excel. Fail hanya ada trainee tidak aktif di cawangan itu.
Members kini ada tab Pending dan Trial.
Bulk edit + import balik
Export → edit dalam Excel → guna Bulk Import balik. Padan ikut IC — existing update, baru cipta baru.
Amaran: fail mengandungi PII. Simpan selamat, padam selepas guna.