How to use CSV and XLSX Converter
- Choose CSV to XLSX, one XLSX sheet/area to CSV, or all nonempty sheets to a CSV ZIP.
- Provide the source file or paste CSV for workbook creation. A chosen file replaces pasted CSV; check the separator.
- For CSV to XLSX, choose the output sheet name and whether to infer safe numbers, booleans and ISO dates. Turn inference off to keep every value as text.
- For one-sheet export, select the worksheet number and optional rectangle, such as A1:D100. Decide whether recognized date/clock styles should become ISO values.
- Convert and inspect the preview and warnings. Download converted.xlsx, selected-area.csv or workbook-csv.zip, then check identifiers, dates and saved formula values in the destination.
Example: CSV and XLSX Converter
Create an Excel worksheet from two ISO-dated CSV rows with safe type inference enabled.
Options
- Pasted CSV
- The first CSV record supplies distinct, nonblank worksheet headings. Quoted commas and line breaks remain inside their cells. This converter accepts up to 2,000 characters per CSV cell.
- Store numbers, booleans and ISO dates as Excel values
- Safe decimal values with at most 15 significant digits; YYYY-MM-DD dates from 1900. Leading-zero IDs, large integers and formula-like cells stay text. Turn off to preserve all text formatting.
- XLSX worksheet number
- One-based workbook order, including hidden sheets. Ignored for all-sheet ZIP.
- XLSX rectangular area (optional)
- Example A1:D100. Blank uses the stored area. First row becomes the CSV header. Merged cells are refused. Applies to one-sheet mode only.
- Convert date and clock styles to ISO values
- Uses the workbook’s 1900 or 1904 date system. Unsupported number formats stay raw. Excel’s fictitious 1900-02-29 is kept as that label.
- Named worksheet preview
- Choose an XLSX file in an input-workbook mode to list its sheet names. The chosen name overrides the worksheet number. Preview up to 30 rows of the selected stored range and columns.
- Export columns, delimiter and encoding
- List exact headers one per line in the required order. CSV exports support comma, semicolon or tab and UTF-8 or UTF-16 with a byte-order mark.
Supported inputs and limits
- CSV uses up to 20 MiB, 100,000 data rows, 500 columns and 2,000,000 cells.
- XLSX uses 20 MiB compressed, 32 MiB expanded, 1,000 parts, 20 sheets and 100,000 stored cells.
- Numeric/date inference can be turned off; leading-zero IDs, long numbers and formula-like strings stay text.
- Recognized date/time styles use the workbook 1900 or 1904 system.
- Saved formula results are not recalculated; missing results or selected merged cells refuse export.
More details
All-sheet export writes one CSV per sheet in a ZIP.
CSV protection prefixes risky strings.
Selecting columns applies to both XLSX and CSV output.
In all-sheet mode, each selected header must exist in every exported sheet.
The preview reads stored values, includes hidden rows and columns, and never recalculates formulas.
Where your input is processed
This tool does not upload your inputs. See the limits for anything saved on your device.
Choose inferred values or text deliberately
CSV does not declare cell types. With inference enabled, this tool writes supported decimal numbers, booleans and ISO dates as Excel values while retaining leading-zero IDs, long numbers and formula-like strings as text. Disable inference when original text formatting matters more than typed spreadsheet values. Neither choice creates formulas.
A selected workbook area has strict refusal rules
A worksheet export reads saved values rather than recalculating formulas. A usable cached result can be exported, but a missing result or an intersecting merged area stops the conversion. Dates follow the workbook's 1900 or 1904 system when style conversion is enabled; unsupported number formats stay raw. Hidden rows and columns are included. CSV cannot preserve charts or arbitrary workbook formatting, and formula protection can prefix exported text.
Questions about CSV and XLSX Converter
Will a leading-zero account number change?
No. Safe type inference keeps values such as 0012 as text. You can also turn inference off to store every cell as text.
Are Excel formulas recalculated?
No. Workbook export reads the last saved result. A formula without a usable saved value refuses conversion so a missing result cannot become an unexplained blank.
Can I export every worksheet?
Yes. All-sheet mode writes one CSV per worksheet in a ZIP. Recognized date/time styles use the workbook date system, and merged areas must be corrected before table export.