Back to Help Topics

Help Topic: File Formats

Rebrickable supports importing from and exporting to many different file formats. This page is a guide to these formats in case you need to manually create one of them.

Rebrickable - CSV

This is a very simple comma-separated value file which stores a list of parts, including a header row. Each row is formatted as follows:

Rebrickable Part ID, Color ID, Quantity

Example:

Part,Color,Num
3437,0,1
3437,4,1
3437,10,1
			

BrickLink - XML

This XML formatted file is used to store a list of parts but can be used to store set inventories as well as BrickLink Orders. You should not try to manually create these files, instead refer to BrickLink for details.


BrickStore - BSX

This is a XML formatted file used to store a list of parts. You should not try to manually create these files, instead refer to BrickStore documentation for details.


Peeron - TSV

This is a tab-separated value file which stores a list of parts or a list of sets, including a header row. Each row is formatted as follows:

Quantity, Peeron Part ID, Peeron Color Descr, Part Description, Part Notes

Exmaple:

Quantity	Part Number	Color	Description	Notes
2	3957	MdStone	Antenna 4H	
2	3622	Black	Brick 1 x 3	
3	3941	TrYellow	Brick 2 x 2 Round	
2	3941	Black	Brick 2 x 2 Round	
			

When listing sets, the file format is as follows:

Quantity, Set ID, Set Name, Theme

Exmaple:

Quantity	Set Number	Set Name	Theme
1	8043-1	Motorized Excavator	LEGO / TECHNIC
1	8258-1	Crane Truck	LEGO / TECHNIC
			

BaseBrick - TSV

This is a tab-separated value file which stores a list of sets and/or parts, including two header rows. BaseBrick provides two types of file formats - simple and comprehensive. Rebrickable can import either.

Exmaple (simple file):

Set and loose part list from Basebrick (simple). Created on 08.10.2011 12:52:52
Quantity	Item Number	Color	
1	4996-1	Beach House	
1	5528-1	Canister with 700 pcs	
1	5766-1	Log Cabin	
			

Example (comprehensive file):

Set and loose part list from Basebrick (comprehensive). Created on 08.10.2011 12:48:12
Item Type	Quantity	Item Number	Color	Description	Status	Comments	Updated	Inserted	Lego Element ID	Color ID	Category	Reserved	
S	1	4996-1		Beach House	Normal	Ca	2011-10-08 06:21:32	2011-09-21 12:57:46			Creator / Model / Building	
S	1	5528-1		Canister with 700 pcs	Normal	F	2011-10-08 06:23:07	2011-09-21 12:59:05			Creator / Basic Set	
S	1	5766-1		Log Cabin	Normal	Ca	2011-10-08 06:21:02	2011-09-21 12:53:07			Creator / Model