Convert XLSX to CSV

Data from a spreadsheet has to be imported into a database, a CRM, an accounting package or a script that only reads CSV.

SafeConvert engineFreeNo sign-upBatch supported
Conversion Deck
Uploaded to server: 0 B
    Waiting for files/Engine: on-device/Network requests made: 0
    What actually changes

    XLSX and CSV are not the same picture in two wrappers.

    One worksheet becomes one text file of delimited rows. Formulas are replaced by their last calculated values, and formatting, charts, merged cells and multiple sheets are all discarded.

    Worth knowing first

    CSV has no types, so everything is re-interpreted by whatever opens it next. Leading zeros in postcodes and account numbers disappear, long IDs turn into scientific notation, and dates get reformatted according to the reader's locale rather than yours.

    Questions

    XLSX to CSV, answered

    Which sheet gets converted?

    One per file. A multi-sheet workbook produces several CSVs, because the format has no way to hold more than one table.

    How do I stop Excel mangling my IDs?

    Import the CSV through Data, From Text rather than double-clicking it, and mark those columns as Text in the wizard.

    Are formulas kept?

    No. CSV stores values only. The last computed result is what you get.

    How to convert XLSX to CSV

    01

    Add your files

    Drop one XLSX or two hundred. Batch conversion is not a paid feature here.

    02

    Choose your settings

    Comma-Separated Values is lossless, so nothing is thrown away in the conversion.

    03

    Download

    Converted and deleted the moment it finishes. Never written to permanent storage.

    Related conversions