Skip to content
Go to file

Latest commit


Git stats


Failed to load latest commit information.
Latest commit message
Commit time

Website README

The 200 Word RPG challenge is a light game design challenge that runs every year. The goal is simple: Design a role-playing game using 200 words or less.

Every year the challenge grows larger and the entries more numerous. This post will detail some of the tools and techniques used to organize and display over 1000 entries across several years of challenges.

Tool and Services


  1. Each entry is submitted through a Google Form, which saves all submissions in a Spreadsheet.
  2. I check the wordcount for each entry, making a little marker if the entry should be disqualified.
  3. I download the spreadsheet as a CSV file, making sure UTF-8 encoding, and quoted text fields are enforced.
  4. A python script scans the CSV file checking for duplicate entries, multiple author submissions, and the marker added.
  5. The script formats all of the data and creates a Markdown file for each entry.
  6. I add the markdown files to the site,and Jekyll turns it into a series of web pages.

The secret sauce is in the Python script and Jekyll.

Traditional websites like Wordpress have a SQL database where posts are stored. Whenever a user clicks a page the website looks in the database for the post info and loads it up for that user. This system is very flexible and simple to use, but it can be slow.

Jekyll is different. It doesn't have a database and any loading is all done at the beginning. Jekyll scans all of the markdown files and turns them into lean, static pages. This makes the site fast and light, but there isn't a database to query and easily alter.

The main reason I chose Jekyll, however, is because it builds pages from text files. And text files are super easy to create using python.

The python script scans through the submitted entries and turns each one into it's own Markdown text file. Through python I can check to make sure entries aren't submitted multiple times and prevent authors from submitted too many entries. Basically I can double check and filter all of the information, transforming it however I wish.

Whenever a new submission is added I can just run the python script again and have it generate a new text file for that entry. It's super quick and easy; I think it takes about 3 minutes to process ALL the entries from 2015, 2016, and 2017. Very nice.

The hard part was just getting all this stuff setup. Now that it's complete and working as expected, added new entries or changing entries is trivial and quick.

Hopefully this little guide will help you understand how the site works, and maybe even help you find uses for Jekyll and python in your own projects. It's a neat little tool and an interesting alternative to traditional website/blog site structures.

Python Script

Found in the script folder

For local development on docker, change url to localhost, and run this command within local repo folder:

docker run --rm --volume=$(pwd):/srv/jekyll -v 'jekyll-gems:/usr/local/bundle/' -it -p 4000:4000 jekyll/jekyll jekyll serve

You can’t perform that action at this time.