CSV and spreadsheet conversion

How To Convert Excel Sheet Into CSV Format?

How To Convert Excel Sheet Into CSV Format. Check delimiters, column types and the saved file using a small example. Keep original source records.

By Uddhav Gopani, FounderPublished 27 September 2026Updated 29 September 2026

CSV export is worksheet-specific. Activate the intended sheet and give the output a name that identifies it. If the workbook has several sheets, export each needed sheet separately. A CSV file cannot contain several independently named worksheets.

Export the selected worksheet

Save the original workbook in its native XLSX or XLSM format.
Activate the worksheet containing the intended table. Confirm its header row and remove unrelated display content from the export copy if necessary.
Use File > Save As or Save a Copy, choose an appropriate CSV format and a new output filename.
Read the format warning. CSV does not retain all workbook features, and the export concerns the active sheet.
Open the CSV in a plain-text viewer and verify the actual delimiter, quotation marks and character encoding before importing it elsewhere.

Do not overwrite the only copy of a workbook with a text export. If several sheets are needed, produce separate CSV files with clear filenames and document which sheet each file represents.

Check the intermediate table

Inspect the exported record population when the worksheet contains hidden or filtered data. A filtered screen is not sufficient evidence that only the visible records were exported. If the recipient should receive a subset, create a clearly defined export table and verify the resulting record count. Also inspect trailing empty columns and rows so presentation formatting does not mislead your review of the actual data range.

Use a small fidelity test

Before processing the full file, include a record with identifier 00123, name Bose, Mira, date text 2026-09-29, amount 1250.50, and note He said "ready". Add a second record with an empty note. This exposes the important differences between a number, a text code, punctuation inside a field and a missing value.

For comma-separated output, the name containing a comma needs quotation marks. A quote inside a quoted field is represented by doubling it. A line break inside a quoted field is part of one record, so counting physical text lines is not always the same as counting table rows. Use a CSV parser when validating record counts.

Separate values from display formats

Leading zeros, long account-like identifiers and date-looking strings are common conversion traps. Decide their intended types before import. A numeric cell formatted to show five digits is different from a text value containing five literal characters. If a numeric conversion has already removed significant digits, changing the cell’s display format afterward cannot reconstruct them.

CSV does not carry a schema identifying a column as a date, number or text. A receiving program makes its own interpretation. Document the expected types alongside the export. Use a consistent date convention and decimal convention, and keep identifiers as text when arithmetic on them would be meaningless.

Verify the actual file

Compare the source and destination record counts with a parser, accounting for any header row.
Check the first, middle and last records, including a blank field and a value containing punctuation.
Inspect non-ASCII names and symbols to confirm the encoding was interpreted correctly.
Check whether formulas became calculated values or literal formula text, according to the intended export.
Confirm that the receiving system assigns the intended column types rather than silently converting identifiers.

Common problems

If every record appears in one column, inspect the delimiter setting. If one record has too many columns, inspect CSV quoting rather than deleting punctuation. If dates change appearance after reopening, inspect the literal saved text and the importer’s type rules separately. If an entire worksheet seems absent, verify which sheet was active when exporting; CSV is not a multi-sheet container.

For repeated deliveries, keep a small written specification containing encoding, separator, header names, column types and the meaning of empty fields. Test the conversion against that specification after any application or export-setting change. This is more reliable than judging success from a spreadsheet preview that may have already reformatted the values.

References

Microsoft: import and export text files, save a workbook in text format, and Text Import Wizard.