Map Extract
Free tool

Convert spreadsheets between Excel, ODS and CSV formats

Choose one or more spreadsheets, pick the format you need and download. Old XLS files become XLSX, LibreOffice ODS becomes Excel and back, and any sheet can go to CSV, TSV or an HTML table, with a preview of the first rows before you convert.

Runs in your browser. Nothing you enter is uploaded.

Converting spreadsheets

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

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

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

  4. Preview

    The figures show files, sheets, total size and output format, and the first 20 rows of the chosen sheet are shown.

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

Input
orders.xlsx: sheets Orders (formula column) and Prospects
Convert to: CSV, Semicolon, Every sheet
Result
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;Frome

Choosing an output format

FormatUse it whenWatch out for
XLSXAlmost always; the modern defaultNothing in particular
XLSSomeone has very old softwareFormulas may come through as values; size limits
XLSBVery large workbooks that open slowlyLess widely supported outside Excel
ODSRecipients use LibreOfficeSome formatting may change
CSV or TSVImporting into a CRM, mail tool or databaseOne sheet per file, values only
Excel 2003 XMLA legacy system asks for itCharts and images are lost
HTMLPasting a table into a web pageOne 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

Top