Skip to content

Convert OTS to XLS

Convert an OTS spreadsheet template into an editable Excel 97–2003 workbook.

Make XLS files online

We can't read OTS files yet, so this conversion isn't available. If you can export your work to one of these formats - or others - we'll turn it into XLS:

Want to convert OTS to XLS?

Let us know. We pick the conversions to add next by how many people ask for them.

How to convert ots to xls file

Older Microsoft Excel versions and business systems may require an XLS workbook rather than an OTS spreadsheet template. Saving the template as XLS creates a workbook for editing; it does not preserve the file as a reusable OTS template.

What the OTS format is

OTS is the OpenDocument Spreadsheet Template format, used for reusable spreadsheet layouts, styles, formulas, and starting content. LibreOffice Calc and Apache OpenOffice Calc create and open OTS files. The format is an OpenDocument XML package.

What the XLS format is

XLS is the Excel 97–2003 workbook format, based on Microsoft’s binary BIFF format. It is used when older Excel versions or other systems require a legacy Excel workbook. Each sheet is limited to 65,536 rows and 256 columns, and XLS cannot retain some features supported by newer spreadsheet formats.

Convert with LibreOffice Calc

  1. Open template.ots in LibreOffice Calc. Calc creates a document based on the template, leaving the original template available.
  2. Choose File → Save As.
  3. Select Excel 97–2003 (.xls) in the file type list, choose a destination and filename, then save.
  4. If prompted to choose a format, select Use Excel 97–2003 Format. Reopen the saved .xls file and check its sheets, formulas, and layout.

LibreOffice Calc is a practical desktop option because it reads OTS and exports XLS. Apache OpenOffice Calc can also perform this conversion through its save-as format list. Microsoft Excel does not natively open OTS templates. For a non-confidential file, CloudConvert is an online alternative if its current format selector offers OTS input and XLS output; verify the converted workbook before using it.

Check compatibility

Sheets exceeding XLS row or column limits cannot be represented fully. Formulas, formatting, and other features unsupported by Excel 97–2003 may be altered or discarded, and Calc may display a compatibility warning. Check formula results and print layout in the application that will use the XLS file.

OTS vs XLS: format comparison

How the OTS and XLS formats compare on the properties that matter most for this conversion.

Comparison of the OTS and XLS file formats
Property .OTS OpenDocument Spreadsheet Template .XLS Microsoft Excel Spreadsheet
Editable text No No
Fixed page layout No No
Text formatting Extensive Extensive
Images Yes Limited
Interactive elements Limited Yes
Password protection Basic Basic
Opens in a web browser No Partial
Typical file size Medium Medium
Open standard Yes No
Best used for Editing and post-production Data exchange
Introduced 2005 1987
Developer OASIS Microsoft
MIME type application/vnd.oasis.opendocument.spreadsheet-template application/vnd.ms-excel

Information about file extensions and file types is provided by File-Extensions.org

Already downloaded

This file has already been downloaded. For your privacy it was deleted from our server right after the download, so it cannot be downloaded again. To get it once more, convert the file again.