XLSX to CSV Converter
Convert one Excel workbook sheet to CSV in your browser, choose delimiters and formula handling, and catch hidden-data or size warnings.{{ csvPreview }}
| Sheet | Selected | Visibility | Used range | Rows | Columns | Data cells | Formulas | Copy |
|---|---|---|---|---|---|---|---|---|
| {{ row.sheet }} | {{ row.selected }} | {{ row.visibility }} | {{ row.usedRange }} | {{ row.rows }} | {{ row.columns }} | {{ row.dataCells }} | {{ row.formulas }} | |
|
No workbook sheets loaded
Browse or drop an Excel workbook to inspect sheet rows before exporting.
|
||||||||
| Check | Status | Detail | Action | Copy |
|---|---|---|---|---|
| {{ row.check }} | {{ row.status }} | {{ row.detail }} | {{ row.action }} | |
|
No conversion checks yet
Load a workbook and choose a sheet to review CSV readiness checks.
|
||||
CSV is the plain-text handoff people often need after spreadsheet work is finished. A workbook can hold several sheets, formulas, hidden staging rows, formatted dates, charts, comments, filters, and workbook-specific settings. A CSV file keeps only records and fields, so a good conversion starts by deciding which table should survive and which workbook features should be reviewed before export.
Excel files such as XLSX, XLSM, XLSB, and XLS are closer to containers than simple tables. One worksheet may be the finished import sheet, another may be a summary, and another may hold temporary calculations. CSV is narrower: each line is a record, each separated value is a field, and the destination system decides how to interpret those fields.
| Decision | Why it matters | Common mistake |
|---|---|---|
| Worksheet | Only one sheet becomes the CSV file. | Exporting a summary or staging tab instead of the import table. |
| Delimiter | Importers may expect comma, semicolon, tab, or pipe-separated text. | Using comma when the destination expects a regional semicolon file. |
| Formulas | Cells can carry saved results and formula expressions. | Assuming cached values were recalculated just before export. |
| Hidden data | Hidden rows or columns can still contain exportable values. | Sending cleanup rows or private notes because they were hidden on the sheet. |
Delimiter choice can decide whether the destination reads one clean table or a broken set of columns. Comma-separated files are common, but semicolon files appear in some regional spreadsheet workflows, and tab or pipe files are common in older business systems, logs, and scheduled imports. The correct delimiter is the one the receiving system expects.
The final text can hide risky details from the original workbook. Dates may lose display style, account numbers can lose leading zeros in a receiving app, blank rows can shift row-number comparisons, and hidden rows or columns can include values the sheet owner did not intend to send. Formula cells deserve extra care because a workbook can store both the expression and the last saved result.
CSV is not a workbook backup and not proof that the spreadsheet is correct. It is an interchange file. Safer conversion means choosing the intended sheet, matching the delimiter, checking formulas and hidden data, and testing a small import before relying on the output for production records.
How to Use This Tool:
Load one workbook, confirm the sheet, then review the CSV preview and checks before copying or downloading the output.
- Use Source workbook to browse or drop one XLSX, XLSM, XLSB, or XLS file. The status moves from No workbook selected. to a loaded sheet count when parsing succeeds.
- Resolve source problems before continuing. Unsupported extensions, empty workbooks, unreadable files, and files above the 50 MB browser-side cap block conversion.
- Choose Sheet for the worksheet that should become CSV. If no valid sheet is selected after loading, the first visible sheet is used, or the first available sheet when none are marked visible.
- Set Delimiter to the separator required by the destination: comma, semicolon, tab, or pipe. Check Converted CSV to see whether the first records have the expected shape.
- Use Date format only when date-like cells need a specific pattern such as
yyyy-mm-dd. Leave it blank when workbook display text is the safer default. - Open Advanced for workbook-specific choices: Formula cells, Filename prefix, Blank rows, Trim trailing delimiters, Hidden rows/columns, and UTF-8 BOM.
- Review Workbook Sheets and Conversion Checks. Wrong-sheet, formula, hidden-data, parser, file-size, and waiting-output messages are the main signs that the CSV is not ready.
- When Converted CSV shows the expected rows and the checks are acceptable, use Copy CSV or Download CSV. Treat the sheets and checks tables as review evidence, not as substitutes for the converted file.
Interpreting Results:
Converted CSV is the handoff text. Row count, byte size, and delimiter label are useful checks, but they cannot prove that every field will import correctly. Scan the first few records, confirm the separator, and pay special attention to dates, IDs, quoted notes, and empty right-edge cells.
Workbook Sheets catches wrong-tab mistakes. Compare Selected, Visibility, Used range, Rows, Columns, Data cells, and Formulas against the source workbook before trusting the export.
Conversion Checks should be read as review prompts. A ready CSV can still contain cached formula values, included hidden rows or columns, or a delimiter that the destination will reject.
The final proof is the receiving system. Spreadsheet apps, database importers, and vendor portals can disagree about delimiters, quote handling, embedded line breaks, character encoding, and formula-looking cells.
Technical Details:
CSV represents records and fields, not workbook structure. RFC 4180 describes the common comma-separated form where records are separated by line breaks, fields are separated by commas, and fields containing commas, double quotes, or line breaks are enclosed in double quotes with embedded quotes doubled. Real importers often accept CSV-like dialects with semicolon, tab, or pipe separators, so the delimiter is part of the file contract.
Workbook-to-CSV conversion is lossy by design. Formatting, charts, comments, filters, page setup, macros, workbook settings, and most layout context do not become CSV records. The meaningful technical question is whether the selected worksheet cells produce the rows and fields the destination expects.
Formula cells require a deliberate choice. Cached visible values suit ordinary imports because they contain the saved results. Formula text suits audit review because it exposes the expressions. Neither choice recalculates the workbook, and neither sanitizes spreadsheet data that could be risky when reopened in another spreadsheet program.
Transformation Core:
- Read one supported workbook in the browser and list its worksheets with visibility, used range, row count, column count, data cell count, and formula count.
- Select the requested worksheet. If the requested sheet is blank or missing after load, use the first visible worksheet, or the first worksheet when none are marked visible.
- Prepare formula cells according to Formula cells: cached visible values for normal CSV handoff, or formula text for audit-style output.
- Generate text with the selected delimiter, newline records, blank-row policy, trailing-delimiter policy, date pattern, and hidden-row or hidden-column policy.
- Add a UTF-8 byte-order mark only to downloaded CSV text when UTF-8 BOM is on; the preview remains the plain CSV body.
| Rule or term | Meaning | Conversion implication |
|---|---|---|
| Record | One row in the output text. | Row count should match the selected worksheet after blank-row and hidden-row choices are considered. |
| Field | One separated cell value inside a record. | Column order comes from the selected sheet's used range. |
| Delimiter | The separator between fields. | Comma, semicolon, tab, and pipe choices change the generated text. |
| Quoting | Special fields are enclosed in double quotes, with embedded quotes doubled. | Addresses, descriptions, and notes can stay one field when the destination honors quoting. |
| Header row | A first record that names fields when the worksheet uses one. | Headers are exported only when they already exist on the selected sheet. |
| Workbook feature | CSV consequence | Review cue |
|---|---|---|
| Multiple worksheets | Only the selected worksheet becomes the CSV. | Confirm Sheet and Workbook Sheets before export. |
| Formula cells | They export as cached values unless formula text mode is selected. | Review formula warnings when saved results may be stale. |
| Date-like cells | Workbook display is used where available unless a custom date pattern is supplied. | Test the date column in the destination importer. |
| Hidden rows and columns | They are included unless hidden markers are available and Hidden rows/columns is on. | Use the hidden-data check before vendor, audit, or public handoff. |
| Blank rows and right-edge empty cells | Blank rows can be preserved, and trailing delimiters can be trimmed. | Preserve blanks for row-number comparison; trim trailing delimiters for compact import files. |
| UTF-8 text | Downloads can include a UTF-8 byte-order mark while the preview stays unchanged. | Keep the marker on when a spreadsheet app needs help detecting UTF-8 characters. |
| Area | Boundary | Failure or warning behavior |
|---|---|---|
| Source type | One XLSX, XLSM, XLSB, or XLS workbook. | Unsupported extensions are rejected before parsing. |
| File count | One workbook at a time. | Extra dropped files are ignored and a warning is shown. |
| File size | 50 MB browser-side cap. | Oversized workbooks are blocked before conversion. |
| Worksheet availability | The workbook must expose at least one worksheet. | Output waits until a selectable worksheet is available. |
| Generated text | The selected worksheet must produce non-empty CSV text. | An empty or out-of-range sheet shows a waiting/error message instead of ready output. |
Limitations and Privacy Notes:
The selected workbook is read in the browser session for parsing and CSV generation, with no separate workbook upload step in the conversion path. The workbook parser can load on demand before processing starts, so a network connection may still be needed to start conversion.
- Formula results are not recalculated. Use cached values only when the workbook was saved with current results.
- Hidden-row and hidden-column skipping depends on hidden markers that the workbook exposes to the parser.
- CSV files opened in spreadsheet apps can treat formula-looking cells as formulas. Review untrusted data before sharing or reopening it.
- Downloads, copied text, and browser history are still subject to the device and account controls you normally use for confidential spreadsheets.
Advanced Tips:
- Keep Blank rows on when row numbers must match the source sheet during review or audit comparison.
- Turn on Trim trailing delimiters when the destination rejects empty right-edge fields or expects compact rows.
- Use formula text mode for audit files, then switch back to cached visible values for ordinary imports that need saved results.
- Set a safe Filename prefix when downloading several sheets from the same workbook, so each file name remains clear.
- Leave UTF-8 BOM on when recipients open the file in spreadsheet apps that may otherwise misread non-ASCII text.
Worked Examples:
Monthly orders import
A workbook named orders_april.xlsx contains Summary, Orders, and Returns sheets. After loading it, Sheet is set to Orders. Workbook Sheets shows Orders as selected, visible, and a used range of 1,245 rows by 18 columns. With Delimiter left on comma, Converted CSV reports 1,245 rows, and the first records should show the order ID, date, customer, and total columns before the file is used for an import dry run.
Supplier prices with formulas
A supplier workbook has a Prices sheet with 420 rows, 9 columns, and 36 formula cells. The destination expects semicolon-separated text, so Delimiter is changed to semicolon. Conversion Checks reports formula cells as cached values, which is acceptable only if the supplier saved the workbook after recalculation. For an audit copy, switching Formula cells to formula text makes the expressions visible in the CSV preview.
Hidden cleanup rows before handoff
An Import sheet contains 12 hidden row or column markers. With Hidden rows/columns off, the checks report hidden content as included, and those values can appear in Converted CSV. Turning the option on changes the check to skipped when the workbook exposes the markers. The output is safer for a vendor handoff, but it still deserves a source-sheet comparison.
Workbook too large for browser conversion
A 62 MB XLSX file is dropped into Source workbook. The source status reports that the file exceeds the 50 MB cap, Workbook Sheets stays empty, and Converted CSV remains waiting. Saving only the needed worksheet into a smaller workbook gives the converter a valid source while keeping the same delimiter and date-format choices.
FAQ:
Can I convert every worksheet at once?
No. The converter generates CSV for one selected worksheet. Use Sheet and Workbook Sheets to choose the tab, then repeat the process for another sheet if needed.
Does the workbook get uploaded?
No separate workbook upload step is used for conversion. The selected file is read in the browser session, though the parser may load on demand before processing starts.
Why do formula cells need review?
Formula cells export as cached visible values unless Formula cells is changed to formula text. The conversion does not recalculate formulas, so cached values should be trusted only when the workbook was saved after recalculation.
Which delimiter should I choose?
Choose the separator required by the destination. The available choices are comma, semicolon, tab, and pipe, and Converted CSV updates after the delimiter changes.
Why are hidden rows or columns still included?
Hidden rows and columns remain included unless Hidden rows/columns is on and the workbook exposes hidden markers that can be skipped.
Why did my workbook fail before conversion?
The source must be one XLSX, XLSM, XLSB, or XLS workbook under the 50 MB cap. Unsupported extensions, oversized files, empty workbooks, unavailable parser support, or unreadable files can block output.
Glossary:
- CSV
- Delimited text where each row is a record and each separated value is a field.
- Delimiter
- The character between fields, such as comma, semicolon, tab, or pipe.
- Workbook
- The spreadsheet file that may contain multiple worksheets and workbook-only features.
- Worksheet
- One sheet tab inside a workbook; only the selected worksheet becomes the converted CSV.
- Used range
- The worksheet area that contains the cells the parser treats as active data.
- Cached value
- The saved result stored with a formula cell, used when formula cells export as visible values.
- Formula text
- The expression stored in a formula cell, exported as text when audit-style formula output is selected.
- UTF-8 byte-order mark
- A short marker that can help some spreadsheet apps recognize UTF-8 text in downloaded CSV files.
References:
- Common Format and MIME Type for Comma-Separated Values (CSV) Files, Internet Engineering Task Force, October 2005.
- Save a Workbook to Text Format (.txt or .csv), Microsoft Support.
- Excel Formatting and Features That Are Not Transferred to Other File Formats, Microsoft Support.
- CSV Injection, OWASP Foundation.