Excel Export to CSV: Does It Keep Cell Formatting?

No. Exporting an Excel worksheet as a CSV file does not preserve cell formatting such as fonts, colors, borders, alignment, or conditional formatting. However, the way numbers, dates, and other values are displayed in Excel can affect the text written to the CSV, so check the exported file before sharing it.

What a CSV file can and cannot store

CSV means comma-separated values. A CSV file is plain text organized into rows and fields; it does not contain Excel’s rich workbook features. It has no standard way to record a cell’s fill color, font, number format, column width, worksheet tab color, or conditional formatting rule. When someone opens a CSV in a text editor, they see text and separators, not a formatted grid.

Excel workbooks, usually saved as .xlsx, can contain multiple worksheets, formulas, styles, charts, and other workbook information. CSV is much narrower. When Excel saves a worksheet as CSV, it writes data from the active worksheet rather than preserving the whole workbook. Formulas are not retained as formulas in the CSV; the saved content is the displayed value or text. Other worksheets and workbook features are not included.

That makes CSV useful for exchanging tabular data between programs, but unsuitable as a replacement for a formatted report or a complete Excel workbook. If the recipient needs to see colors, bold headings, merged cells, or a chart, send a PDF or an Excel workbook instead.

Why formatting can still affect exported text

Although CSV does not store formatting instructions, Excel’s displayed representation of a value can matter when it writes the file. Microsoft describes CSV export as saving the text and values as displayed in the active worksheet. As a result, changing a number format before export may change how a value appears in the CSV, even though the formatting itself is absent.

For example, a cell containing the number 0.25 might be formatted as a percentage and appear as 25%. The CSV may contain the displayed representation rather than a reusable percentage style. A date stored internally as a serial number might be written as a date-formatted string, such as 11/2/2026, depending on its cell display. The recipient receives characters, not a date format or percentage format that can be adjusted in the same way as an Excel cell.

This is an important distinction: a display format may influence the exported text, but it does not travel as a format. The same is true of custom number formats. A value displayed as 00127 may export with those leading zeros, yet a spreadsheet program that opens the CSV can interpret 00127 as the number 127 and display it without the zeros. The CSV itself does not instruct the receiving program to keep the field as text.

How to save a worksheet as CSV in Excel

In Excel for Microsoft 365 on Windows, use the Save As workflow. Keep the original workbook in .xlsx format if you may need its formulas, styling, or other sheets later.

Select the worksheet you want to export. Excel exports the active worksheet, so click its tab before saving.
Choose File > Save As > Browse.
In the Save as type list, choose a CSV option. Excel may offer CSV UTF-8 (Comma delimited) (*.csv) and other CSV choices. Choose UTF-8 when the receiving system supports it and the data contains accented letters or other non-English characters.
Choose a file name and location, then select Save.
If Excel warns that some workbook features are not compatible with CSV, confirm only if a plain-text export is what you intend. Keep the .xlsx version separately.

The exact labels or available CSV choices can vary with Excel version and regional settings. Excel for Mac also provides CSV choices through its save dialog, though the layout and options differ from Windows. Excel for the web has different download and file-management controls; if an export must meet a particular encoding or delimiter requirement, verify the downloaded file rather than assuming the desktop options are identical.

Examples: dates, zeros, percentages, and formulas

Some spreadsheet values are especially easy to misread after export. Consider these common cases:

Dates: A date such as 03/04/2026 can mean March 4 or April 3 depending on the reader’s regional date convention. CSV does not carry a date-format instruction to settle that ambiguity. An ISO-style date, such as 2026-04-03, is often clearer for data exchange, if the receiving system accepts it.
Leading zeros: Product codes, postal codes, and account identifiers may look like numbers but function as labels. If Excel shows 00127 because the cell is text or uses a custom format, opening the CSV by double-clicking may cause Excel to infer a number and remove the zeros. Importing with the field explicitly treated as text is safer.
Percentages and decimals: A value stored as 0.25 and displayed as 25% may be exported as a displayed percentage. A receiving program might expect the underlying decimal instead. Confirm which representation the destination expects before exporting.
Formulas: A cell with a formula such as a total calculation exports as a result, not as an editable formula. If the result has not recalculated or is an error, the CSV can reflect that displayed result. Keep the workbook if the recipient needs to inspect or recalculate formulas.
Long numbers: Identifiers or very large values can be rounded or displayed in scientific notation if Excel treats them as numbers. For identifiers, store them as text before export and verify the text in the saved file.

These examples show why formatting loss is not merely cosmetic. A format can communicate meaning in the workbook, while the exported text may be ambiguous or interpreted differently by the next program.

Delimiters, encoding, and opening the CSV again

A CSV is commonly comma-delimited, but the delimiter Excel uses can depend on regional settings, including the system list separator. In some environments, a semicolon is used to separate fields. This can happen because commas are used as decimal marks in that locale. A file can therefore have a .csv extension without using commas between every field. If a destination system requires a specific delimiter, check its import requirements and inspect the export.

CSV conventions also allow fields containing a delimiter, quotation mark, or line break to be enclosed or escaped so the data remains organized. For instance, a customer name containing a comma should still occupy one field. A properly written CSV handles this with quoting rules, but not every program handles unusual text consistently. Avoid editing CSV structure by hand unless you understand those rules.

Text encoding affects characters beyond basic English letters. CSV UTF-8 is generally a good choice for an exchange that includes names such as José or symbols from other writing systems. Older software may expect a different encoding, so follow the receiving system’s specifications. If characters look scrambled after opening the file, the problem may be an encoding mismatch rather than lost cell formatting.

To control how Excel reads a CSV, use Data > From Text/CSV in Excel for Microsoft 365 on Windows instead of simply double-clicking the file. The import preview lets you review how fields are separated and how data types are detected; use the available transformation controls to preserve identifier columns as text when appropriate. Excel for Mac has import options too, but the interface differs. For critical data, inspect both the preview and the imported worksheet.

How to check the export before sending it

Do not rely only on how the original worksheet looks. A practical check is to save the CSV, then inspect a copy of that file in a plain-text editor or import it into a fresh workbook. This helps reveal whether fields are separated correctly and whether dates, zeros, or special characters survived in the intended form.

Confirm that the intended worksheet was active when you saved.
Check the first and last rows, plus representative records containing dates, long numbers, commas, line breaks, or non-English characters.
Confirm that the output has the expected column order, delimiter, and encoding.
Compare a few important values against the source workbook, paying attention to leading zeros, decimal places, and percentage values.
Open the CSV in the destination application or ask the recipient to confirm the import, especially when the file feeds a database or business process.

Saving a CSV does not ordinarily mean that you should discard the workbook. Treat the CSV as an export copy and preserve the .xlsx source. If the CSV becomes the active format for the open file, Excel may warn again when you save workbook features that CSV cannot retain. A separate source workbook prevents an accidental loss of formatting, formulas, and additional sheets.

CSV compared with XLSX, PDF, and other options

Choose a format based on what the recipient needs to do. CSV is appropriate when the goal is to transfer a simple table for importing into another application, processing as data, or opening in a system that explicitly requests CSV. It is compact and widely supported, but carries little context beyond the text values and field arrangement.

Use .xlsx when the recipient needs formulas, multiple worksheets, cell formatting, tables, charts, or the ability to continue working in Excel. Use PDF when the main goal is to present a stable-looking report for reading or printing rather than to edit the data. If another system requests a text file with a particular separator, such as tabs, use the format it specifies rather than assuming that every text export is interchangeable with CSV.

Sometimes the best solution is to provide two files: an .xlsx workbook for interpretation and continued editing, plus a CSV containing the data for import. Label the files clearly so the recipient knows which one is the formatted source and which one is the data-only export.

Frequently Asked Questions

Does CSV save cell colors, bold text, or borders?
No. CSV stores plain text fields, not Excel cell styles. Those visual features disappear when you export to CSV. Use .xlsx or PDF if the appearance needs to be preserved.

Does Excel export every worksheet to one CSV?
No. Excel’s CSV save exports the active worksheet, not all worksheets in the workbook. Select the correct sheet first. To deliver multiple sheets, keep an .xlsx workbook or create a separate CSV for each sheet.

Will a CSV keep leading zeros?
The exported text may contain leading zeros if they are part of the displayed value, but Excel can remove them when it opens the file and interprets the field as a number. Import the column as text and check the result rather than relying on a double-click.

Are formulas preserved in a CSV?
No. CSV export contains cell text and displayed values, not Excel formulas or their calculation logic. Keep an .xlsx copy if formulas need to remain editable or auditable.

Why does my CSV use semicolons instead of commas?
Excel can use the system’s regional list separator when saving delimited text. Regional settings may make that separator a semicolon. Check the receiving application’s expected delimiter and adjust the export or regional configuration as appropriate.

What should I use if I need both the data and its formatting?
Save the workbook as .xlsx to retain editable data and formatting, or export a PDF when readers need a fixed visual presentation. A CSV cannot carry both the table data and Excel’s styling.

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.