Importing from Excel or other spreadsheet files (e.g. LibreOffice Calc)


I would like to request a feature, which seems to be missing from this great software:

an ability to easily import bibliography files created in programs like Excel, LibreOffice Calc, and other similar ones, or at least, files in CSV format.

In the Help section, there is an option to create a custom import filter, and a “A simple example” of creating
This is, probably, a good suggestion for people with basic coding skills – for the rest of us, it is a useless suggestion.

Many people have their bibliography lists in Excel or similar formats created years if not decades before JabRef appeared, and would love to migrate to it, but just don’t want spend countless hours re-creating their existing bibliography from the scratch in JabRef.


(Christoph) #2


JabRef has no Importer for CSV, and the code in the example is outdated. However, it seem some other users managed to get it working again in this thread:
The biggest problem is that there is no true CSV format standard for bibtex as it simply depends on the format of the csv, e.g. how you structured it.
The easiest solution is to try manually/semi automatically use identifiers like DOI, Arxiv or PMID, ISBN etc. to get the bibtex data from it.

DOI would be the easiest option.
See this discusion for an example: