Recommend
 
 Thumb up
 Hide
6 Posts

BGG» Forums » Gaming Related » Conventions » Essen

Subject: 2015 Games in an Excel sheet? rss

Your Tags: Add tags
Popular Tags: [View All]
Mia N.
Germany
flag msg tools
mbmb
I wonder if there is a compilation of all 2015 games in the form of an Excel sheet or whether that's available. I've seen Kempeth's tool, but I was hoping for a list in the excel format. I'm not very experienced with creating lists both within BGG and the tool. I'd rather have the flexibility excel provides to organize my list with individualized categories for multiple purposes.

I'm trying to figure out whether that kind of compilation already exists or if I will have to do my own.

Any advice would be much appreciated!

Philia
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Fridjof B
Norway
Tranby
Norway
flag msg tools
badge
Avatar
Microbadge: Essen attendeeMicrobadge: Game Group OrganizerMicrobadge: Plays Games with SpouseMicrobadge: Commodore 64 fanMicrobadge: Mead lover
I have not seen that, but you could easily make that in 3 minutes:

You could use Eric Martins Preview and hit "Titles Only", copy from list start to list end, and copy. Paste in Excel as text without formatting in A2. In B2 make a fomula like =IF(MID(A2;1;5)="Board";"";A2) for instance and copy it down. Then you would avoid the publisher lines. Copy column B and paste as values somehwere, and sort away empty cells.
2 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Mia N.
Germany
flag msg tools
mbmb
Oh man, thank you soo much surprise ! I'm going to give this a try tonight. Fridjof, I think you saved me a loot of typing, man!
1 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Daniel B-G
United Kingdom
Leeds
W Yorks
flag msg tools
Avatar
mbmbmbmbmb
If all you are interested in are the Essen releases then you can use the BGG XML API

http://boardgamegeek.com/wiki/page/BGG_XML_API2

Here is the search string you'll need to use

http://boardgamegeek.com/xmlapi/geeklist/174654

You can import this direct into Excel or you can save it as an XML file and open it in Excel. It basically amounts to the same thing.

This won't however work for anything released before or since Essen as they aren't included in the list.

(Note the search string I provided earlier can be used to download any geeklist, just change the entry at the end to match the geeklist ID).
3 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Mia N.
Germany
flag msg tools
mbmb
Thank you, Daniel!

I want to go for the Essen releases since it's the major bulk and the rest I can add manually. I'm going to use your suggestion tonight and I'll figure out which way is the most practical. Thank you, without those hints (and those of Fridjof)I wouldn't have had a clue where to begin.
 
 Thumb up
 tip
 Hide
  • [+] Dice rolls
Daniel B-G
United Kingdom
Leeds
W Yorks
flag msg tools
Avatar
mbmbmbmbmb
The XML API is incredible powerful. I've only really scratched the surface (like you I'm more of a spreadsheet junkie rather than a proper coder).

I've used it in the past to do things like downloading my collection into an analysis workbook.

It's what the Essen Mini-geek tool uses to access the data.

You might find some of the following tools interesting to investigate that all run on the API.

Friendless's Extended Stats (My profile) http://tinyurl.com/DAAAN-BGG-Ext-Stats
Nandeck http://www.nand.it/nandeck/ (I used this to generate a deck of cards for all the entries on the 2014 list to make it easier to browse their contents on the ferry to rotterdam).
1 
 Thumb up
 tip
 Hide
  • [+] Dice rolls