Prepare a CSV delimiter for Excel import
Convert comma, semicolon or tab-separated records for an Excel import. Keep quoted fields and identifiers, with UTF-8 BOM and optional formula protection.
Why columns may appear in one cell
The expected separator depends on Excel import options and regional settings. Choose the actual input delimiter explicitly and then the desired output delimiter. No separator or number format is inferred from your region.
Preserve quoting and values
A comma inside a quoted address remains part of one cell. Output uses CRLF record boundaries and a UTF-8 byte-order mark. For example, id,name with 00123,Ada becomes semicolon-separated id;name and 00123;Ada without converting the identifier to a number.
Formula protection is visible
Protection is on by default and prefixes an apostrophe to formula-like cells and headers, including whitespace followed by =, +, - or @. This deliberately changes those exported values. Turn it off only for trusted content when exact cell strings are required.
Import rather than rely on a double click
Use Excel’s text/CSV import, select UTF-8 and the delimiter, and mark identifier columns as Text. A BOM helps with encoding but does not force Excel to preserve leading zeros, dates or long numbers. This is CSV output, not an XLSX workbook.
Validation and privacy
Headers must be non-empty and unique, and every record must have the same number of cells. Limits are 2 million input characters, 10,000 data records and 200 columns. Processing stays in the browser; no spreadsheet is uploaded or modified in place.