How to organize your comic collection with excel

How to organize your comic collection with excel

People collect comic books for different reasons. Many collect them to make money as comic books perform better than the stock market. Other collect them in order to hand down once treasured belongings to their children or grandchildren. Still others collect them just for the joy of collecting. Those who value their comic book collections need a way to keep track of what they have. While paper and pencil inventories can be created with little fuss, there is a better option available. Use a comic book inventory to catalog your prized collection.

The Comic Book Checklist is a comprehensive comic book inventory allowing you to organize, sort and catalog your collection no matter how big or small it may be. Those using their collection to make money can keep a detailed record of all profit and expenditures associated with the purchase and sale of their inventory. This easy to use comic book inventory also lets you save money since it can be downloaded, customized and printed all for free.

How to Use the Comic Book Inventory Template

This comic book inventory comes in the form of an Excel spreadsheet. It can be downloaded by clicking the link available on this page. Use basic Excel commands to record and organize information about your collection. Follow the easy steps below to keep a detailed account of your collection as it grows or to keep track of what has been sold and what remains in your inventory.

Enter as much or as little information about each comic book by typing as desired using the 15 categories provided. The checklist categories include:

This is a column that focuses on something or some things from the comic book sphere of influence that may not get the credit and recognition it deserves. Whether that’s a list of comic book movies, ongoing comics, or a set of stories featuring a certain character. The columns may take the form of a bullet-pointed list, or a slightly longer thinkpiece – there’s really no formula for this other than whether the things being covered are Underrated in some way. This week: A system to organize your comics.

Okay, bear with me. A lot of the comic readers I chat with at my LCS fall into one of three categories; those using an app to track their comics, those with an eidetic memory or those who just do the best to remember what they have generally but buy based on a specific want list. I tend to fall into the latter category; I’ve a list of the books I’m hunting on my phone, but when it comes to the books I already have, I’m less prepared. I tend to rely on what isn’t on my list and memory… which is fine when I’m looking at comic runs that I know I’ve finished, but less ideal when I come across a book I’m not sure if I have and am not actively collecting.

So what are my options to help me file and organize my books?

An excel or google doc spreadsheet is one of the simpler and less flashy methods, but also one of the most effective if you’re just listing which issues you do and don’t have. The more comfortable with spreadsheets then the more you’ll be able to customize how much information about each comic you want to put in, but at the end of the day it’s all reliant on what you put in.

Of course there’s comic book collecting apps designed to help you organize your books such as CLZ that for $14.99 a year allows you to track your books with a barcode scanner or the Comic Book Collector’s Database. I can’t honestly give you much information about the apps because I don’t use them (and never have), but they’re an excellent option for those who want a little more of a user experience than a basic list or spreadsheet.

You could also probably pay someone to catalogue your books but why waste the money on that when you can buy more comics?

Ultimately how you track your books is entirely up to you; but if you’re new to the comic collecting and reading community then eventually you’re going to want to track your collection somehow because unless you’re really good at remembering what you have (I’m not) then you’ll probably end up with a couple doubles of books you probably don’t need doubles of (I’m looking at you Wolverine #36).

Join us next week when we look at something else that is, for whatever reason, Underrated.

I have just decided to start reading comic books, and the nerd in me wants to keep track of the 3 books I own (and the many books I will own), so I started a excel spreadsheet. Now my question is, what exactly do I put in there? I have title, but to me it seems that issues of the same series have the same title, then I have issue, writer, year and a comment column for special comments. Any advice?

Here's one way to do it:

Family (like Spider-Man for all related titles)

Volume (this is where same titles get distinguished)

Print (1st print, 2nd. )

Date (can be broken into 2, month/year)

Creators (break down how you want, I do writer/penciler/inker but only really record runs that way)

Reprint (is it a reprint, what does it reprint)

Condition (whether your estimate or a slab)

Not really an answer to your question, but I use to track my collection (and pull list stuff). From it I can do an export to spreadsheet.

I do it a bit differently, so I have a file on my PC just marked Comics, its further divided down into files such as "Star Wars" "Spiderman" and so on then with in those files each comic series gets its own file ie "Dr Aphra" and with in that I have these little word documents I call "Comic cards", each one contains info like a synopsis, author, artist, publisher, price and so on and what box it is in in my collection.

For each box I own I then type up a list of what is in that box, each series and the issues in that series in the box. Which I then print out and tape to the lid of the box which are all individually numbered. Most of the time I wait until I have filled the box before I do this and I try to keep all the comics in one series together in one box.

Then I have a bit of a index, so once I complete a run I add it to my index along with the box number its in.

Its a bit of a mess to start with but I have been doing it now for almost 2 years and have 4 boxes with another one that will probably be full in the next month or two and its been working out for me.

I quite enjoy it, archiving everything that way, makes me enjoy my comics a little bit more.

Easily catalog your comic collection. Just scan barcodes.
Automatic issue details, key info, cover art and creator lists.

Pricing: $14.99 per year. Free 7-day trial.

** Keep track of your comic collection and your wish list
Automatically organize your comics by series and browse lists of all issues you own.

** Easily add comics to your comic inventory
Three ways to catalog comic books:
1. scan barcodes
2. find a series by title, then checkbox the issues you own
3. search a specific issue by title and issue number

** Automatically download issue details, cover art and more
Our CLZ Core will automatically give you cover art and full comic details, like Series, Issue Nr, Publisher, plot, creator lists, character lists, backdrop art, etc.

** Automatic key comic information
CLZ Comics automatically provides key comic information, like first appearances, deaths, cameo appearances, first team appearances, origins, iconic cover art, etc.

** Edit your comic entries to add personal info
Like storage box, grade, signed by, purchase date / price / store, notes, etc.. Mark your key comics and enter the key reason (e.g. "first appearance of . ").
Edit comics one by one or use Edit Multiple for batch editing many comics in one go!

** Use our CLZ Cloud service to:
1. Share your app subscription to other mobile devices, without paying again.
2. Sync your comic library between devices (e.g. your phones and tablets).
3. View and share your comic collection online, using the CLZ Cloud viewer website.
4. Always have an online cloud-backup of your comic organizer database.
5. Sync data to/from our Comic Connect web-based software (separate subscription).

** View collection totals and charts in the Statistics screen
Total comics and series, most recent additions, charts by series, by publisher, by grade, etc..

** Browse, sort, group and search your comic inventory in many ways
Browse your comic collection as a list or as a "cover wall".
Sort by series/issue, date, value, etc.. Group into folders by series, storage box, grade, by creator, etc. Or just use the search box top right.

** Questions or concerns? Just contact us! *

We love to hear your feedback, we are here to help with any problems or concerns, 7 days a week. In the app, tap the menu icon top left, then choose Contact Support.

** Subscription pricing *
CLZ Comics is a subscription app, costing:
* $1.49 per month, when paying monthly
* $14.99 per year, when paying yearly (

For this subscription fee, you get:
* usage of the app on multiple phones and tablets
* access to our Core online comic database, for full comic details and cover art
* access to the key comic info from Core (first appearances, deaths, etc. )
* access to to our CLZ Cloud system, for syncing between devices, backups and online sharing
* regular app updates with new features and improvements
* access to our excellent customer support by email, 7 days a week

You can start a 7-day free trial from the app's start-up screen. The free trial automatically continues into the subscription of your choice. You can cancel your subscription anytime.

** About auto-renewable subscriptions:
* The payment will be charged to your iTunes Account when you confirm the purchase.
* The subscription automatically renews unless auto-renew is turned off at least 24-hours before the end of the current period.
* Your account will be charged for renewal within 24-hours prior to the end of the current period. Automatic renewals will cost the same price you were originally charged for the subscription.
* You can manage your subscriptions and turn off auto-renewal by going to your Account Settings on the App Store after purchase.
* Any unused portion of a free trial period, if offered, will be forfeited when the user purchases a subscription to that publication, where applicable.