Export Books database

[macdos]

I have some 4500 books in Books.app, but it seems I can't export it as CSV or similar?

It also seems that the most fundamental of operations – copy – isn't available in the list view?

So how do I export the database? Can I somehow get into the sqlite file and get the data there?

 

[fivenotrump]

You can use a graphical sqlite browser or command-line:

foo@bar ~ > sqlite3 Library/Containers/com.apple.iBooksX/Data/Documents/BKLibrary/BKLibrary-1-091020131601.sqlite
sqlite> select ZTITLE from ZBKLIBRARYASSET;

Your db will probably have a different random number in the name but you get the idea...