How to Convert XLS to CSV in Excel: A Complete Guide

Converting an Excel workbook from XLS or XLSX format to CSV is one of the most common file tasks in everyday computing — whether you're moving data between systems, uploading to a web app, or prepping a dataset for analysis. The process looks simple on the surface, but there are a few things worth understanding before you click save.

What's the Difference Between XLS and CSV?

XLS (and its modern counterpart XLSX) is Microsoft Excel's native file format. It stores not just your data, but also formatting, formulas, multiple sheets, charts, conditional formatting rules, and other Excel-specific features.

CSV (Comma-Separated Values) is a plain-text format. Every row in your spreadsheet becomes a line of text, and every cell value is separated by a comma. That's it. No formatting, no formulas, no multiple sheets — just raw data.

This distinction matters because converting to CSV is a one-way simplification. You're not losing your original file, but the CSV version will only capture what's visible in the active sheet, with all the rich formatting stripped away.

How to Convert XLS to CSV Using Excel's Save As

The most direct method uses Excel's built-in Save As function. Here's how it works:

1. Open your XLS or XLSX file in Microsoft Excel
2. Click File in the top menu
3. Select Save As (or Save a Copy in newer versions of Microsoft 365)
4. Choose your destination folder
5. In the Save as type dropdown, select CSV (Comma delimited) (*.csv)
6. Click Save

Excel will likely show a warning message at this point. It will tell you that the selected file format doesn't support workbooks with multiple sheets, and that some features may be lost. This is expected behavior — click Keep Current Format (or Yes) to proceed.

The resulting file will contain only the data from whichever sheet was active when you saved.

Other CSV Format Options in the Dropdown 📄

When you open the Save As file type dropdown, you'll notice several CSV-related options:

For most modern use cases — uploading to a database, importing into a CRM, sharing with another application — CSV UTF-8 is the safest choice. The UTF-8 encoding ensures that special characters, accented letters, and non-Latin scripts are preserved correctly rather than appearing as garbled symbols.

What Gets Lost in the Conversion

Understanding what CSV can't carry is just as important as knowing how to save the file.

• Formulas are replaced by their calculated values
• Formatting — font colors, bold text, cell backgrounds — disappears entirely
• Multiple sheets are not supported; only the active sheet is exported
• Charts and images are dropped
• Merged cells may produce unexpected empty fields
• Date and number formatting can behave unpredictably depending on your regional settings

If your spreadsheet relies heavily on formulas, it's worth double-checking the CSV output to confirm the values exported as expected, especially for calculations involving dates or currency.

Converting Multiple Sheets to Separate CSV Files

Excel doesn't offer a built-in batch export for multiple sheets. If you need each sheet as its own CSV file, your options include:

• Manually switching to each sheet and performing a Save As for each one
• Using a macro (VBA) to loop through all sheets and export them automatically
• Third-party tools or online converters that accept XLSX files and output a ZIP of CSVs

For occasional use, the manual method is straightforward enough. For recurring workflows involving large workbooks with many sheets, a macro or automation tool will save significant time.

Converting Without Excel Installed

If you don't have Microsoft Excel, you still have solid options:

• Google Sheets — Import your XLS file, then go to File → Download → CSV. It exports the active sheet.
• LibreOffice Calc — Open-source and free, supports XLS/XLSX, and can export to CSV through the same Save As workflow.
• Online converters — Various web tools accept XLS uploads and return a CSV. These work but introduce privacy considerations if your data is sensitive.

Regional Settings and the Comma Problem 🌍

One frequently overlooked issue: in some countries, the decimal separator is a comma rather than a period. In those regional settings, Excel may export a semicolon-delimited file instead of a true comma-separated one — even if it still uses the .csv extension.

If you're sharing the file internationally or importing into a system that strictly expects commas, it's worth opening the resulting file in a plain text editor (like Notepad) to verify the actual delimiter being used. If it's semicolons, the receiving system may need to be configured accordingly, or the file may need re-export with adjusted regional settings.

When the Conversion Behaves Differently Than Expected

The same XLS-to-CSV workflow can produce noticeably different results depending on:

• Excel version — Microsoft 365, Excel 2019, Excel 2016, and older versions each have slight differences in their Save As dialogs and encoding options
• Operating system — Windows and macOS Excel behave differently around line endings and default encoding
• Regional/locale settings — Affects delimiter choice and how dates and numbers are formatted
• Sheet complexity — Merged cells, hidden rows, or filtered views may or may not export as you'd expect

A straightforward spreadsheet of names and numbers will convert cleanly almost every time. A complex workbook with conditional formatting, data validation, and pivot tables will need more careful review after export.

The format you need on the receiving end — and the complexity of what you're starting with — shapes whether a simple Save As gets you there, or whether you need a more deliberate approach.