Answers.Body: <p>A custom spreadsheet solution gives you great flexibility and leaves you in control of your own data. Be sure to use a spreadsheet tool that supports the use of web images in cells (Google Spreadsheets, for instance); then you can easily use online resources to automatically show thumbnail pictures of your sets on each row (given the set number). This makes it so much easier to navigate your sheet. </p>
  
  <p>In addition, you can harness the power of websites such as <a href="http://www.brickset.com" rel="nofollow noreferrer">Brickset</a>, <a href="https://rebrickable.com/" rel="nofollow noreferrer">Rebrickable</a> and <a href="http://www.brickpicker.com" rel="nofollow noreferrer">Brickpicker</a> to get current valuations of your "brickfolio", or enable powerful database features that let you make queries on your collection. Note that some of these support the exchange of collection data as well as batch-style import, so that you don't have to tediously enter your collection set by set.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-06-02T13:33:59.080Z
Answers.Text: +1 for Rebrickable and Brickset. Those sites can share data with each other, have good coverage of the existing sets, and are flexible in how you can organize your data. I use Rebrickable, it's nearly perfect for my needs.
Answers.UserDisplayName: Mr. Shiny and New 安宇
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-05-31T13:17:00.603Z
Answers.LastActivityDate: 2017-06-01T13:07:52.450Z
Answers.LastEditDate: 2017-06-01T13:07:52.450Z
Answers.UserDisplayName: Gruber
Answers.Body: <p>I would recommend taking a look at <a href="https://www.brickpicker.com" rel="nofollow noreferrer">BrickPicker</a>'s <a href="https://www.brickpicker.com/bpms/brickfolio_dashboard.cfm" rel="nofollow noreferrer">BrickFolio</a> 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.</p>
  
  <p><a href="https://i.sstatic.net/yG8DL.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/yG8DL.png" alt="enter image description here"></a></p>
  
  <p>Clicking on the set name gives you an overview screen with key set details such as piece count etc.</p>
  
  <p><a href="https://i.sstatic.net/pE7jt.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/pE7jt.png" alt="enter image description here"></a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-05-29T18:46:22.360Z
Answers.Text: Having played around with some of the tools it does show promise. Still think I might put some time into making a custom spreadsheet later this summer.
Answers.UserDisplayName: Darth Vader
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-05-29T10:57:36.780Z
Answers.LastActivityDate: 2017-05-29T10:57:36.780Z
Answers.UserDisplayName: Phil B.
Body: <p>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.</p>
  
  <p>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. </p>
  
  <p>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.</p>
  
Tags: <inventory>
Title: How to inventory a large collection of LEGO sets
UserDisplayName: Darth Vader
ThreadText: # How to inventory a large collection of LEGO sets
  
  (Asked by: username_0 on 2017-05-29)
  
  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.
  
  **Tags:** inventory
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2017-05-31. Score: 3
  
  A custom spreadsheet solution gives you great flexibility and leaves you in control of your own data. Be sure to use a spreadsheet tool that supports the use of web images in cells (Google Spreadsheets, for instance); then you can easily use online resources to automatically show thumbnail pictures of your sets on each row (given the set number). This makes it so much easier to navigate your sheet.
  
  In addition, you can harness the power of websites such as [Brickset](http://www.brickset.com), [Rebrickable](https://rebrickable.com/) and [Brickpicker](http://www.brickpicker.com) to get current valuations of your "brickfolio", or enable powerful database features that let you make queries on your collection. Note that some of these support the exchange of collection data as well as batch-style import, so that you don't have to tediously enter your collection set by set.
  
  > **Comments:**
  > **username_2**: +1 for Rebrickable and Brickset. Those sites can share data with each other, have good coverage of the existing sets, and are flexible in how you can organize your data. I use Rebrickable, it's nearly perfect for my needs.  
  
  ---
  
  ### Answer by username_3 on 2017-05-29. Score: 3
  
  I would recommend taking a look at [BrickPicker](https://www.brickpicker.com)'s [BrickFolio](https://www.brickpicker.com/bpms/brickfolio_dashboard.cfm) 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.
  
  [![enter image description here](https://i.sstatic.net/yG8DL.png)](https://i.sstatic.net/yG8DL.png)
  
  Clicking on the set name gives you an overview screen with key set details such as piece count etc.
  
  [![enter image description here](https://i.sstatic.net/pE7jt.png)](https://i.sstatic.net/pE7jt.png)
  
  > **Comments:**
  > **username_0**: Having played around with some of the tools it does show promise. Still think I might put some time into making a custom spreadsheet later this summer.  
  
  ---
  
  