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.

  1. 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.

  2. 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.

  3. 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.

  4. When it stops

    A file that cannot be parsed stops with input_corrupted. A workbook that needs a password stops with input_encrypted.

    To go the other way, use CSV to XLS.

XLS and CSV.What each format is, and the options this conversion takes.

  1. 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

From · XLS

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
To · CSV

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.

terminal
$ cv convert sheet.xls sheet/ --to csv
$ cv convert sheet.xls sheet/ --to csv

Questions.What people ask about XLS to CSV.

01OF 04

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.

More conversions.Other ways in and out of XLS and CSV.