How to inventory a large collection of LEGO sets I have a fairly large collection of LEGO sets, most of them still as completed models. I also have all of the instruction books organised into plastic wallets which are stored in two A4 folders.

I'm looking at creating some kind of inventory of my LEGO sets. I'm thinking an Excel spreadsheet is the way to go. I would like to include information such as original price, current value, number of pieces, e.t.c. 

I'm looking to see if anyone has some kind of template I could use or a quick way to automatically pull information from a site like Brick Picker or BrickLink. And also have information like current value be automatically updated.
I would recommend taking a look at BrickPicker's BrickFolio feature. It allows you to maintain a list of sets you own, including place of purchase, purchase cost and seal code, and keeps track of the current EBay value on a month-by-month basis. It also tracks CAGR (Compound Annual Growth Rate) - a measure of how well the set's value is performing over time.



Clicking on the set name gives you an overview screen with key set details such as piece count etc.