Excel Export to CSV: Options and What They Mean

How-to basics · Updated November 21, 2026

In Excel for Microsoft 365 on Windows, export a sheet by choosing File > Save As, selecting CSV UTF-8 (Comma delimited) (*.csv) in Save as type, and saving. CSV UTF-8 is usually the best option for sharing text across systems; the other CSV choices mainly affect text encoding or compatibility, and every CSV export saves only the active worksheet.

Which CSV options does Excel offer?

In the Windows desktop version, the Save as type list commonly includes CSV UTF-8 (Comma delimited) (*.csv), CSV (Comma delimited) (*.csv), CSV (Macintosh) (*.csv), and CSV (MS-DOS) (*.csv). The exact list can vary with Excel version and system settings. These are all text-file exports, not different Excel workbook formats. The names indicate how the text is encoded or which older environment the file is intended to support; they do not preserve workbook features such as cell colors or formulas.

For most current uses, choose CSV UTF-8. It is a practical default when a file may contain accented letters, non-Latin scripts, or symbols and will be opened on different operating systems. The plain CSV option may be suitable for older software that expects the computer’s traditional text encoding. The Macintosh and MS-DOS choices are legacy compatibility options, not generally preferable choices just because the recipient uses a Mac or Windows PC today.

  • CSV UTF-8: A good general-purpose choice for modern applications and international text.
  • CSV (Comma delimited): A legacy-style CSV option that may use a system-dependent text encoding.
  • CSV (Macintosh) and CSV (MS-DOS): Options for compatibility with older systems or software; use them only when the recipient specifically requires them.

How to save a worksheet as a CSV

First, select the worksheet you want to export. Then use File > Save As > Browse, choose a folder, and select the required CSV type from Save as type. Enter a file name and select Save. Pressing F12 in Excel for Windows opens the Save As dialog in many desktop installations, but the ribbon path works regardless of whether you use that shortcut.

Excel may show a warning that only the active sheet will be saved, followed by a notice that some workbook features are not compatible with the selected format. Confirm the CSV option if that is what you intend. Those messages are important: saving as CSV does not create a CSV copy of every worksheet, and it does not preserve the original workbook’s full capabilities. If you need to keep the formulas, formatting, charts, or other sheets, retain the original .xlsx file and save the CSV under a different name or in a different folder.

On Excel for Mac, use File > Save As and select a CSV format from the File Format menu. Available labels and encoding choices can differ by Mac version. Excel for the web has fewer format controls than the desktop application, so use desktop Excel when you need to choose a particular CSV encoding or investigate a delimiter issue.

What a CSV export keeps—and what it discards

A CSV file is plain text organized into rows and fields. It can represent a rectangular table, but it has no workbook structure for storing multiple sheets, formatting, charts, images, filters, comments, data validation, or macros. It also cannot store Excel formulas as working formulas. When a formula cell is exported, the file contains a text representation of the cell’s calculated result rather than a formula that will recalculate in the recipient’s spreadsheet.

That distinction matters for reports. A workbook might show a total of 125 because a cell contains a SUM formula, but the CSV contains the result, not the SUM formula or the source cells’ calculation logic. If the recipient needs to audit or update the calculation, send an .xlsx workbook as well, or document the calculation separately. A CSV is useful when an application needs a simple table of values, not when it needs the workbook’s behavior.

Formatting is not stored as formatting instructions. A CSV has no bold text, column widths, colors, or number formats to apply after opening. The text Excel writes can be affected by how values are represented in the worksheet, so check dates, percentages, and decimals in the saved file if exact output matters. For example, a date may be rendered in a way that a receiving system interprets differently, even though it looked clear in Excel.

Commas, regional settings, and delimiters

The word comma in a CSV format name can be misleading when a file is created on a computer with different regional settings. Excel for Windows can use the Windows list separator when saving delimited text. In a region where the list separator is a semicolon, the resulting file may use semicolons between fields rather than commas. Decimal conventions can also vary by region, which is one reason a file that looks correct on the creator’s computer may not split into columns as expected for someone else.

Before changing Windows regional settings, ask what delimiter the receiving application expects. A system-wide list-separator change can affect other programs, so it is not a harmless file-specific switch. If the recipient requires a particular delimiter, confirm the export in a plain-text editor or import a small sample into the destination system. Do not rely only on the .csv extension: the extension does not guarantee that every program will interpret the separators identically.

CSV can still contain commas inside a field. A compliant CSV writer quotes a field when needed and escapes quotation marks according to CSV conventions, so a value such as a company name with a comma can remain one field. However, poorly designed importers sometimes handle quoted fields or line breaks incorrectly. If a recipient reports extra columns, ask which delimiter and quoting rules its software expects before altering the source data.

UTF-8, special characters, and leading zeros

Choose CSV UTF-8 when the sheet contains names or text outside basic English letters, such as café, Łódź, 日本語, or an em dash. A legacy encoding may not represent every character, and another program can show replacement characters or garbled text if it guesses the wrong encoding. UTF-8 is widely supported, but the receiving application still needs to read the file as UTF-8. If text looks wrong, import the file and explicitly select UTF-8 instead of opening it with automatic detection.

CSV also does not preserve Excel’s idea that a value is text. A code such as 00127 may be written as text, but if a person double-clicks the CSV and Excel interprets the field as a number, it may display 127 and hide the leading zeros. Similar automatic interpretation can affect long identifiers, dates, and values that resemble scientific notation. The characters may exist in the file, while the display changes during opening or import.

For controlled imports in desktop Excel, use Data > From Text/CSV, inspect the preview, and set the relevant columns to Text when identifiers must remain exact. That import step gives more control than simply opening a CSV by double-clicking. If another system is the final destination, use its import settings where possible and verify a few representative records after loading.

Choosing CSV or another export format

Choose CSV when a service, database, or colleague asks for a simple delimited table and does not need workbook formatting or formulas. Choose CSV UTF-8 for most modern workflows, especially if text may include international characters. Choose a legacy CSV variant only when a specific older program requires it. The recipient’s required delimiter and encoding matter more than the name that seems most familiar.

Use an Excel workbook (.xlsx) when the file needs multiple sheets, formulas, formatting, charts, or editable workbook features. Use a tab-delimited text file when a receiving tool specifically requests tab-separated values; it is still plain text and still does not retain Excel formatting or multiple sheets. Exporting each worksheet to its own CSV is a common solution when a system needs separate flat files. Name each file clearly so the sheet-to-file relationship remains understandable.

A useful handoff often includes a CSV plus a short note stating the character encoding, delimiter, and what each column contains. For example: “UTF-8, comma-delimited; OrderDate uses YYYY-MM-DD; OrderID is text.” This is particularly helpful when files cross regional settings or are loaded automatically. Do not assume the recipient can infer dates, units, or identifier rules from a CSV alone.

Common export problems and practical checks

Before sending the file, check that the intended sheet was active and that the first row contains the expected headers. Look for blank rows, hidden information that should not be shared, unexpected totals, and values that rely on formulas. Open a copy of the exported file in a text editor or import it into a fresh workbook to check the actual fields, rather than judging only from the original formatted sheet.

  • Only one sheet appears: This is normal for a CSV export. Export each required worksheet separately or share an .xlsx workbook.
  • Characters look corrupted: Re-import the file with UTF-8 selected, or export again using CSV UTF-8.
  • Everything appears in one column: The application may expect a different delimiter. Use its import dialog to select the delimiter that matches the file.
  • Zeros disappear from codes: The receiving program may have interpreted text as numbers. Import the column as text and check whether the zeros are present in the file.
  • Formulas are missing: CSV stores formula results, not Excel formulas. Keep an .xlsx copy if the calculation logic is needed.

Keep an untouched workbook copy before exporting, especially if you are tempted to overwrite the source file. After a CSV save, close without saving changes to the workbook if you need to return to its full structure. A quick review of the exported file can catch mistakes that are difficult to spot after a recipient has imported it.

Frequently Asked Questions

Which CSV option should I choose in Excel?
Choose CSV UTF-8 (Comma delimited) for most current uses, especially if the data includes accents, non-English text, or symbols. Use another CSV type only when the recipient’s software specifically requires it.

Does Excel export every worksheet to one CSV?
No. A CSV represents one flat table, so Excel exports the active worksheet. Save each sheet separately if multiple CSV files are required, or keep the workbook as .xlsx if the recipient needs all sheets together.

Why does my CSV open in one column?
The program opening it may expect a different field separator from the one in the file, often because of regional settings. Import the file and specify its delimiter, or ask the sender which separator was used.

Will CSV keep formulas and formatting?
No. CSV is plain text. Formula cells are represented by their calculated values, and formatting such as colors, bold type, and column widths is not carried over.

How can I keep leading zeros in a CSV import?
Use the destination program’s import controls and set the relevant column to Text before loading it. Opening a CSV directly may cause Excel or another program to treat a code such as 00127 as a number and display it as 127.

Is CSV UTF-8 better than CSV for a Mac?
For a current Mac or Windows workflow, CSV UTF-8 is usually the more useful choice for broad character support. The Macintosh-labeled option is a legacy compatibility format, not a general rule for files opened on modern Macs.

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.