AAU Club Manager

← All help guides

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

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:

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

Warning: exports contain PII. Store securely and delete after use.


Cara export pengguna ke Excel

Setiap senarai user ada butang Export.

Ada

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.