Importing items from Excel?

mspotts6545
Is it possible to import items from an Excel spreadsheet (XLS, CSV, or other format) to my Zotero database? I know that you can export your own database information into that format, and was hoping to be able to upload a spreadsheet of different format. If not, is there a work-around beyond manually entering each item? Thanks in advance.
  • adamsmith
    Since data in Excel can have any sort of column in any order, the answer is generally no.
    However, if all items are of the same item type (e.g. all books or all journal articles) and have metadata in usable columns, there may be doable workarounds.
    Also, if all or most items have identifiers like ISBNs, DOIs, or PMIDs, you can use those to import.
  • x rolland
    An another way explained on another posts is to use the proprietary software EndNote, which is able to read tab delimited file and write RIS file (which is good recognized by Zotero).

    By this way you can even use the free online version of EndNote, EndNote Basic.

    Before, you have to format your tab delimited file.
    We exported data filtering "document type" one by one.

    You have to had two lines to your tab delimited file, as it could be understand by EndNote.
    1st line begins with an an * and tells the document type; for example:
    *Journal Article
    or
    *Book

    2nd line, which handle titles of the columns/fields, according to EndNote reference:
    Author→Year→Title→Journal→Volume
    (no space or anything else before or after each title. → is TAB)

    Take a look at :
    https://support.clarivate.com/Endnote/s/article/EndNote-Creating-a-Tab-Delimited-Import-Format?language=en_US

    Regards
Sign In or Register to comment.