Bib file convertion to csv or Excel

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.

This is very easy:

1. Install JabRef. You find the download page here. JabRef is free software.
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.
• As of Nov 2018, I can't see an option to export in Excel format from JabRef? – seinecle Nov 14 '18 at 9:31
• Does the first way really work? For example, I have multiple entries in the excel file for publications with multiple authors (one for each author)... – Alex Mar 28 at 14:57

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}
\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.

There are at least 4 ways.