{
  "$type": "site.standard.document",
  "bskyPostRef": {
    "cid": "bafyreifxpfqs2topmfwxphft7rz5klijuov7pzc6k5dp3f6lvmmpbi2jnq",
    "uri": "at://did:plc:25rdn5elo5izoxrmtis34zuk/app.bsky.feed.post/3mpicwcw7uys2"
  },
  "coverImage": {
    "$type": "blob",
    "ref": {
      "$link": "bafkreigwpiufetmwtexbzqbhmon2y7a6q6gzbiuzwj5a7zsi7qabqlw24i"
    },
    "mimeType": "image/webp",
    "size": 111404
  },
  "path": "/saurabh_shah/exporting-bibtex-to-csvexceljsonhtml-1ng",
  "publishedAt": "2026-06-30T05:22:00.000Z",
  "site": "https://dev.to",
  "tags": [
    "bibtex",
    "csv",
    "excel",
    "json",
    "BibTeX to CSV",
    "BibTeX to Excel",
    "BibTeX to JSON",
    "BibTeX to HTML"
  ],
  "textContent": "Sometimes you don't want a formatted bibliography, you want your bibtex as a spreadsheet or a JSON array you can pipe into something else. Four separate output formats, each solving a specific annoyance:\n\n**BibTeX to CSV** : writes a UTF-8 byte-order-mark at the start of the file. Sounds minor, but without it, Excel opens UTF-8 CSVs and garbles every accented character - your \"Krämer\" becomes \"Krämer\" with mangled bytes. One row per record (author/title/year/journal/volume/issue/pages/doi columns), CRLF line endings, so it's genuinely Excel-safe, not just technically valid CSV.\n\n**BibTeX to Excel** : same data, but as a real .xlsx binary instead of a CSV Excel might still mis-handle. Uses the exceljs library, lazy-loaded (~270 KB) only if you actually pick Excel as the output, so it doesn't bloat the page for everyone else. One file, downloads directly (no copy-paste, since it's binary).\n\n**BibTeX to JSON** : outputs CSL-JSON specifically, not some made-up JSON shape - CSL-JSON is the same format Zotero, Pandoc, citeproc-js, and Quarto/RMarkdown all use natively, so this drops straight into a Zotero import or a Pandoc pipeline. A lot of \"bibtex to json\" tools invent their own structure that nothing else reads.\n\n**BibTeX to HTML** : renders in APA style with actual tags for italics (not asterisks or nothing).\n\nAll four take the same input (paste bibtex), parsed once through citation.js into CSL-JSON, then written out in whichever format you pick.",
  "title": "Exporting BibTeX to CSV/Excel/JSON/HTML"
}