7Bricks

Free Excel-based Inventory control system for your hobby collection
For any inventory-based collection like LEGO sets, Books, Diecast cars, dolls, stamps, etc.

100% Free

Because we love Excel, and we love LEGO, this tool is free.

You control

An Excel Macro-enabled Spreadsheet, means you are in full control

Local

Local database, local images, download only what you need.

3 levels inventory

Collect items in Containers, then collect Containers in Rooms to return to certain item when needed.

Image per item

Add images for each item (and optionally its box), for LEGO sets download official image from websites.

Pure Excel macro-based

Local Excel-macro tool, Internet connection only needed when downloading.

Internal reports

Generate reports to show items in certain container, items of certain category, items matching search results, etc.

box-3d-50

More and more features

All Features

Built by developer

ANmar

This is what happen when you combine ...
44yrs AFOL + 25yrs in Excel Programming + 2 hours daily train commute.

An Excel-developer, LEGO-enthusiast, control-freak with organizing obsession trying to combine several passions into one tool.

More about me

Screenshots

Check out details of the tool, and where to find what.

As from 7Bricks v2022.28

Sheets

Important sheets in tool
Enable macros

Tool is Excel-Macro-based, enable macros to run tool.
Main sheet

1st sheet to show
MySets sheet

Sheet to have all inventory items
DB Sheet

Sheet holding table of official Sets
Containers

Multiple Sets can be stored in 'Container'.
Rooms Sheet

Multiple Containers are expected to be in a 'Room'.
MyLists Sheet

Your saved, favories or wanted list of items
Report1

Output of main report functionality
D Sheet

Used by tool to store temporary tables and user settings
Help Sheet

Some quick help screens and detailos about tool
2 Report sheets

Additional report sheets for other types of output reports as well as future reports
1 Hidden sheet

Sheet to be desplayed guiding user to enable macros

MySets

Main sheet storing all items in your collection, used here for LEGO sets.
MySets Commands

Areas and controls in 'MySets' sheet, notice command to show Set Details
Menu Commands for 7Bricks

Commands in Excel menu for 7Bricks tool.
Set Details window

Main window, small size, size1, Double-Click a cell with Set, click 7Bricks > MySets or click Box icon to show
Main window. another row

Click any row with SetNumber (While Set Details window is on) to show selected Set.
Main window - size2 - MySets

Click to expand window to show more details of selected set
Main window - size3 - MySets

Click again to expand further and show even more details
Main window - size3 - Details tab

Details of set, official details, plus some commands
Main window - size3 - Online tab

Online resources for this active set
Main window - size3 - Parts tab

List of parts for this set, [Still under contruction -Not ready yet!]

Search

Quick and extended Search commands
Quick Search

Searching for set in MySets, type in number and hit 'Enter'.
If not found

Searching item with 0 results in MySets/DB/etc.
Found in MySets

When item found in MySets after quick search, it will go to its first row directly and open that row.
Found in Database

When item found in DB, not MySets after quick search, Search dialog will be showing
Open from Search

Double-Click any item in Search result window list will open that item
Search from Menu

Show Search dialog from Excel 7Bricks menu.
Search from Main sheet

You can also show search window from 'Main' sheet.

Set Details

Areas of Set Details window in all 3 sizes
Set Details areas - size1

Set Details window and details of different areas - size1
Response to your selection

Click any row with SetNumber (While Set Details window is on) to show selected Set.
Main window - size2 - MySets

Click to expand window to show more details of selected set
Main window - size3 - MySets

Click again to expand further and show even more details
Main window - size3 - Details tab

Details of set, official details, plus some commands
Main window - size3 - Online tab

Online resources for this active set
Main window - size3 - Parts tab

List of parts for this set, [Still under contruction -Not ready yet!]

How-Tos and F.A.Q.

More F.A.Q.s

How to add new Set to MySets?
In sheet 'MySets' column F just type in the Set Number and press Enter (or Tab).

How to remove Set from MySets?
Several ways, but one of them is to put '0' in Qty column.
You can always remove that row entirely, replace or clear contents.

What to do when we need more rows at bottom of 'MySets' ?
Go to Menu command 7Bricks > Options > Import/Export
And click 'Fill 50 more rows...' command. You may also manually fill rows (Copy and Paste).

More >

pattern-lines

We are developing the tool since 2014.

Version v2.301 (Jun 18th 2023) available to download now

Get tool