bib_to_csv.py

from pybtex.database.input import bibtex
import string

#open a bibtex file
parser = bibtex.Parser()
bibdata = parser.parse_file("/Users/mcewen/AP/Docs/Bibtex/mybibs_new.bib")

# tralsator for removing punctuation
translator = str.maketrans('', '', string.punctuation)

# open our output file
f = open('mybibs_new.csv', 'w') 

# header row
f.write("Title, Year, Authors, Journal, Arxiv\n")

#loop through the individual references
for bib_id in bibdata.entries:
    b = bibdata.entries[bib_id].fields
    try:
        # change these lines to create a SQL insert
        title = b["title"]
        title = title.replace('{', '')
        title = title.replace('}', '')
        f.write('"' + title + '"')
        f.write(" ,")
        f.write(b["year"])
        f.write(" ,")
        #deal with multiple authors
        authors = ""
        for author in bibdata.entries[bib_id].persons["author"]:
            new_author = str(author.first()) + " " + str(author.last()) 
            new_author = new_author.translate(translator)
            new_author = new_author.replace('{', '')
            new_author = new_author.replace('}', '')
            if len(authors) == 0:
                authors = '"' + new_author
            else:
                authors = authors + ", " + new_author
        f.write(authors + '"')
        f.write(" ,")
        if 'eprint' in b.keys():
            f.write(b["eprint"])
        f.write(" ,")
        f.write('"' + b["journal"] + '"')

    # field may not exist for a reference
    except(KeyError):
        f.write(b["booktitle"])
        f.write("\n")
        continue
    f.write("\n")
    
# close output file
f.close()