CSV is a plain-text format for storing rows of values, while Excel is spreadsheet software that can work with CSV files and its own workbook formats, such as XLSX. Use CSV when you need a simple, widely compatible data export; use an Excel workbook when you need multiple sheets, formulas, formatting, charts, or other spreadsheet features.
What CSV means
CSV stands for comma-separated values. A CSV file represents a table as lines of text: each line usually corresponds to a row, and separators divide the values in that row. For example, a small contact list might look like this:
Name,City,Member
Ari,Denver,Yes
Mina,Oslo,No
Despite the name, commas are not the only separators used in files called CSV. Some exports use semicolons or tabs, and software may choose a separator based on regional settings. Values containing a comma, a line break, or a quotation mark need special handling so that a program can tell where a field begins and ends. A common convention is to put such a value in double quotes and represent an internal double quote by doubling it.
CSV stores text, not a fully described spreadsheet. It does not inherently preserve cell colors, column widths, formulas, multiple tabs, or Excel-specific data types. It is a convenient way to pass tabular data between programs, but the receiving program may need to infer whether a value is a date, number, or text.
What Excel means
Excel is a spreadsheet application, not a file format. In Excel for Microsoft 365 on Windows, the usual workbook format is XLSX. An XLSX workbook can hold several worksheets, formulas, formatting, tables, charts, and other workbook content. Excel can also open and save other formats, including CSV and the older XLS format.
An Excel workbook is therefore more than a grid of values. A cell can contain a formula whose result changes when related cells change; a number format can display a value as a date or currency without changing the underlying value; and separate worksheets can organize related information in one file. These capabilities are useful for analysis and presentation, but they also make a workbook more complex than a simple text export.
People often say they have an Excel file when they mean an XLSX workbook. They may also mean a CSV file that they opened in Excel. The distinction matters: opening a CSV in Excel does not turn the file format into XLSX. It remains CSV until it is saved in a workbook format.
CSV vs Excel: the practical differences
The main difference is how much structure the file can preserve. CSV is deliberately limited; an XLSX workbook can retain spreadsheet features. The table summarizes what that means in everyday use.
| Feature | CSV | Excel workbook (XLSX) |
|---|---|---|
| Contents | Plain-text rows and fields | Worksheets, values, formulas, and workbook features |
| Multiple sheets | No; typically one table per file | Yes |
| Formatting and charts | Not preserved | Can be preserved |
| Formulas | Formula logic is not preserved as a working formula | Can be preserved and recalculated |
| Readability in a text editor | Usually yes | No; it is a packaged workbook file |
| Compatibility | Widely supported by data and business applications | Best suited to spreadsheet software that supports workbook formats |
CSV’s simplicity is a strength when another system expects a basic table. It is also a limitation if the file must carry presentation or calculation details. XLSX is better for continuing spreadsheet work, but a recipient using a system that accepts only delimited text may need a CSV export instead.
When to choose CSV
Choose CSV when the goal is to exchange a single, straightforward table and the receiving application asks for CSV or delimited text. Many databases, reporting tools, online services, and programming environments can import or export it. Because the contents are plain text, a CSV can also be inspected with a text editor and is often simpler to process automatically than a feature-rich workbook.
- Exporting records: A customer list with one row per customer and one column per field is a natural CSV use.
- Moving data between systems: If an application’s import instructions specify a comma-delimited file, CSV is usually the appropriate choice.
- Keeping an uncomplicated data snapshot: CSV can work well when you need the values, not the spreadsheet’s appearance or calculations.
- Using a lightweight text workflow: A CSV can be opened or processed by many tools without needing Excel itself.
Before sharing one, check whether the recipient expects commas, semicolons, tabs, a particular character encoding, or specific column names. A file can be valid text yet still fail to import correctly if the two systems disagree about these details.
When to choose an Excel workbook
Choose XLSX when the file is meant to remain an editable spreadsheet or when its structure matters. It is the better option for work that includes calculations, charts, formatted reports, multiple related sheets, or features such as Excel tables and data validation. It can also keep a formula intact so another user can inspect or update it.
For example, a workbook tracking monthly sales might use one sheet for each region, a summary sheet with formulas, and a chart showing totals. Saving that work as CSV cannot retain the tabs, formulas, or chart. A CSV can contain the displayed values from one worksheet, but not the workbook that produced or organized them.
Consider the recipient, too. If they need only a clean list of values for uploading, a CSV may be easier. If they need to review calculations or continue editing the report in Excel, send an XLSX copy. When both needs matter, provide both formats and label them clearly, such as “sales-report.xlsx” and “sales-data.csv.”
Opening CSV files in Excel without changing data
Double-clicking a CSV often opens it in Excel, but Excel may interpret the contents as it loads them. It can display digit strings as numbers, recognize text as dates, or remove leading zeros. A product code such as 00421 might appear as 421, for example. The file itself may not have changed just by opening it, but saving the interpreted data can make the change permanent.
For more control in Excel for Microsoft 365 on Windows, use Data > From Text/CSV, select the file, and review the preview before loading it. Check the detected delimiter and file origin or encoding. If a column contains identifiers, postal codes, or other values that must remain exactly as written, set that column’s data type to Text during import when the import options allow it. This is safer than relying on Excel’s automatic interpretation.
If the CSV opens with everything in one column, the delimiter may not match the one Excel inferred. Importing through the Data tab lets you inspect and select a delimiter such as comma, semicolon, or tab. If accented or non-Latin characters appear incorrectly, check the encoding; UTF-8 is a common choice for exchanging text across systems. Excel for Mac also supports working with CSV files, though the available import controls and labels can vary by version.
Saving or converting between CSV and Excel
To keep spreadsheet features, save the file as an Excel workbook. In Excel for Microsoft 365 on Windows, use File > Save As and choose Excel Workbook (*.xlsx). This creates a workbook that can retain supported sheets, formulas, and formatting.
To export a worksheet as CSV, use File > Save As and select a CSV option, such as CSV UTF-8 (Comma delimited) (*.csv) when available. Excel warns that some workbook features are not compatible with the selected format. A CSV export represents the active worksheet, not every sheet in the workbook, so check that the intended sheet is active before saving. If you need to export several sheets, save each one separately or use a different method supported by the destination application.
Converting to CSV is not a round-trip backup of an Excel workbook. Once features such as formulas, formatting, and additional worksheets are omitted from the export, reopening the CSV cannot restore them. Keep the original XLSX if you may need to edit or reproduce the full workbook later. Also inspect the exported file when exact values matter, especially if it contains long numbers, leading zeros, or non-English characters.
Common CSV problems and misconceptions
- CSV is not the same thing as Excel. Excel can open CSV, but CSV is a text file format and XLSX is a workbook format.
- A CSV does not preserve a formula as a live Excel calculation. An exported cell may appear as a value or, depending on the export and data, as formula text; either way, CSV does not retain the workbook’s formula behavior and dependencies.
- Commas inside a value do not always mean a new column. Properly quoted fields can contain commas. If a file is parsed by simply splitting every line at every comma, those fields may be broken apart.
- Leading zeros and long identifiers can be altered during import. Treat codes as text rather than numbers when their digits are identifiers, not quantities.
- CSV is not automatically safe to open or share. A CSV can contain text that spreadsheet software interprets as a formula when opened. Be cautious with files from untrusted sources, and do not assume that plain-text format removes security risks.
- Not every CSV uses the same settings. A mismatch in delimiter, encoding, or line-ending expectations can make columns or characters appear wrong even when the source file contains the intended data.
One related misconception is that changing a file’s extension from .csv to .xlsx converts it. It does not. Use Excel’s Save As options to create a workbook; renaming the extension changes only the filename, not the file’s internal structure.
Frequently Asked Questions
Is CSV better than Excel?
Neither is universally better. CSV is usually better for exchanging a simple table with systems that expect text data. An XLSX workbook is better when you need formulas, formatting, multiple sheets, charts, or ongoing spreadsheet editing.
Can Excel open a CSV file?
Yes. Excel can open CSV files, and you can also import them from the Data tab to review the delimiter and control how columns are interpreted. Opening a CSV in Excel does not, by itself, make it an XLSX workbook.
Does CSV save formulas?
CSV does not preserve Excel formulas as working calculations with their references and dependencies. A CSV export is intended to represent a single table of text values, not the logic or structure of the original workbook.
How do I convert CSV to Excel?
Open or import the CSV in Excel, check that the values and columns were read correctly, then use File > Save As and choose Excel Workbook (*.xlsx). Keep the original CSV if you need an unchanged copy of the source data.
Why does my CSV open in one column?
Excel may have chosen a different delimiter from the one used in the file. Import it with Data > From Text/CSV and select or confirm the correct delimiter, such as comma, semicolon, or tab.
Can a CSV file have more than one sheet?
No. A CSV file represents one delimited table and has no workbook tabs. If you need multiple sheets in one file, use an Excel workbook format such as XLSX.
Related
- Checklist in Excel: Add Checkboxes and Track Tasks
- Checklist in Excel: Create, Track, and Manage Tasks
- Checklist in Excel: Create, Track, and Test a List
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Online: Insert an Image Into a CellYes. In Excel for the web, select a cell, then choose Insert > Pictures > Place in Cell…
- How to Sum in Excel Without Hidden Rows Using SUBTOTALTo total only visible values in Excel for Microsoft 365 on Windows, use SUBTOTAL with function number 109.…
- How to Clear Track Changes in WordTo clear tracked edits in Word, review them and choose Review > Accept > Accept All Changes to…
- How to Clean an Excel File to Reduce Its SizeTo reduce an Excel file’s size, save a copy, remove unnecessary data and formatting, compress pictures, and delete…
- Data Validation Interview Questions and Strong AnswersData validation interview questions test whether you can define rules for acceptable data, detect records that break those…
- Excel Analysis Features in Microsoft 365Microsoft Excel for Microsoft 365 includes analysis features for summarizing data, finding patterns, testing assumptions, and building reports.…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.