mtg-ssm 1.0.0

A tool to manage Magic: the Gathering collection spreadsheets.

mtg_ssm - Magic: the Gathering Spreadsheet Manager

This is a tool for creating/updating user-friendly spreadsheets with Magic: the Gathering collection information. The tool can also import/export data to/from these spreadsheets to other formats, such as CSV files.

As a matter of convenience, you can store the created spreadsheet in Dropbox, Google Drive, or the like and access your collection from anywhere.

Installation

mtg_ssm is available on PyPI so, if you have python (>=3.4) and pip installed on your system, you should be able to get mtg_ssm by entering the following into a terminal:

pip3 install mtg_ssm

Updates can be performed by entering:

pip3 install -U mtg_ssm

You can verify installation from the terminal by running:

mtg-ssm --help

Usage

For first time use, you will want to create an empty spreadsheet with card data:

mtg-ssm collection.xlsx create

In the future, when new sets are released, you can update your spreadsheet with new cards:

mtg-ssm collection.xlsx update

Existing collections

If you already have your cards in another collection store, you might want to import that collection into your card database.

First create an example csv file:

mtg-ssm collection.xlsx create
mtg-ssm collection.xlsx export collection.csv.example

Then create a matching csv and import into your database:

mtg-ssm collection.xlsx import collection.csv

In development

This tool is a work in progress. It is fully working now and I use it for tracking my own, personal collection, but it is somewhat tailored to my needs. There are, also, quite a few features that I would like to add and bits of code to cleanup (of course, every project always needs some code cleanup).

Contributions

Pull requests are welcome and contributions are greatly appreciated.

Acknowledgments

• Wizards of the Coast: For making Magic: the Gathering and continuing to support it. Off and on, it’s been my favorite hobby since the early ’90s.

• MTG JSON: MTG JSON is an amazing resource for anyone looking to build tools around magic card data. It is pretty much THE source for structured magic card data. Without MTG JSON this project would not have been possible.