Why convert XLS to CSV?
CSV is the plain-text format that databases, import wizards, and scripting tools read without special libraries - MySQL, PostgreSQL, Python pandas, and most BI tools accept .CSV directly but cannot reliably parse the old XLS binary format. Converting strips the binary container and leaves raw tabular data that any tool can open.
How to convert XLS to CSV
Microsoft Excel BUILT-IN
Open the file, click the sheet tab you want, then go to File > Save As and choose CSV UTF-8 (Comma delimited) (.csv).
LibreOffice Calc FREE
Open the .xls file, go to File > Save As, select Text CSV (.csv), and set the character encoding to UTF-8 in the export dialog.
Google Sheets FREE
Upload the file to Google Drive, open it with Google Sheets, then go to File > Download > Comma Separated Values.
Command line - LibreOffice CLI
Run soffice --headless --convert-to csv yourfile.xls to produce a .csv in the same directory (first sheet only).
Programs that convert XLS
About these formats
An XLS file is an old-format Microsoft Excel spreadsheet from the Excel 97-2003 era, saved as a binary file rather than the ZIP-based XLSX used since 2007. You can open it free without…
Open .XLS details →A CSV file stores tabular data as plain text - one row per line, values separated by commas (or semicolons in European locales). Any spreadsheet opens it: Excel, Google Sheets, LibreOffice…
Open .CSV details →Quality & what to watch
- Only one sheet exports per conversion - a workbook with multiple sheets needs a separate export for each tab.
- Formulas are replaced by their last calculated values; the original formula is not recoverable from the
.csv. - Date cells may export as serial numbers (e.g.,
44927) instead of readable dates - pre-format them as a date string in Excel before saving.
Frequently asked questions
Does converting XLS to CSV lose data?
Why do my date columns show numbers like 44927 after export?
Can I convert all sheets at once?
.csv per sheet in one pass.Should I convert XLS to XLSX first, then to CSV?
.xls and export .csv directly, so the extra step adds no benefit.