How the CSV to Excel Converter Works
AnyTool CSV to Excel performs the whole conversion in the browser. It reads each uploaded file with the File API, strips any UTF-8 byte-order mark, and detects the delimiter by counting commas, semicolons, tabs and pipes outside of quoted fields in a sample of the text (.tsv files default to tab). A hand-written RFC 4180-style parser then splits the text into rows and cells, correctly handling quoted fields, escaped double-quotes and both CRLF and LF line endings. Each cell is passed through a safe type-coercion step before the workbook is built with exceljs: the dynamically-imported exceljs library creates a Workbook, adds a worksheet per file, writes the typed rows, optionally styles and freezes the header row and auto-fits column widths, and finally serialises a real Open XML .xlsx with writeBuffer that downloads as a Blob.
- Delimiter auto-detection across comma, semicolon, tab and pipe, with manual override
- RFC 4180-style parser handles quotes, escaped quotes and CRLF/LF endings
- Genuine .xlsx written by exceljs (dynamically imported), not a renamed CSV
- Optional header styling, frozen header row and auto-fit column widths
- All parsing and workbook generation run in client-side JavaScript — no server round-trip
