Excel and CSV: What’s the Difference?

How-to basics · Updated November 19, 2026

No. Excel is a spreadsheet application and workbook format, while CSV is a plain-text format for storing tabular data. Excel can open and save CSV files, but a CSV cannot preserve many of the features that make an Excel workbook an Excel workbook.

What Excel and CSV refer to

“Excel” can mean Microsoft’s spreadsheet program or, informally, a workbook created with it. A modern Excel workbook usually has an .xlsx extension; a macro-enabled workbook typically uses .xlsm. These files can contain multiple worksheets, formulas, formatting, charts, tables, and other workbook features. Excel is the software used to work with them, not just a file type.

CSV stands for comma-separated values. A CSV file is a text document that represents rows and columns as lines of text, with a delimiter between fields. It is not an Excel workbook and does not belong exclusively to Microsoft. Many database programs, websites, analytics tools, and spreadsheet applications can produce or read CSV files.

The distinction matters when someone says, “Send me an Excel.” They may want an editable workbook, or they may simply need the data in a format Excel can open. Asking which they need can prevent problems: an .xlsx file retains workbook features, while a .csv file is generally intended to exchange plain tabular data.

How a CSV file stores data

A CSV represents a table as text. Each line generally corresponds to a row, and a separator divides the values in that row. For example, a small contacts table might look like this:

Name,City,Visits
Mina,Leeds,3
Omar,"New York, NY",5

The quotation marks around “New York, NY” keep its comma inside one field rather than treating it as a separator. In common CSV conventions, a field containing a comma, a quotation mark, or a line break is enclosed in quotation marks; a quotation mark inside a quoted field is doubled. Not every program handles every variation identically, so CSV is simple but not entirely free of compatibility issues.

Despite the name, a CSV does not always use a comma in practice. Regional settings and software preferences can result in a semicolon or another delimiter, particularly where the comma is used as the decimal separator. The file may still be called CSV even when its fields are separated by semicolons. Text encoding also varies: UTF-8 is common, but older or region-specific encodings can affect how accents and other characters display.

CSV records values as text, not as fully defined spreadsheet cells. It does not reliably declare that 03/04/2026 is a date in a particular date system, that 00127 is an identifier, or that 0.15 is a percentage. The receiving application has to interpret the text, and its assumptions can change the result.

What an Excel workbook can do that CSV cannot

An .xlsx workbook can hold several sheets in one file. It can also store formulas, cell formatting, column widths, conditional formatting, charts, data validation, and many other features. A CSV holds one rectangular table of text values at a time. It has no native concept of a worksheet tab, a formatted header, a chart, or a formula that recalculates when inputs change.

For example, an Excel budget workbook might have one sheet for monthly transactions, another for category totals, and a chart that updates when new transactions are added. Saving that workbook as CSV cannot preserve the collection of sheets, the chart, or the formulas as working formulas. The exported file is a plain-text representation of the data from one sheet, not a portable copy of the whole workbook.

This does not mean CSV is inferior in every situation. Its limited structure is useful when a system needs a straightforward table without workbook-specific features. A CSV can be inspected in a basic text editor, generated by many kinds of software, and imported into databases or reporting tools. An Excel workbook is usually the better choice when people need to review calculations, presentation, or multiple related sheets.

Opening and saving CSV files in Excel

In Excel for Microsoft 365 on Windows, you can open a CSV using File > Open, or use Data > Get Data > From File > From Text/CSV to inspect and import it. The import route is especially useful when you need to choose a delimiter, check the preview, or control how columns are interpreted. Excel for Mac also supports opening and importing text files, though the exact available controls can vary by version.

To create a CSV from a workbook in Windows, use File > Save As and choose a CSV option from the file-type list, such as CSV UTF-8 (Comma delimited) (*.csv) when available. Excel may warn that some workbook features cannot be saved in the selected format. That warning is important: CSV saves the active sheet’s tabular data, not the entire workbook with all its features. If you need the original workbook intact, keep an .xlsx copy as well.

When Excel exports a sheet to CSV, formulas are generally represented by their calculated results, not preserved as live formulas. Formatting is not carried over as workbook formatting. A value that looks like a date or currency in the worksheet is exported as text in a representation chosen by Excel and its regional settings. On Mac, use File > Save As and select a CSV format if offered; wording and format choices can differ from Windows.

  • Keep an .xlsx master if you need formulas, formatting, multiple sheets, or charts.
  • Export a separate CSV copy when a service specifically requests a CSV upload.
  • After export, reopen or inspect the CSV to confirm the delimiter, characters, and values look right.

Common CSV problems when Excel opens data

The most frustrating problems often happen because Excel tries to be helpful and guesses what a column means. A code such as 00127 may become 127 if Excel treats it as a number, losing the leading zeros. Long numeric identifiers can also be rounded or displayed in scientific notation. Telephone numbers, product codes, and account references are usually identifiers, not quantities, so preserving them as text is often essential.

Dates can be ambiguous too. The text 04/05/2026 could mean April 5 or May 4, depending on regional conventions. Excel may convert it immediately when opening a CSV, making it hard to tell whether the original text was interpreted as intended. If you are importing data that must retain its original representation, use Data > Get Data > From File > From Text/CSV and check the preview and column types before loading it. Set identifier columns to text where the import controls allow it.

Other common issues include:

  • Wrong columns: a semicolon-delimited file opened as comma-delimited may appear in one column. Choose the correct delimiter during import.
  • Unreadable characters: names with accents or non-Latin characters may display incorrectly if the file’s encoding is not detected as expected. A UTF-8 CSV is often a good exchange choice, but confirm the receiving system accepts it.
  • Missing content: only one sheet’s data is exported, so information on other tabs is absent from the CSV.
  • Changed appearance: colors, number formats, and column widths are not part of the CSV data and will not be recreated when another program opens it.

When to choose Excel and when to choose CSV

Choose an Excel workbook when the recipient needs to work with the spreadsheet as a spreadsheet: edit formulas, inspect multiple tabs, use filters and formatting, or view charts. It is also the safer choice if you want to retain the calculations and structure for later editing. If the workbook contains macros, an .xlsx file will not preserve them; a macro-enabled .xlsm file is needed for that purpose.

Choose CSV when a website, database, or other application explicitly asks for it, or when you need a simple table that can move between different systems. It can be a useful export for a contact list, product catalog, or transaction table, provided the receiving system agrees on the delimiter, encoding, and expected columns. CSV is not automatically more accurate or safer; it simply carries less spreadsheet-specific information.

Before choosing, check the recipient’s instructions and ask what they need to do with the file. A system may require specific column names, a particular order, one record per row, or a defined date format. If it needs a clean data exchange, remove explanatory title rows and totals that are not part of the dataset. If a person needs to review the work, a workbook may be more useful than a bare export.

Privacy and security considerations

CSV is plain text, not an encrypted format. Anyone who can access the file can generally read its contents with a text editor, so avoid treating a CSV as protected storage for confidential information. Use an approved secure transfer method for sensitive data, and remove columns the recipient does not need. An Excel workbook is not automatically encrypted either; file access and protection depend on the controls applied to it.

There is also a spreadsheet-specific risk sometimes called formula injection. A CSV itself does not run formulas, but a spreadsheet application may interpret a cell beginning with characters such as =, +, -, or @ as a formula when the file is opened. This matters especially for CSV files built from untrusted user-submitted text. If you receive an unexpected CSV, do not assume every cell is harmless; use a trusted import process and treat unknown content cautiously. Organizations that generate CSV exports should follow their security guidance for safely handling potentially executable cell content.

Frequently Asked Questions

Can I open a CSV file in Excel?
Yes. Excel can open CSV files directly or import them through Data > Get Data > From File > From Text/CSV in Microsoft 365 for Windows. Importing gives you a chance to review the delimiter and how columns are read before loading the data.

Is an Excel file the same as an .xlsx file?
Not exactly. Excel is the application, while .xlsx is a common workbook file format used by modern versions of Excel. People often say “Excel file” to mean an .xlsx workbook, but Excel can also open or create formats such as CSV and the macro-enabled .xlsm format.

Does CSV save formulas?
Not as working formulas in the usual Excel export process. The CSV contains the sheet’s values, commonly the formula results as calculated at the time of saving. If the recipient must see or recalculate formulas, send a workbook format that supports them.

Why did Excel remove the zeros at the start of my CSV values?
Excel likely interpreted the values as numbers, and numbers do not retain leading zeros as part of their value. Import the relevant column as text when possible, or keep the original file unchanged and verify the imported data before using it. For IDs and codes, text is usually the appropriate representation.

Is CSV better than Excel?
Neither is universally better. CSV is often better for transferring a simple table between systems; an Excel workbook is better when you need formulas, formatting, multiple sheets, or charts. The right format depends on what the next person or program must do with the data.

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.