Convert XLS to CSV
Turn XLS workbooks into CSV files. One CSV per worksheet, hidden ones included.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop XLS files on the dialor turn it to pick what to do
One CSV for each worksheet.An old Excel workbook becomes plain rows of values you can open anywhere.
What you get
One CSV file per worksheet in the workbook. Hidden worksheets are included, so a workbook with several sheets gives you several files.
Chart sheets and empty sheets are skipped. They produce no file.
How values are written
Formulas are written as their last computed values, not as the formulas themselves. Dates are written as YYYY-MM-DD. Numbers are written without their display format.
Choosing one sheet
Set Sheet to convert a single worksheet. Give its name or its number counting from 1. When Sheet is left out, every worksheet is converted.
When it stops
A file that cannot be parsed stops with
input_corrupted. A workbook that needs a password stops withinput_encrypted.To go the other way, use CSV to XLS.
XLS and CSV.What each format is, and the options this conversion takes.
- 01 · sheet
Sheet
The one worksheet to convert, by its name or by its number counting from 1. Every worksheet is converted when it is left out.
The formats
Excel 97-2003 Workbook
The binary Excel workbook format from Excel 97 through 2003, and its templates (.xlt). WPS Spreadsheets saves the same format as .et and .ett.
- Extensions
- .xls .xlt .et .ett
- MIME type
- application
/vnd .ms -excel - Kind
- Documents
CSV
Rows of comma-separated values. The plainest way to move a table between programs.
- Extensions
- .csv
- MIME type
- text
/csv - Kind
- Text and data
In your code.The same XLS to CSV conversion through the API, for your app or your agent.
$ cv convert sheet.xls sheet/ --to csv$ cv convert sheet.xls sheet/ --to csvQuestions.What people ask about XLS to CSV.
Yes, unless you set Sheet. Each worksheet becomes its own CSV, hidden ones included. Chart sheets and empty sheets are skipped.
No. Each formula cell is written as the last value it computed.
Dates are written as YYYY-MM-DD.
The workbook needs a password, and the conversion stops with input_encrypted.