Shopping at LEGO or Amazon?
Please use our links: LEGO.comAmazon
As an Amazon Associate we earn from qualifying purchases.

How to Download a Set List

BorgataBorgata Member Posts: 22
edited January 2013 in The Database
I've this little request, I hope it is licit!

I'd like to gather LEGO set's data from brickset's database, obtaining a text file that contains the following data:
- Theme / Subtheme(s)
- Set number
- Set name
- Release Year

Example (tab-delimited):

Category Name Number Name Year Released
Castle > Knights Kingdom II 8781-1 The Castle of Morcia 2004
Bionicle > Rahaga 4869-1 Rahaga Pouks 2005
City > Police 7235-1 Police Motorcycle 2005

Is it possible to obtain this list?


  • JosephJoseph Member Posts: 629
    edited January 2013
    I'm not very good with these kinds of things, so I may be way off; but you might want to take a look at:
  • BorgataBorgata Member Posts: 22
    I already took a look, but I hoped in something that don't requires to make a software to use it (or didn't I understood well?).
    I hoped in something like a download page, or something similar.

    PS: could someone fix the error in the title of the topic? I don't find the way to do that!
  • BorgataBorgata Member Posts: 22
    No one has any suggestion for my problem?

    Or perhaps is it impossible to obtain what I need?
  • The_IveysThe_Iveys Member Posts: 64
    Borgata, you may have to ask the admin for this. I can get the data you want (not the format, and some extraneous info - but generally your data) using the Advanced Queries interface under "More...". There is no way to export the data, though. What you need (I think) is an admin to run this query for you:

    SELECT Theme, Subtheme, Number, SetName, YearFrom FROM SETS
    ORDER BY Theme ASC, Subtheme ASC

    and export the data back out to you.

    If you want to see the query I designed, it's here:

    Good luck!

  • HuwHuw Administrator Posts: 7,076
    edited January 2014
    You can currently download the database at but that won't be available after the new site launches as I want to encourage use of the web services.
  • aceadon1aceadon1 Member Posts: 1
    Is it still possible to get an export of the database to something like .csv? I've tried the above link but nothing seems to happen.

  • HuwHuw Administrator Posts: 7,076
    The API is the preferred method of getting the data now.
Sign In or Register to comment.

Shopping at or Amazon?

Please use our links: Amazon

Recent discussions Categories Privacy Policy

Howdy, Stranger!

It looks like you're new here. Sign in or register to get started. is a participant in the Amazon Services LLC Associates Program, the, Inc. Associates Program and the Amazon EU Associates Programme, which are affiliate advertising programs designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.

As an Amazon Associate we earn from qualifying purchases.