Spreadsheet2bibtex

Simple python tool too manage a bibliography using Google Spreadsheets. You can retrieve bibtex from the title of the paper and add the bibtex to another column. You then can exporte the bibtex column in .bib file

Setup

1. Enable Google Sheets API

• Create a project in the Google Developers Console
• Enable the Google Sheets API in the project
• configure OAuth consent screen
• Authorize credentials for a desktop application
• Put the downloaded credentials.json in credentials/credentials.json
• create a .env file with the following env variable:

SPREADSHEET_ID="" # retrieve from the url
INPUT_RANGE="Main!D2:D100"  # Celss with titles/links in the format "[1234.56789] Your amazing ArxIv paper"
OUTPUT_RANGE="Main!K2:K100" # Cells where you want to write the corresponding BibTex

Installation

Install dependencies:

pip install -r requirements

The backend of this project is the doi2bibtex package. Check it out for the configuration of the bibtex entries.

Usage

To add to the spreadsheet the bibtex at column OUTPUT_RANGE just do:

python spreadsheets2bibtex.py

If you want to output the content of column OUTPUT_RANGE to an output.bib:

python spreadsheets2bibtex.py --bib

TODO

• [] Automatically substitute the Venue citations to the ArXiv one if exist
• [] Make installable from pip install
• [] Create a command line interface to set up the id and the input and output columns (save in ~/.config/spreedsheet2bibtex.conf)
• [] Expose to entire systems the program