To save an Excel table as a CSV file in Microsoft Excel for Microsoft 365 on Windows, select a cell in the worksheet, choose File > Save As > Browse, select CSV UTF-8 (Comma delimited) (*.csv) as the file type, and save. Excel exports the active worksheet—not just the table—and CSV does not retain Excel formatting, formulas, filters, or table features, so keep a separate .xlsx copy.
What CSV means for an Excel table
CSV stands for comma-separated values. It is a plain-text format for storing rows and columns of data, with a delimiter—usually a comma—between fields and a line break between rows. A CSV file can be opened by many spreadsheet, database, and data-import tools, which makes it useful for sharing or moving tabular information between programs.
An Excel table is more than rows and columns. It can have a table name, structured references, filter buttons, a selected style, calculated-column formulas, and other workbook features. CSV has no standard way to preserve most of that information. When you save a worksheet as CSV, the file contains tabular text and values, not a copy of the Excel table object.
This distinction matters when a worksheet has several tables or other content. Excel saves the active worksheet’s data, not only the table you clicked in. If you need a CSV containing one table alone, copy that table to a separate worksheet first, or create a temporary workbook with only the data you intend to export.
Save the active worksheet as CSV in Windows
- Open the workbook and select the worksheet you want to export. Click a cell on that sheet so it is active.
- Choose File > Save As > Browse. Pick a folder and enter a file name.
- Open the Save as type list and choose CSV UTF-8 (Comma delimited) (*.csv) when available. UTF-8 is a practical choice when the data includes accents, non-Latin writing systems, or special symbols.
- Select Save. If Excel warns that some workbook features may be lost, that is expected when changing to CSV. Confirm that you want to use the CSV format if the CSV is the file you intend to create.
- When you are finished exporting, do not save the workbook over your only .xlsx copy. If you need to continue editing the workbook, use File > Save As again and save it in Excel Workbook (.xlsx) format.
Excel may also warn that only the active sheet will be saved. That warning is important for workbooks with multiple sheets: the CSV will not contain the other worksheets. In the Save As dialog, the available CSV options can vary with Excel version and Windows settings. If you do not see CSV UTF-8, use the closest suitable CSV option and check the exported file’s character encoding before sending it to another system.
What happens to formulas, formatting, and table features
A CSV file does not store Excel formulas as working formulas. Excel generally writes the calculated results shown in the cells, so a formula such as a total may appear as its current number in the CSV. After opening that CSV in Excel, the result is just data; it no longer updates when related values change. If a formula has not recalculated as expected, check the result in the workbook before exporting.
Cell colors, fonts, borders, number formats, conditional formatting, column widths, freeze panes, filters, and table styles are not part of the CSV data. The first row may contain your column headings, but the CSV does not record that those headings belong to a named Excel table. If you need a visually formatted report or a workbook that remains editable, keep or share an .xlsx file instead.
Number and date handling deserves particular attention. Excel may export values in a way that reflects how they appear in cells, but another application can interpret the resulting text differently. A date such as 03/04/2026 could mean March 4 or April 3 depending on the receiving system’s locale. For dependable exchange, agree on a date convention with the recipient and inspect the CSV in a plain-text editor or the destination application.
Choose a delimiter and encoding that fit the recipient
Although CSV commonly means comma-separated values, the delimiter used by Excel can depend on regional settings, including the Windows list separator. In some locales, a semicolon is used in place of a comma because a comma is used as the decimal mark. A file with semicolons may still be called CSV, but a recipient expecting comma-separated fields might not split the columns correctly.
When the receiving system specifies a delimiter, follow its requirements rather than assuming the file extension guarantees a comma. If the recipient expects a comma but Excel produces semicolons, ask whether the system can accept another delimiter or use an export process that lets you set the required separator. Avoid casually changing Windows regional settings just for one export; that can affect other programs.
Encoding determines how text characters are represented. CSV UTF-8 is usually the safer option for names and text containing characters such as é, ñ, or non-Latin scripts. A file saved with a different encoding may display those characters incorrectly in software that guesses the encoding. If the recipient’s system requires a specific encoding, confirm that requirement before exporting.
CSV syntax also has rules for fields that contain delimiters, quotation marks, or line breaks. Exporting software typically encloses such a field in quotation marks and doubles any quotation marks inside it. For example, a name containing a comma should remain one field rather than being split into two. If you inspect the raw text, those extra quotation marks are often necessary syntax, not unwanted data.
Common problems and how to prevent them
- Only one sheet appears: CSV is a single-sheet format in this workflow. Activate the intended sheet before saving, and export other sheets separately if needed.
- Unrelated cells are included: Excel exports the worksheet, not a selected table range. Put the table on a clean sheet or copy only the required cells into a temporary workbook.
- Leading zeros disappear: An identifier such as 00127 may be treated as a number rather than text. Format or enter identifiers as text before they are converted or exported, then inspect the CSV. Applying a display format after Excel has already discarded zeros may not restore the original identifier.
- Long identifiers change: Excel can lose precision when a long digit string is stored as a number. Store account numbers, tracking codes, and similar identifiers as text in the source workbook; do not rely on CSV export to repair a value that Excel has already altered.
- Dates or decimals look different: Locale settings in Excel and the receiving application can affect how text is separated or interpreted. Agree on a date format and delimiter, then test a small export before processing a large file.
- Characters look garbled: Try CSV UTF-8 and confirm that the receiving software reads the file as UTF-8. Changing the extension alone does not change a file’s encoding.
- Values are missing or stale: Check the active sheet, hidden or filtered data, and formula results before export. If the CSV is for a recipient, verify that the intended rows and columns are present rather than assuming a filter or table selection limited the output.
One easy misconception is that saving a filtered Excel table exports only the visible rows. Do not depend on that assumption for a data handoff. Check the actual CSV contents and, if the export must contain a specific subset, create that subset explicitly on a clean worksheet before saving.
Check the CSV before sharing it
After saving, open the CSV in a text editor or import it into the destination program to confirm that the file has the expected structure. Opening it by double-clicking in Excel is convenient, but Excel may automatically interpret text as dates or numbers, which can make it harder to tell what was literally stored in the file.
Check a representative sample of the first and last rows, headings, special characters, dates, decimal values, identifiers with leading zeros, and fields containing commas or line breaks. Also compare the number of expected records with what the exported file contains. If a system requires exact field names or column order, verify those details rather than relying on the visual appearance of the source table.
For a recurring transfer, make a small test CSV and ask the recipient to confirm that it imports correctly before exporting the full dataset. Keep the original .xlsx workbook as the editable source. That preserves formulas, formatting, multiple sheets, and the table structure if you need to revise the data or produce another export later.
CSV or XLSX: which format should you use?
Choose CSV when the recipient specifically requests it, when a system accepts plain tabular data, or when you need a simple text-based exchange. Its simplicity is also its limitation: it represents one sheet of values and text, not the full workbook. It is not a substitute for a backup of the Excel file.
Choose .xlsx when the recipient needs formulas, multiple worksheets, Excel tables, formatting, charts, validation rules, or other workbook features. If someone only needs to read a report while preserving its appearance, a PDF may be more suitable, although a PDF is not designed for easy data import. Ask the recipient which format and delimiter their workflow expects; the best choice depends on what they need to do with the file.
Frequently Asked Questions
Can I save only an Excel table as CSV?
Not directly through the ordinary Save As CSV command: Excel saves the active worksheet. Copy the table to a new, otherwise empty worksheet or temporary workbook, activate that sheet, and save it as CSV.
Does converting Excel to CSV keep formulas?
No. The CSV contains the formula results as values rather than reusable Excel formulas. Keep the .xlsx workbook if you need formulas to remain editable and recalculate.
Why did Excel save my CSV with semicolons?
The delimiter can follow regional list-separator settings. Check the raw file and the recipient’s import requirements; a .csv extension alone does not ensure that commas separate the fields.
Which CSV option should I choose for special characters?
Choose CSV UTF-8 (Comma delimited) when it is available, especially if the data includes accented letters or other non-ASCII characters. Confirm that the receiving application supports UTF-8.
Can I convert CSV back to an Excel table?
Yes. Open or import the CSV into Excel, check that columns and data types were interpreted correctly, then select the data and use Insert > Table if you want Excel table features. The original formulas, formatting, and workbook features cannot be recovered from the CSV alone.
Related
- Power Query Editor: How to Split Text into Multiple Columns
- Power Query Union Tables: How to Append Queries
- Data Validation: Definition, Rules, and Examples
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Shortcut to Remove Gridlines: Windows and MacIn Excel for Microsoft 365 on Windows, press Alt, then W, V, G to toggle gridlines off for…
- How to Create a Distribution List in OutlookTo create a personal distribution list in Outlook, open People, choose New contact list in new Outlook or…
- Calculate Age in Excel From a Birth Date, Step by StepTo calculate someone’s age in completed years in Excel, put their birth date in A2 and enter =DATEDIF(A2,TODAY(),"Y")…
- Hanging Indent in Word: Format Reference Lists EasilyTo hang-indent references in Microsoft Word, select the reference paragraphs, open the Paragraph settings from the Home tab,…
- How to Import Archive Emails in Outlook: Full GuideTo import archived emails into Outlook for Windows, open classic Outlook and choose File > Open & Export…
- Excel: How to Get Rid of Page Break Lines on a SheetTo hide page break lines in Excel for Microsoft 365 on Windows, open File > Options > Advanced,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.