Exports

/export produces downloadable CSV files (and can push to a Google Sheet) for rosters, season stats, war and CWL logs, capital data, and your server’s link tables. Many subcommands work across one clan or your whole family in a single call.

!

/export is a manager action. It requires the Manage Server permission because it can extract tenant data (rosters, the Discord ↔ player link table, and more). Members without that permission won’t see or be able to run it.

i

Player names in CSVs are sanitised against spreadsheet formula injection, so a crafted name can’t execute when the file is opened in Excel or Sheets.

Multi-clan (family) exports

Every single-clan data subcommand also accepts a clans option — a comma-separated list of tags/aliases, or all — to export several clans at once. The output is combined into one CSV with a leading Clan column. Tokens are matched only against clans linked to this server, so you can never export a clan the server doesn’t own.

/export members clans:all
/export war clans:#2PP,alpha days:90

Subcommands

Roster & member data

Subcommand	Options	Notes
members	tag, clans	Members roster CSV (name, tag, TH, trophies, role, donated/received).
donations	tag, clans	Donations board CSV, sorted by donated.
season	season (required, YYYY-MM), tag, clans	Stored season stats CSV — see the note on loot columns below.

War & CWL data

Subcommand	Options	Notes
war	tag, clans, days (7–180, default 60)	War attack log CSV from tracked wars.
attack-log	tag, clans, days (7–180, default 60)	All war attacks (offense + defense).
cwl	tag, clans	CWL attack log CSV.
last-wars	tag, clans, days (7–180, default 90)	Per-member war participation CSV.
missed	tag, clans	Missed attacks in the current war CSV.

Capital data

Subcommand	Options	Notes
capital-raids	tag, clans	Capital raid-weekend stats CSV (latest weekend).
capital	tag, clans	Capital contribution CSV (latest weekend).

Server-wide exports (no clan option)

Subcommand	Notes
clans	All linked clans overview CSV (name, tag, alias, level, members, points).
users	Linked Discord users CSV (Discord ID, player tag, verified, main).
rosters	All rosters + members CSV.

Google Sheets (async)

Subcommand	Options	Notes
sheets	spreadsheet_id (required), tab (default Sheet1), tag	Exports a clan’s members to a Google Sheet.

The sheet export runs in the background. Share the target spreadsheet with the bot’s service account as an Editor first, or the write will fail.

!

Data subcommands that read tracked history — season, war, attack-log, cwl, last-wars, capital-raids, and capital — depend on ClashDuke having collected that history. Recently linked clans may export few or no rows until the tracker warms up. Roster-derived exports (members, donations, current-season season, missed) work off the live roster and are available immediately.

About the season loot columns

In a season export, the GoldLootTotal / ElixirLootTotal / DarkLootTotal columns are the player’s all-time loot achievement totals captured at snapshot time (not that season’s delta). Attack wins and defense wins are per-season, since those in-game counters reset each season.

Examples

/export members tag:#2PP
/export season season:2026-06 clans:all
/export users
/export sheets spreadsheet_id:1AbC…xyz tab:Roster tag:#2PP

---

i

ClashDuke is fan-made and not affiliated with, endorsed by, or sponsored by Supercell. For more information see Supercell’s Fan Content Policy.