About Robert

Robert Vesco

I'm a doctoral student at the University of Maryland's Robert H. Smith School of Business.

My research interests include understanding (a) why some areas are more entrepreneurial than others, (b) what drives people to pursue entrepreneurship, and (c) collaboration and innovation processes.

You can find my CV here

Using R to Extract Excel/csv File of Citation Data from Zotero

Zotero is a handy piece of software used to manage citations. However, one of issues I have with it is that there is no convenient way to export citation into excel. There are some folks that have put together some solutions here, here, and here, but they haven't been able to accomplish what I needed. Essentially, want I wanted was a way to review my citations, abstracts and a few other details easily. Two things about my solution. One it uses R, so you probably want to have some experience using that software, and two, you may want to have Zotero closed or make a copy of the sqlite file. Sometimes there are locking issues with the database if you try to access it from two different ways at the same time.

5 comments to Using R to Extract Excel/csv File of Citation Data from Zotero

  • Joe

    Thanks Robert.

    You need to update your package loading bit from
    022 reshape(reshape2)
    023 reshape(reshape)


    022 require(reshape2)
    023 require(reshape)

  • Robert Vesco

    Thanks! Not sure how that got in there ;)

  • Wouter

    Thanks, helped me a lot! I had to remove "bookTitle" from line 101 and comment out line 113 to make it work, otherwise it would give an "undefined columns selected" error (perhaps because that field is not used in any of my citations?).

  • Joe

    Wouter, I had to do the same thing as well.

    Robert, I'd like to display some of your code on a site for an R package that I am developing (http://code.google.com/p/r-systematic-review). I use it in addition to some of my functions.

    Can you please get in touch with me?


  • Agustin Lobo

    How could I actually create a subset of my "zotero-current.sqlite"?
    I want to transfer to csv just a selection of my citations, not the whole

Leave a Reply




You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">