Bib file convertion to csv or Excel

Question

I have a large .bib file and need to analyze which keywords are used in which bibliography entry. Therefore I am looking for a "tool" to convert the .bib file to CSV or XLS format.

I need a CSV which have information about:

• CitationID (=Name of the biblatex entry)
• Title
• Keywords.

Answer 1

This is very easy:

1. Install JabRef. You find the download page here. JabRef is free software.
2. Load your bib-file into JabRef, i.e. Choose “Open database” from the file menu.
3. For security reasons, save the database under a new name (File; Save As) so you work on a copy (better safe than sorry if you do something wrong)
4. Open the file menu, choose “Export” from the options, and choose the file format you want to export to. Excel 2007 is one of the options.
5. If you need to clean up or manipulate the resulting file, export to CSV-files and use Sam Franche’s CSVed or uniCSVed if you are on Windows.

Answer 2

You do not need at all export the .bib file to .csv or .xls format.

It is possible print references by keywords with LaTeX (cited or not in the text) using biblatex.

Example: Suppose that all references have fields as keywords = {XX} or keywords = {XXI} to distinguish what was published in each century. Then you want to show only the cited papers of the XX century.

\documentclass{article} 
\usepackage{biblatex} 
\addbibresource{file.bib}
\begin{document} 
Bla bla \cite{Guy1998} and \cite{Guy2012}
\printbibliography[keyword=XX]
\end{document}

This should print only the reference of Guy1998. To show also the not cited references of the XX century, add \nocite{*} before of \printbibliography. You can use this command several times.

Remember that by default you should compile the biblatex bibliography with biber(not with bibtex), after compiling with pdflatex and then compile with pdlatex at least two times more in complex documents to solve all the cross-references. No so easy, but with biblatex you can also ignore some fields of the references, if that matter.

Answer 3

There are at least 4 ways.

1. Using JabRef. You can follow Sveinung's answer.
2. Using LaTeX. As explained by Fran.
3. Using Zotero. The poin is to read the data inside the Zotero SQL and save it as csv. Read the procedure had been prepared by Roy(2018) here: http://roycekimmons.com/tutorials/zotero_to_excel
4. Using Direct Citation (References). The idea is to read the reference directly to excel based on the available delimiter. The example of using MLA reference format had been writted by Brennan(2016) here: http://doi.org/10.3163/1536-5050.104.1.012