Exporting Rosters

A detailed explanation of how to export rosters to spreadsheets.

/export rosters category: WAR or CWL

Category is optional!

Exports the Rosters to a Google Spreadsheet, allows you to view this on the Web and allows you to download it.

Sheets

It generates a single Google Spreadsheet containing one sheet per Roster (titled with the roster name), plus an "All Members" sheet and a "Missing Members" sheet.

Roster Sheet

With the following Columns:

• Player Name

• Player Tag

• In Clan? - If the Player is currently on the Roster Clan

• Current Clan - Where the Player currently is

• Current ClanTag - The Clan Tag of the Current Clan

• Discord - The Discord User Name

• War Preference - In or Out of War

• Group - The selected Group in the Roster

• Town Hall

• Combined Heroes - The combined Hero Levels

All Members Sheet

Aggregates every roster's signed-up players. Contains all the same columns as the Roster Sheet, plus two additional columns: Roster (the roster name) and Roster Clan.

Missing Members Sheet

Shows all Players in the Roster Clans that aren't in any of the Rosters with the following columns

• Player Name

• Player Tag

• Town Hall

• Discord

• Clan

• Clan Tag