Converting spreadsheets
Choose the files
XLSX, XLSM, XLSB, XLS, XLT, XLTX, XLTM, ODS, FODS, CSV, TSV and Excel 2003 XML are accepted, several at a time. Files that cannot be read, or are password protected, are listed with a message.
Pick the output
Use a common pair (XLS to XLSX, XLSX to XLS, XLSB to XLSX, ODS to XLSX, XLSX to ODS, XLSX to CSV) or choose from Convert to.
Set CSV options
For CSV, choose comma or Semicolon (European Excel). For CSV, TSV and HTML with several sheets, tick Every sheet (one file each) or pick one sheet.
Preview
The figures show files, sheets, total size and output format, and the first 20 rows of the chosen sheet are shown.
Download
One output downloads directly; several are zipped.
An order workbook to semicolon CSV and to XLS
The two-sheet test workbook, with formulas in the value column, converted to CSV with semicolons and every sheet ticked. That gives two files named after the workbook and each sheet, with the formula results as values. CSV and TSV files start with a byte order mark so Excel reads them as UTF-8.
Converting the same workbook to ODS kept the formula =C2*9 in the value column. Converting it to XLS kept the value 324 but not the formula in our test, so keep the original if formulas matter and you need the old format.
orders.xlsx: sheets Orders (formula column) and Prospects Convert to: CSV, Semicolon, Every sheet
converted-csv.zip
orders-Orders.csv
stockist;town;pieces;value
Marlow Print Works;Bath;36;324
Pip & Parsnip Deli;Wells;24;216
orders-Prospects.csv
business;town
Oak Lane Joinery;FromeChoosing an output format
| Format | Use it when | Watch out for |
|---|---|---|
| XLSX | Almost always; the modern default | Nothing in particular |
| XLS | Someone has very old software | Formulas may come through as values; size limits |
| XLSB | Very large workbooks that open slowly | Less widely supported outside Excel |
| ODS | Recipients use LibreOffice | Some formatting may change |
| CSV or TSV | Importing into a CRM, mail tool or database | One sheet per file, values only |
| Excel 2003 XML | A legacy system asks for it | Charts and images are lost |
| HTML | Pasting a table into a web page | One sheet per file |
Keep the original
Spreadsheet formats are not all equal. Converting to XLSX or ODS keeps most of a workbook, but charts, pivot tables, images and some formatting may not survive a change of format, especially to XLS, CSV and XML. Macros are never copied. Convert a copy, open it, check the sheets you care about, and keep the original file.
For a CRM import, CSV is the format to aim for, and the separator matters: many European versions of Excel expect semicolons because they use the comma as the decimal mark.
Questions people ask
How do I convert XLS to XLSX?
Choose the .xls file, pick XLS to XLSX and press Download. The workbook is read and written in the modern Excel format in your browser, keeping its sheets, values, formulas and number formats. Open the new file in Excel to check charts or unusual formatting, which may not carry over.
Can I convert ODS to Excel?
Yes. Choose the .ods file and the ODS to XLSX pair. LibreOffice and OpenOffice spreadsheets convert to Excel with their sheets and values, and XLSX to ODS works the other way for recipients who use LibreOffice.
How do I convert every sheet in a workbook to CSV?
Choose CSV, tick Every sheet (one file each) and download. Each sheet becomes its own CSV named after the workbook and the sheet, delivered together in a ZIP. Pick semicolon as the separator if the file will be opened in a European-language version of Excel.
Are macros kept?
No. Macros are never copied into the converted file, whatever the format. That makes converted files safer to share, but if a workbook depends on macros, keep using the original .xlsm or .xls file in Excel.
Where your data goes
Spreadsheets are converted with the open-source SheetJS library running in your browser. Files are not uploaded, and the converted copies are created locally.
Checked against the tool on