To put an Excel file into CSV format, save or export one worksheet as a comma-separated file, then open the result once to confirm its values and structure.
CSV is a plain-text table format, not a complete replacement for an Excel workbook. It stores rows and fields but does not retain multiple worksheets, formulas, formatting, or workbook-only features. You can use Microsoft Excel’s Save As workflow for a desktop export, or use the browser-based Excel To CSV tool to select one worksheet from a local .xlsx workbook and download it without uploading the workbook.
Pick the route that matches your file
Both routes can produce a comma-separated file, but their input requirements and workflows differ. Choose the desktop method when the workbook is already open in Excel. Choose the browser method when you want to export one selected worksheet from a bounded .xlsx file without sending that file to a conversion server.
| Method | Input | Worksheet scope | Output |
|---|---|---|---|
| Microsoft Excel Save As | A workbook open in Microsoft Excel | The current worksheet | A CSV file saved to the chosen folder |
| Excel To CSV | One local classic .xlsx file no larger than 20 MB | One worksheet selected in the browser | One local CSV download |
Whichever route you use, keep the original .xlsx workbook as the source of record. A CSV is best treated as a portable export for review, an import, a database load, or a handoff to software that does not accept .xlsx.
Save one worksheet as CSV in Microsoft Excel
Use Excel’s native export when you want a familiar desktop workflow. Because CSV represents one table, save the worksheet you need and repeat the process separately if another sheet requires its own CSV.
- Open the workbook and choose the worksheet. Review the sheet before exporting it. Make sure the intended table starts in the area you want to include and does not contain unnecessary decorative or repeated content.
- Open the File menu and choose Save As or Save a Copy. These options can create a new file while leaving the working .xlsx available as your source.
- Choose “CSV (Comma delimited) (*.csv)” as the file type. Enter a clear filename and select the destination folder. Saving under a new name also makes it easier to distinguish the export from the original workbook.
- Confirm the format-loss warning if Excel displays it. Excel warns that some workbook features cannot be retained in a text-based format. Choose Yes to continue with the CSV export when the stored worksheet data is the part you need.
- Open the CSV before using it. Check the result in a text editor and in the application that will import it. Confirm that columns line up, commas and line breaks appear where expected, and important identifiers have not changed meaning.
Excel removes workbook-only formatting from the CSV output. Keep the .xlsx file if the recipient may later need formulas, charts, images, comments, validation rules, merged-cell behavior, print settings, or sheet names.
Convert a local .xlsx file without uploading it
The browser workflow is useful when the source is a classic .xlsx workbook and you want one worksheet as a downloadable CSV. The workbook remains on your device: after it is selected, the page reads it in the current browser tab and creates the CSV file locally.
- Confirm that the file is supported. Choose one local classic .xlsx OOXML workbook no larger than 20 MB. Legacy .xls files, macro-enabled workbooks, encrypted workbooks, and remote URLs are not accepted.
- Select the workbook. After the file opens in the browser, confirm that the intended sheet is visible. The converter validates the workbook package before parsing it and does not upload or retain the selected file.
- Select the worksheet to export. Only one worksheet can be converted per CSV download. If the workbook contains several tables, choose the smallest relevant sheet rather than combining unrelated sections.
- Select Convert to CSV. The tool reads stored worksheet values without calculating formulas, running macros, following external links, or executing spreadsheet content. Each displayed row becomes one CSV record, and commas, quotation marks, and line breaks are escaped in the output.
- Download the generated file. The browser creates one downloadable CSV Blob with CRLF line endings. The selected worksheet can contain no more than 100,000 addressed cells, and the generated CSV is limited to 10 MB.
- Inspect the CSV and retain the workbook. Open the download in a text editor or its destination system. An unsupported, damaged, or oversized file returns an error rather than a partial CSV, and the original .xlsx is never overwritten.
Empty cells become empty CSV fields. Stored strings, numbers, and Boolean values are written as text that the receiving program parses according to its own rules. Date values can remain stored numbers because the converter does not guess a locale or display format.
See exactly what the conversion preserves
CSV succeeds as an interchange format because it keeps a simple table structure. Review the following differences before treating the exported file as equivalent to the Excel worksheet.
| Workbook element | Result in the CSV | Practical effect |
|---|---|---|
| Worksheet scope | Only the selected worksheet is included | Other sheets need separate exports |
| Cell values | Stored strings, numbers, and Boolean values are written as text | The destination application determines how to parse them |
| Formulas | Formula source is not preserved or recalculated | The export contains the stored value available to the converter |
| Formatting and workbook features | Styles, charts, images, comments, filters, merged-cell semantics, print settings, validation rules, sheet names, and formulas are omitted | Retain the .xlsx for any feature-dependent work |
| Empty cells | They become empty CSV fields | Always distinguish an empty field from a missing record during import |
| Dates | They may remain stored numeric values | Confirm how the destination interprets them |
| Special characters | Commas, quotation marks, and line breaks are escaped | The table structure can remain intact |
The browser export also adds a leading apostrophe to string cells whose first meaningful character is =, +, -, or @. This reduces the risk that a spreadsheet application will interpret imported text as a formula. Negative number cells are written as ordinary numeric text and do not receive the apostrophe; the destination application determines how to parse them. The change is intentional, but a receiving application may display the apostrophe or preserve it as text, so review cells where an exact leading character has business meaning.
Check the file before it reaches another system
CSV has no built-in column types, formulas, or formatting rules. A visually plausible file can still import differently in another program, so perform a quick inspection before relying on it for a business transfer.
- Inspect the raw structure. Open the CSV in a text editor and confirm that each record remains on its intended line. Look for unexpected delimiters inside fields and check that quoted values containing commas or line breaks are preserved.
- Open it in the destination application. Compare the imported columns, row count, empty fields, and identifiers with the source worksheet. Import behavior can vary even when the file itself is valid.
- Test delimiter and encoding compatibility. Confirm that the receiving system expects comma-separated data and that its import settings are compatible with the file.
- Check identifiers with leading zeroes. A value such as an account number may need to be imported as text. Do not let the destination application silently convert it to a number.
- Review date-like values. Numeric date serials and text dates can be interpreted differently by different applications. Verify that the destination produces the intended dates.
- Look for formula-triggering text. In the browser export, check text that begins with a formula trigger and note any added apostrophe before approving the file for sharing.
Keep the downloaded CSV only after this review. If the destination requires structured records with explicit data types instead of a flat table, a JSON or HTML-table export may be a better interchange format.
Know when the export stops cleanly
The browser converter uses explicit boundaries rather than silently truncating a file. These restrictions determine whether a workbook can be converted successfully.
| Boundary | Supported rule |
|---|---|
| Workbook format | One local classic .xlsx OOXML package |
| Unsupported sources | Legacy .xls, macro-enabled formats, encrypted workbooks, and remote URLs |
| Workbook size | No larger than 20 MB |
| Selected worksheet | No more than 100,000 addressed cells |
| Package structure | Multi-disk and Zip64 packages are rejected; entry-count and declared expanded-size limits are enforced |
| Generated CSV | No larger than 10 MB |
| Failure behavior | Damaged, unsupported, or oversized input returns an error and does not produce a partial file |
If the selected file falls outside these limits, use an appropriate trusted application to prepare a smaller or differently packaged .xlsx workbook. Do not remove protection or enable macros merely to force an export; the browser converter does not run macros or execute workbook content in any event.
Keep the source and export responsibilities separate
A dependable workflow uses the smallest relevant worksheet, exports only the stored values needed for the handoff, and validates the downloaded file in its destination system. Keep the original .xlsx unchanged so formulas, formatting, and workbook structure remain available when the flat CSV cannot carry them.
For recurring transfers, make the review step part of the process rather than an optional check. Confirm row boundaries, empty fields, identifiers, dates, and formula-triggering strings every time, because the destination application’s import rules can determine the final result even when the CSV itself is correct.
If you're weighing options, How to Export Excel From an HTML Table covers this in detail.
If you're weighing options, Excel to JSON API Alternative for Local Data Handoffs covers this in detail.