Set it up
Menu
Tutorial 9 of 10 · all tutorials

Import from CSV

  • Tutorial 9 of 10
  • 6 steps
  • Admins and members
On this page

The goal

By the end, a collection kept somewhere else will be in Brick Bin, one copy per box, without typing it in again.

Nothing is saved until you press Import. Before that you see, row by row, what will happen.

What you need

  • 1 ×A CSV file: a Rebrickable set list, a Brickset collection export, or any spreadsheet with a column of set numbers
  • 2 MBAt most, and 2,000 rows. Split a bigger file in two
  • 1 ×The imported catalog, if the file has LEGO sets. Import it first

Steps

  1. Open Import

    Import is in the sidebar. Choose the file under CSV file. Brick Bin reads it at once and shows a preview.

  2. Check the file format

    File format is detected from the column names: Rebrickable set list, Brickset collection, or Other CSV (choose the columns). Change it if the guess is wrong.

  3. Match the columns, for any other spreadsheet

    For Other CSV, say which column holds what. Only Set number is required. The rest are Name, Brand, Theme, Year, Pieces, Copies owned, Price paid, Notes, and Wanted, which puts the row on your wishlist instead.

    T09-01CSV import, choosing the columnsdesktop · 16:10 · light
    T09-01 · CSV import, choosing the columns
    Screen
    Import.
    State
    A spreadsheet chosen, File format set to "Other CSV (choose the columns)", columns matched.
    Viewport and theme
    Desktop, 1440 wide, light.
    Focus
    The column choices.
  4. Choose a build state

    Build state for the copies applies to every copy the file creates. Pick the most common one. The odd ones out can be changed afterward, one by one.

  5. Read the preview

    The Preview table shows each row, What happens to it, and any Problem. LEGO set numbers are matched against the catalog. Rows that can't be imported are skipped, and Download the rows that cannot be imported gives you them back as a file to fix.

    T09-02CSV import, previewdesktop · 16:10 · light
    T09-02 · CSV import, preview
    Screen
    Import, Preview.
    State
    Forty rows ready, two with a problem.
    Viewport and theme
    Desktop, 1440 wide, light.
    Focus
    The preview table, the two rows with a problem, and the Import button.
  6. Press Import

    Import finished says how many sets, copies, wishes and brands were added. Open the library to see them.

    No covers yet

    An import downloads nothing, so the new sets have no cover. Open a set to add one.

If something goes wrong

  • Import stays disabled. Nothing in the file can be imported. For Other CSV, check that Set number points at the right column.
  • "The catalog has not been imported yet" on every row. Rebrickable and Brickset files are LEGO lists, and every row is matched against the catalog. Import the catalog, then choose the file again.
  • "No brand, and the number is not in the catalog." In Other CSV, a row the catalog does not know needs a Brand column, and a Name.
  • The file is refused. It is over 2 MB or 2,000 rows. Split it and import each half.

Catalog data comes from Rebrickable.