OTS File Extension

OTS file icon

OpenDocument Spreadsheet Template

What is a OTS file?

OpenDocument Spreadsheet Template, identified by the OTS extension, is a Spreadsheet Files type and includes 113 files.

OTS files are supported by Windows, Linux and Mac OS. If you need to open a OTS file, you can use one of 7 programs, such as OpenOffice Calc, LibreOffice Calc and StarOffice.

MIME types

  • application/vnd.oasis.opendocument.spreadsheet-template
  • application/x-vnd.oasis.opendocument.spreadsheet-template

File Signature

HEX code: 50 4B 03 04. ASCII code: PK.

How to open a OTS file?

If you’re having difficulty opening a OTS file, it is often due to not having the correct software. To solve the problem, choose a compatible program from the list. Then follow the link to the official developer site, download the software, and install it on your device.

The most popular programs for working with OTS files are OpenOffice Calc, LibreOffice Calc and StarOffice. To install the current version of StarOffice, go directly to the official Oracle website. The universal package for all operating systems is available there.

Following installation, OTS files should be automatically opened with StarOffice.

Set StarOffice as the default OTS program

Changing the default program in Windows

  1. Right-click your OTS file, then navigate to the "Open With" option and click "Choose Another Application" to continue;
  2. In the pop-up window, select the StarOffice application;
  3. Check the "Always use this application" checkbox, and then click "OK" to apply the selected application as the default for opening OTS files.

Change Default Program on Mac

  1. Right click or Control + left click on the desired OTS file;
  2. Select "Open in application" and click "Other";
  3. Look at the bottom of the window, where you will see the "Enable" menu. "Recommended Programs" will be selected as the default option;
  4. Within this menu select "All Programs" and navigate to StarOffice. Check the box next to "Always open in app" to make sure it’s the default option.

Convert to and from OTS

For difficult OTS files, try converting them to formats like PDF, CSV, XLS, XLSX, ODS or similar formats to improve usability.

Please note that after converting a OTS file, some functionality may differ from the original. However, in many cases, it can be converted back to its original format.

Using offline applications such as IBM Lotus Symphony, you can convert OTS files to various formats without losing data quality.

Convert OTS to other file formats

Converting Files to OTS Format

Solve problems with OTS files

When issues arise with OTS files, they can generally be fixed with small software tweaks. Use the troubleshooting tips below to help resolve them.

What are the telltale signs of a corrupt OTS file?

Corrupted OTS spreadsheet files may have one or more of the following symptoms:

  • Unexpected expansion of the total size of the OTS file;
  • Opening or processing the file in StarOffice or other programs causes instability or crashes in the program;
  • The file shows errors when trying to open it or does not open completely;
  • While working with the file, error messages appear;
  • Poor performance when editing a file in OpenOffice Calc;

Why does StarOffice crash or shut down frequently?

StarOffice crashes can occur due to outdated software versions. To mitigate this, install the latest updates for Oracle products.

Restarting your computer will solve many common problems, which is why it’s the first thing you should do before changing any settings related to the software.

Is there any specific software or utility that can help repair a damaged OTS file?

Open the damaged OTS file with a recovery program, and then select the "Repair" menu item to start the repair process. Wait for the recovery process to finish, as it will automatically repair damaged spreadsheet files.

How to edit a OTS file?

To edit OTS files, you need to install specialized software that allows you not only to open but also to modify spreadsheet files. Online OTS editors usually provide fewer features than software created specifically for OpenDocument Spreadsheet Template.

List of Top OTS editors 2026

Taking into account the provided details, we have prepared a list of OTS editors that match your needs.

OTS Editor SoftwareDeveloperPlatformsOverall Rating
IBM Lotus SymphonyIBMWindows4.7 out of 5 (36 reviews)
OpenOffice CalcOpenOfficeWindows, Mac OS, Linux4.6 out of 5 (44 reviews)
LibreOffice CalcTDFWindows, Mac OS, Linux4.4 out of 5 (32 reviews)
NeoOfficePlanamesaMac OS4.2 out of 5 (40 reviews)
StarOfficeOracleWindows4.1 out of 5 (35 reviews)