Excel CSV vs XLSX: Which File Should You Use?

How-to basics · Updated November 19, 2026

CSV is best for exchanging simple, plain-text data; XLSX is best for keeping an Excel workbook’s sheets, formulas, formatting, and other features. Choose CSV when another system needs a straightforward data file, and XLSX when you or a colleague need to continue working with the spreadsheet in Excel.

What CSV and XLSX mean

CSV stands for comma-separated values. It is a text format that represents rows of data, with fields separated by delimiters—commas are common, though some programs use other separators. A CSV can be opened in a text editor as well as spreadsheet software. It does not contain an Excel workbook structure or instructions for how cells should look.

XLSX is Excel’s standard workbook format for modern versions of the program. An XLSX file can contain multiple worksheets and can preserve much of a workbook’s structure and appearance. Internally, it is a packaged file containing XML documents and related resources, rather than a simple text table.

The extensions describe different kinds of files, not different levels of spreadsheet quality. A CSV may be ideal for a clean export of records, while an XLSX may be necessary for a report whose formulas, layout, and charts matter.

What each format preserves

A CSV primarily preserves tabular values and their order: records are arranged in rows, and fields in each record are arranged in columns. It does not preserve worksheet names, multiple tabs, cell colors, fonts, column widths, borders, charts, images, data validation, or Excel tables. It also cannot retain formulas as working formulas. When Excel saves a worksheet as CSV, it writes the cell results as text values, so formulas are not available for recalculation after reopening the CSV.

An XLSX workbook can preserve formulas, cell formatting, multiple worksheets, charts, tables, and many other Excel features. It is the usual choice when recipients need to filter, sort, calculate, or present the data within Excel. It does not, however, support VBA macros. A macro-enabled workbook uses the XLSM format. Also, some advanced features may not work in other spreadsheet programs exactly as they do in Excel.

For example, imagine a workbook with a Sales tab, a Summary tab, a chart, and a formula that totals each salesperson’s orders. Saving a sheet as CSV does not turn that whole workbook into a portable text version: the CSV contains just one sheet’s data, without the chart or formula structure. Saving as XLSX keeps the workbook elements that the format supports.

How Excel handles CSV files

When you open a CSV in Excel, Excel displays its rows and fields in a worksheet grid. That view can make the file look like a normal workbook, but the underlying file is still plain text. If you edit it and save in CSV format, workbook-only features cannot be retained. Excel may warn that some features could be lost when you save.

Excel also tries to interpret fields as numbers, dates, or other types. This is convenient for ordinary data, but it can alter identifiers. A value such as 00127 may become 127, and a string that resembles a date may be displayed as a date. If the original text matters, import the file instead of relying on a double-click: in Excel for Microsoft 365 on Windows, choose Data > From Text/CSV, review the preview, and set the relevant column’s data type before loading. This gives you more control over delimiters, encoding, and column interpretation.

When saving, use File > Save As and select the format you need. Excel’s CSV options generally save the active worksheet, not every worksheet in the workbook. If you need to export several tabs, create a separate CSV for each one or keep the complete workbook as XLSX. The exact available CSV labels can vary by Excel version and locale.

When CSV is the better choice

CSV is useful when the recipient needs the data rather than the spreadsheet presentation. It is widely accepted by databases, reporting tools, programming languages, and online services. A plain-text file can also be inspected without Excel, and it avoids carrying workbook features that a destination system may not understand.

  • Importing or exporting records: A contact list, product catalog, or transaction export may need only rows and columns.
  • Moving data between systems: Many applications offer CSV because it is a common, relatively simple interchange format.
  • Automating data processing: Scripts and data tools can read text records without interpreting Excel-specific workbook features.
  • Sharing a static data snapshot: A CSV can communicate the values at the time of export, without relying on formulas or workbook settings.

CSV is not automatically the best option for every exchange. Confirm the receiving system’s expected delimiter, character encoding, column order, and date conventions. If the recipient needs a formatted report or must recalculate formulas, send XLSX instead.

When XLSX is the better choice

Use XLSX when the file is meant to remain a working spreadsheet. It is appropriate for analysis, budgeting templates, dashboards, reports, and shared workbooks where formulas or presentation are part of the deliverable. It can keep multiple related sheets together, so instructions, raw data, and summaries can live in one file.

XLSX is also a safer choice when column types matter. A workbook can store a code as text so leading zeros remain visible, and it can apply an explicit date or number format. Formatting alone does not always change the underlying value, but it helps make the intended display clear. For a data exchange, confirm that the other system can read XLSX and will interpret its contents correctly.

One important distinction: choosing XLSX does not guarantee that every recipient’s spreadsheet application will reproduce every feature perfectly. Basic values and formulas usually travel more easily than specialized features, external connections, or newer Excel functions. If broad compatibility is essential, test a copy in the destination software.

Common CSV problems and how to avoid them

Many CSV issues occur because plain text does not carry the extra instructions that spreadsheet users expect. A few checks before exporting can prevent confusing results:

  • Leading zeros disappear: Import codes, postal codes, and account identifiers as text. If Excel has already converted them to numbers and discarded zeros, changing the display format later may not restore the original characters.
  • Dates change meaning: A date such as 03/04/2026 can be interpreted differently depending on regional settings. Use a clearly agreed date convention, or import the column with a controlled type.
  • Commas split a field: A CSV writer should quote fields that contain delimiters, line breaks, or quotation marks. When importing, verify that the preview shows those fields in one column rather than several.
  • Characters look corrupted: Accented letters and symbols depend on encoding. When the source’s encoding is uncertain, use Data > From Text/CSV and select or verify the appropriate file origin rather than assuming Excel will identify it correctly.
  • Only one sheet appears: This is expected for CSV. Save each required sheet separately, or send the original XLSX workbook.

A useful habit is to keep an untouched source file and check the imported row count, headers, and a few representative values before using the data. If you edit a CSV in Excel, save a separate XLSX copy first when you may need formulas or formatting later.

Compatibility, file size, and collaboration

CSV’s simplicity often helps when exchanging plain data across different systems, but it is not a universal guarantee. Programs may disagree about separators, encodings, decimal marks, date formats, or how to handle blank fields. A CSV from one regional setup may use a semicolon as the separator, for example, so the receiving program must parse it accordingly.

XLSX is designed for spreadsheet work and can be more useful when a recipient needs the workbook itself. However, compatibility depends on the recipient’s application and version. If a workbook uses features unavailable in that software, some functionality may change or be omitted. For collaboration, XLSX is generally the practical choice when people need to edit several sheets or use formulas; a CSV is better suited to a one-way data handoff.

File size depends on the contents. CSV can be compact for plain tables because it stores little presentation information, but a large text file is not necessarily small. XLSX compresses its packaged components and may be compact too, particularly when it contains formatted tables. Do not choose a format based on extension alone if file size is a concern; compare representative files.

Security and privacy considerations

A CSV cannot contain Excel macros, but that does not make every CSV harmless. Spreadsheet programs may interpret a field beginning with a formula character as an expression when a user opens the file. This is sometimes called CSV or formula injection, and it is a concern when untrusted data is exported and later opened in a spreadsheet. Organizations that publish CSV downloads should consider how they handle untrusted fields.

XLSX files can contain formulas, links, and other workbook content, but not VBA macros; XLSM is the macro-enabled format. Treat unexpected files cautiously, especially if they request that you enable content or follow external links. For either format, share only the columns and worksheets the recipient needs, and inspect sensitive data before sending. A CSV can expose more than intended if the exported sheet includes hidden or unnecessary columns, even though it cannot preserve workbook formatting.

How to choose and convert

Make the decision based on what the recipient needs to do, not just on which extension is familiar:

  1. Identify the purpose. If the file is an import feed or a snapshot of raw records, consider CSV. If it is a workbook to edit, calculate, or present, choose XLSX.
  2. Check the receiving application. Follow its required format, delimiter, encoding, and column rules. A system’s import specification takes priority over general preferences.
  3. Protect important types and structure. Keep identifiers as text and preserve formulas, sheets, or charts in XLSX when those elements matter.
  4. Export a copy and verify it. Open or import the result in the intended destination and check sample rows, characters, dates, and totals.

To make a CSV from Excel, select the sheet to export, then use File > Save As and choose a CSV option, such as CSV UTF-8 (Comma delimited) when the recipient accepts that format. Review Excel’s warning about features that cannot be saved. To turn a CSV into an XLSX workbook, open or import it, correct any column types, and use File > Save As to choose Excel Workbook (*.xlsx). Converting to XLSX does not reconstruct formulas, formatting, or other information that was never present in the CSV.

Other formats to consider

If you need a text export but commas create problems, a tab-delimited text file may suit the receiving system, provided it accepts that format. If the workbook contains VBA macros, use XLSM rather than XLSX. For a fixed, print-ready document, PDF may be more appropriate than either spreadsheet format, though it is not designed for convenient data editing. The right choice depends on whether the priority is structured data, editable spreadsheet features, macro support, or a stable visual page.

Frequently Asked Questions

Does CSV save Excel formulas?
No. When Excel saves a sheet as CSV, it saves values rather than preserving working formulas. Keep an XLSX copy if you need to edit or recalculate those formulas later.

Can a CSV file have multiple sheets?
No. CSV represents a single table, not a multi-sheet workbook. Export each sheet as its own CSV or use XLSX to keep tabs together.

Why do leading zeros disappear in Excel?
Excel may interpret a field such as 00127 as a number and display it as 127. Import the column as text when the zeros are part of an identifier, and keep the original source if the exact text must be preserved.

Is XLSX the same as XLS?
No. XLSX is the modern XML-based Excel workbook format, while XLS is the older Excel binary workbook format. XLSX is the usual choice for current Excel work unless an older system specifically requires XLS.

Which format should I email?
Send XLSX if the recipient needs formulas, multiple sheets, or formatting. Send CSV if they asked for plain data or need to import records into another system. If unsure, ask what their software expects and include only the necessary information.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.