NUMBERS to OTS Converter

A NUMBERS file is a spreadsheet document created by Apple Numbers, part of the iWork productivity suite. The format is based on a bundled package structure (a directory appearing as a file) or a single-file ZIP container (in recent versions), containing an Index.xml (or .iwa protobuf stream), metadata plist files, and embedded assets like images. It utilizes a canvas-based approach rather than a strict grid, allowing multiple isolated tables and distinct media objects on a single sheet.

This format is proprietary to the Apple ecosystem, with native support exclusively on macOS, iOS, and iPadOS via the Apple Numbers app. Windows users cannot open these files natively and must utilize iCloud.com to view or convert the file to Excel (XLSX) format. Some third-party conversion tools can extract the internal XML data, but rendering is often imperfect outside the iWork environment.

The OpenDocument Spreadsheet Template (OTS) is a file format defined by the OASIS OpenDocument standard (ISO/IEC 26300) specifically for creating reusable spreadsheet blueprints. Structurally identical to the ODS format, it uses ZIP compression to package XML content and styles. The primary technical distinction lies in the file header flags, which instruct the software to open a new, untitled instance of the spreadsheet rather than modifying the original template file, preserving the source data structure and formulas.

OTS files function seamlessly with ODF-compliant software including LibreOffice Calc and Apache OpenOffice across all major operating systems. While Microsoft Excel can open these files, users may need to manually select the file type in the open dialog. Double-clicking an OTS file typically launches a new workbook based on the template rather than opening the template file itself for editing.