How CSV-Importer works

    If you already have a rich collection of sets, you might fear recreating the collection here. In order to save time, i provide a convenient CSV-Importer, which works with Excel, Brickset or any other compatible format.

    To understand the csv format of mybricks, the easiest way would be to add some sets to your blank collection and use the export / backup function. The created csv file can then be opened in the editor of your choice and edited to your needs. After that simply upload the file. Every CSV upload will just add some sets but will never delete something!

    Import via Brickset

    If you have a Brickset-Account and already collected sets there, just export them and upload them here. Easy as that! Hit the “Export” Button and pick “As CSV” or “As tab separated”. Save the file to your hard drive and upload it in our importer. It should just work. If you want to understand more about the options, continue reading…

    If you have many sets of one set with the same condition, you can insert one row for each item or you can use the quantity column like:

    Number,"","","","","","","","","","","","","","","","","","Qty owned"
42100,"","","","","","","","","","","","","","","","","",5

    Or just use the same setting in Brickset. It will created the CSV-column for you:

    Then it will insert the item five times:

    Additional values: By default every set will have the best condition. If you want to insert or change the condition of one set, use column 21 which is used by Brickset as “Flag 1” field. We use values between 0 (New, sealed) and 6 (Used, bricks missing).

    Setnumber,"","","","","","","","","","","","","","","","","","Quantity","","","Condition"
42100,"","","","","","","","","","","","","","","","","",1,"","",6

    In this case it will insert the Liebherr Excavator with the worst condition:

    More additional fields: use column 22 (which is used by Brickset as “Flag 2” field) to insert your purchase price. And column 23 (which is used by Brickset as “Flag 3” field) the date when you bought it. You can insert Year, Year-Month or Year-Month-Day.

    Setnumber,"","",Year,Name,"",Pieces,"","","","","","","","","","","","Quantity","","","Condition","My Price","Date Buy"
42100,"","",2019,"Liebherr R 9800","",4108,"","","","","","","","","","","",1,"","",2,300,"2019-06"

    This will insert it with all necessary data:

    All other columns (“”) are skipped and are unused. If you exported the file from Brickset, leave the columns as they are. You don’t have to clear them!

    Go to sets page, hit file uploader and pick the downloaded file.

    Import via Excel

    There is a sample file. Try to build your custom Excelfile like this. This is the format we use for ex- and import. It is easy to understand and to maintain.

    If you do not want to use this file, i will guide you through the following options.

    Creating the file from scratch:

    First row should be the table header. Continuing with the second row where you insert your sets. You don’t need to insert all details. You can have empty rows – they will be skipped.

    At least content you need to insert a header with your custom label and one set-number like:

    Setnumber
    42100

    If you upload a file with this content, you will import one set: 42100. If you have more sets, simply add one per line like:

    Setnumber
    42100
    40367
    40378

    This will insert three sets and so on…

    If the title is missing, my script tries to guess the name. If you want to define the title – for instance in your specific language, add the value to the csv file like

    Setnumber, Setname
    42100, Liebherr Excavator
    40367, Lady Liberty
    40378, Goofy & Pluto

    If you want to add the amount of pieces to the csv file, just insert them in the next column like. Otherwise my script inserts the pieces from the database.

    Setnumber, Setname, Pieces
42100, Liebherr Excavator, 4.108
40367, Lady Liberty, 153
40378, Goofy & Pluto, 214

    The following columns are available. And if you have many items of one set, use the last (quantity) column like this:

    Setnumber, Setname, Pieces, Price Purchased, Price new, Date Purchased, Date added, Date released, Condition, Date sold, Price sold, Noted, Quantity
42100, Liebherr Excavator, "", "", "", "", "", "", "", "", "", "", 5

    Export the Excel-File

    If you export your file, you should only use ONE of the following separators:

    • comma ,
    • semicolon ;
    • pipe |
    • tab

    General Information

    At the moment we don’t officially support Minifigures! The main purpose of mybricks is to collect whole sets.

    We do not support sub-sets with “-2” or “-3” suffix. We only accept the common set suffix “-1”. Therefore you do not need to add “-1” in the search field or to the csv-file. We will remove it during import.

    Import is limited to 2000 items at once! If you have more, try to split them in separate files.

    If a setnumber is missing or has wrong format, the whole line gets skipped!

    Write a comment: