SPIEL Exhibitor Extractor
SPIEL in Essen is the world’s largest public fair for board games. There is an app, hall plans etc… but not a list of all exhibitors to download. This simple python script helps to list all exhibitors with stand numbers and save them in a CSV file. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 import requests import csv # URL to JSON file url = 'https://maps.eyeled-services.de/de/spiel24/exhibitors?columns=%5B%22ID%22%2C%22NAME%22%2C%22ADRESSE%22%2C%22LAND%22%2C%22LOGO%22%2C%22PLZ%22%2C%22STADT%22%2C%22WEB%22%2C%22EMAIL%22%2C%22INFO%22%2C%22TELEFON%22%2C%22S_ORDER%22%2C%22STAND%22%2C%22HALLE%22%5D' # Send request response = requests.get(url) data = response.json() # Write to CSV with open('spiel2024-exhibitors.csv', mode='w', newline='', encoding='utf-8') as file: writer = csv.writer(file) # write CSV header writer.writerow(['Name des Verlags', 'Standnummer']) # extract name stand number for exhibitor in data.get('exhibitors', []): name = exhibitor.get('NAME', 'N/A') standnummer = exhibitor.get('STAND', 'N/A') # write data to csv writer.writerow([name, standnummer]) print("Wrote to 'spiel2024-exhibitors.csv'.")