| Description | Get list of clan members, including TH level and weight (if manually filled) |
|---|---|
| URL | /Clan/CLANTAG/Members.FORMAT |
| Sample CSV | /Clan/LGQJYLPY/Members.csv |
| Sample JSON | /Clan/LGQJYLPY/Members.json |
| Sample XML | /Clan/LGQJYLPY/Members.xml |
| Description | Get list of clan members in current war |
|---|---|
| URL | /Clan/CLANTAG/WarMembers.FORMAT?warNo=1 |
| Sample CSV | /Clan/LGQJYLPY/WarMembers.csv?warNo=1 |
| Sample JSON | /Clan/LGQJYLPY/WarMembers.json?warNo=1 |
| Sample XML | /Clan/LGQJYLPY/WarMembers.xml?warNo=1 |
| Parameters | warNo: 1 = latest war, 2 = second latest war |
| Description | Get list of clan wars |
|---|---|
| URL | /Clan/CLANTAG/Wars.FORMAT |
| Sample CSV | /Clan/LGQJYLPY/Wars.csv |
| Sample JSON | /Clan/LGQJYLPY/Wars.json |
| Sample XML | /Clan/LGQJYLPY/Wars.xml |
| Description | Get list of clans |
|---|---|
| URL | /Clans.FORMAT |
| Sample CSV | /Clans.csv |
| Sample JSON | /Clans.json |
| Sample XML | /Clans.xml |
| Description | Get list of all member weights |
|---|---|
| URL | /Weights.FORMAT |
| Sample CSV | /Weights.csv |
| Sample JSON | /Weights.json |
| Sample XML | /Weights.xml |
Import all fields from CSV with IMPORTDATA function
=IMPORTDATA("http://fwastats.com/clan/lgqjylpy/members.csv")
Import one field from XML with IMPORTXML function
=IMPORTXML("http://fwastats.com/clan/lgqjylpy/members.xml";"//Name")
Import any HTML table with IMPORTHTML function
=IMPORTHTML("http://fwastats.com/Clans";"table";1)
Click DATA > From Web
Set address: http://fwastats.com/clan/lgqjylpy/members.xml
Click Go
Click Import
Excel complains about missing schema, click OK
Import data to $A$1, click Go
You can refresh the data or configure automatic refresh on DESIGN tab
This content is not affiliated with, endorsed, sponsored, or specifically approved by Supercell and Supercell is not responsible for it. For more information see Supercell’s Fan Content Policy: www.supercell.com/fan-content-policy. This website uses cookies and may store your personal information, more details in Privacy Policy.