BibTeX to Excel Converter
Free. No signup. Runs in your browser.
Paste or upload a .bib file and download a real Excel workbook (.xlsx), not a CSV file renamed. Every entry becomes one row under the same 14 columns, with a bold header row and accents intact. It opens in Excel, Google Sheets, Numbers and LibreOffice.
How to convert BibTeX to Excel
Step 1
Add your BibTeX
Use Upload file, drop the .bib on the box, or paste the entries.
Step 2
Convert
Excel is already selected on this page.
Step 3
Download the .xlsx
and open it.
Your .bib is read and converted in your browser, never on our server.
The columns
Every row has the same 14 columns, filled where the entry has the information and left empty where it does not:
type, citation_key, title, authors, year, journal_or_booktitle, volume, issue, pages, doi, isbn, issn, publisher, url
- type is the BibTeX entry type (
article,inproceedings,book...). - authors are in one cell, separated by " and " as in BibTeX ("Smith, John and Doe, Jane"), so a name with a comma never splits into two people.
- pages is the full range, such as 436-444.
Where most BibTeX to Excel converters break
A CSV file with an .xlsx name
Many "Excel" exports are CSV files renamed. Excel then warns that the format and extension do not match, and other spreadsheet apps may refuse the file. This converter writes a real .xlsx workbook.
Accents turn into symbols
Opened in Excel on Windows, a plain CSV can turn "Krämer" into "Krämer". A real .xlsx stores text in a way Excel always reads correctly, so accents stay as they are. LaTeX accent macros like Kr{\"a}mer are decoded first.
Every row has different columns
Converters that copy whatever fields each entry has give rows of different shapes, which spreadsheets sort and filter badly. Here every row has the same 14 columns.
Frequently asked questions
Upload the .bib file in the converter above, or paste its entries, and press Convert. Download the .xlsx workbook and open it in Excel or Google Sheets.
The same 14 columns either way. Pick Excel to open the file in a spreadsheet app. Pick CSV to read it with a script (Python, R) or import it somewhere that expects CSV.
Yes. Upload it to Google Drive or use File > Import in Sheets; Numbers and LibreOffice open .xlsx files directly.
Not from the spreadsheet itself. If your sheet has a DOI column, copy the DOIs and paste them into the DOI to BibTeX converter: it looks each one up and gives you clean BibTeX entries, up to 50 at a time.
If an entry has a syntax error, the result lists it with its line number and reason, and the other entries still convert. Look for a missing closing brace or comma. If the text is RIS, an EndNote or NBIB export, the converter offers to switch the input.
It is free and needs no signup. Your .bib is read in your browser and never sent to our server.
Need the whole paper formatted in LaTeX?
Our LaTeX experts format papers and theses for journals and universities by hand, with no upfront payment. 1,100+ clients in 40+ countries.
See our LaTeX services