Convert OTS to NUMBERS

Turn OTS documents into NUMBERS. Each sheet becomes a Numbers sheet holding one table, named after it and in the same order.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop OTS files on the dialor turn it to pick what to do

A Numbers file from your template.Each sheet becomes a Numbers sheet with one table. Values and formatting stay.

  1. What you get

    A Numbers file with one sheet for each sheet in the OTS file, in the same order and with the same names. Each sheet holds one table.

    Values, number and date formats are kept. So are fonts, bold, italic, underline, text and fill colors, alignment and borders. Merged cells, column widths and row heights are kept too.

  2. What changes

    Formulas become their last computed values, so the cells show numbers and text but no longer calculate. Numbers keep 15 significant digits.

    Fonts that Numbers does not have become Helvetica Neue. Hidden sheets, rows and columns are shown.

  3. What is left out

    Charts, images, comments and links are not copied into the Numbers file.

    A document of more than 300,000 cells fails with unsupported_elements.

OTS and NUMBERS.What each format is.

The formats

From · OTS

OpenDocument Spreadsheet Template

A LibreOffice Calc template. New spreadsheets start from a copy of it.

Extensions
.ots
MIME type
application/vnd.oasis.opendocument.spreadsheet-template
Kind
Documents
To · NUMBERS

Apple Numbers

Apple Numbers spreadsheets from macOS and iOS.

Extensions
.numbers
MIME type
application/vnd.apple.numbers
Kind
Documents

In your code.The same OTS to NUMBERS conversion through the API, for your app or your agent.

terminal
$ cv convert report.ots report.numbers
$ cv convert report.ots report.numbers

Questions.What people ask about OTS to NUMBERS.

01OF 04

No. Each formula becomes the last value it computed. The cell keeps the result, not the calculation.

No. They are shown in the Numbers file.

No. Charts, images, comments and links are left out.

The document has more than 300,000 cells. Documents over that size are not converted.

More conversions.Other ways in and out of OTS and NUMBERS.