AbonShell.3746:

So, my guild has been doing giveaways. And they’ve been manually typing down each name, so I brought up that there’s an API call for guild members. I was wondering if it was possible to get the output into a spreadsheet. I have no clue where to start to figure this out. I’m willing to learn to code to do this.

Thanks in advanced.

ElGreenGo.6734:

It’s not too hard to do. I just whipped up a little tool that generates a CSV file of member information that should be easy to import into a spreadsheet if you want to use it.

http://constantrespawn.com/tools/gw2/guild-member-csv/

You will need to generate an API key using the guild leader’s account with guilds permissions (keys can be obtained from https://account.arena.net/applications) . You will also need your guild id. If you need help figuring out your guild id I could write something to do that later too, but I need sleep now ;-)

AbonShell.3746:

This is exactly what I was looking for. I was able to get the Guild ID no problem. Just took a bit of googling.

ElGreenGo.6734:

I’m glad it helped

For anyone who finds this in the future, if you need help getting your guild id I wrote this:

http://constantrespawn.com/tools/gw2/my-guild-ids/

Enter an API key with “account” permissions and it will give you a list of your guild names and their ids.