Convert XLSX to CSV Online (Export Spreadsheet Data)

Why a CSV Export Is Not a Smaller Workbook

XLSX and CSV both show rows and columns, but they describe those rows in radically different ways. An XLSX workbook is an Office Open XML package containing a workbook record and separate worksheet XML parts; it can also include styles, shared strings, tables, charts, comments, and formula records. A CSV file is plain text: each record is a line and its fields are separated by a chosen delimiter, usually a comma. There is no place in that text syntax to say that a cell is blue, that a column is hidden, or that a value is calculated from another cell. Microsoft’s Excel documentation is clear that CSV saves only the text and values as displayed in cells of the active worksheet. The export is therefore a deliberate flattening step for systems that want plain records, not a compression method for keeping an Excel workbook intact.

This distinction gives CSV a useful strength. A database import, bulk uploader, or script can read a simple ordered stream of fields without knowing Excel’s package structure or formula language. It also creates an important responsibility: decide which worksheet is the export sheet before converting, and keep the XLSX original as the editable record. If the workbook has three tabs, a CSV cannot represent all three in one ordinary file. A second CSV per tab, with clear names, is the honest way to export multiple sheets for a system that accepts separate files.

What Actually Survives When SpreadsheetML Becomes Text

In SpreadsheetML, a formula cell can contain formula text in <f> and a cached result in <v>. When that sheet is exported to CSV, the formula expression itself has nowhere to go, so the output is the displayed result, not a live calculation. If =SUM(B2:B10) currently displays 45, the CSV can contain 45; it cannot carry the rule that would update the total after another row is added. The same loss applies to conditional formatting, drop-down validation, comments, hyperlinks with their separate target information, charts, and column widths. SpreadsheetML can also use a shared-string table that stores one occurrence of each unique string across the workbook, but CSV simply repeats the character data in each needed field. None of this makes CSV defective; it makes it a text interchange file with a much smaller vocabulary than a workbook.

The phrase “as displayed” has a practical consequence that many export guides skip. A value formatted as a date, percentage, or currency can be written according to its displayed form rather than its original raw number, depending on how it is prepared and saved. That may be exactly what a receiving system expects, or it may turn a machine-friendly date into an ambiguous label. Prepare fields for the destination’s required format before export, and inspect the CSV in a plain-text editor as well as in Excel. Seeing the raw commas, quotes, line breaks, and characters avoids mistaking Excel’s friendly display for the actual contents sent to another program.

Exported text also has no workbook-level instruction that tells every reader how to interpret it. A receiving importer may decide whether the first row is a header, whether an empty field means blank or missing data, and whether a line ending starts a new record. Those choices belong to the destination’s import settings, not to an XLSX cell style. For that reason, a small trial file with a header, an empty field, a comma-bearing description, a quoted value, and a non-ASCII name is a more meaningful test than opening the file once in the same Excel installation that created it.

Six Changes a CSV Export Makes Deliberately

• One worksheet becomes one file: Excel’s CSV export writes the active worksheet, not a multi-tab workbook.
• Formula logic becomes a shown value: the CSV may contain 45, but not the =SUM(...) rule that produced it.
• Formatting disappears: colors, fonts, borders, widths, and conditional-format rules are not part of comma-delimited text.
• Cell boundaries depend on delimiters and quotes: a comma or line break inside data must be quoted correctly for the next program to keep it in one field.
• Identifiers need text treatment first: leading zeroes and long digit strings can already have been changed by Excel before the export is written.
• Character encoding becomes visible: a receiving application must read the same encoding used to save the text, especially for accented names and non-Latin scripts.

Which Programs Agree on CSV and Which Assumptions They Do Not

CSV is broadly accepted because it is simple, not because every program makes identical guesses about it. Microsoft says that when Excel opens a CSV file it uses the current default data-format settings to interpret each column. The same file can therefore open differently on computers whose regional settings use different date order, decimal marks, or list separators. Excel’s Text/CSV import path offers a preview and lets the user choose delimiter, data types, and other import settings; that is the safer route for a file returning to Excel. Microsoft’s newer IMPORTCSV function also explicitly expects comma delimiters and UTF-8 encoding, showing why delimiter and encoding should be stated rather than assumed.

Excel for Microsoft 365, Excel 2024, Excel 2021, Excel 2019, and Excel 2016 all have Microsoft guidance for text and CSV import or export. The compatibility issue is usually not whether these applications can open CSV, but whether they read the file using the same assumptions as the system that will receive it. A contact platform might require UTF-8 and literal commas, while a regional desktop setup may save a semicolon-separated text file when its system list separator is a semicolon. Check the importer’s field, delimiter, encoding, and header requirements first. A CSV that looks fine when reopened locally can still fail the destination because it is being parsed under a different rule set.

The CSV Problems Reported After an Apparently Successful Export

Missing zeroes are one of the most serious problems because they make an identifier look valid while changing its meaning. Microsoft explains that Excel removes leading zeroes when it converts numerical text to a number, and its current automatic-conversion controls can instead keep numerical data with leading zeroes as text. The same support guidance says that Excel normally retains only the first 15 digits of a long number, turning later digits to zeroes when it treats a 16-or-more-digit string as a number. Format product codes, account numbers, phone numbers, and other identifiers as Text before importing or entering them into the workbook; exporting them afterward cannot recover digits Excel has already discarded. Test a known zero-prefixed value and a long identifier in the final CSV before sending a full batch.

A second common support problem is a file that splits one address or description into extra columns. The root cause is not that commas are forbidden in data; it is that CSV needs a field containing a comma, quote, or line break to be quoted, with an embedded quote represented correctly. Another is a date that changes from 03/04/2026 to a different day when imported elsewhere. Microsoft gives the specific case of MDY source data being interpreted under a YMD default and recommends controlled text import when column handling matters. Use an unambiguous ISO-style date such as 2026-04-03 when the destination accepts it, and confirm its documented date rule rather than leaving the decision to automatic conversion.

Spreadsheet Package and Delimited Text, Field by Field

Questions Raised by Excel Users Exporting CSV

Does XLSX to CSV keep formulas?
No. Excel’s CSV format saves text and values from the active worksheet. The result of a calculated cell can be exported, but the formula text and its ability to recalculate are lost.

Why did only one tab appear in my CSV?
A normal CSV is one flat table. Excel exports the active worksheet, so export each required tab as a separately named CSV and retain the original XLSX workbook.

How do I stop Excel from changing a 16-digit ID?
Treat that column as Text before the value enters Excel. Microsoft documents a 15-digit precision limit for automatically converted long numbers, so changing the format after digits are lost is too late.

Why does the same CSV show a different date on another computer?
CSV does not carry a date type. Excel uses local default settings while opening it, so use the destination’s required date format or import through the Text/CSV preview and assign the column deliberately.