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

Any filter you apply on the list page (category, active status, date range) is applied to the export.

Example: only export active U10 trainees: 1. Trainees → filter Category = U10, Status = Active 2. Click Export Excel — only matching rows

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

Filter list dulu (kategori, status) — export ikut filter.

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.