Convert ODS to NUMBERS
Turn ODS spreadsheets 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 ODS files on the dialor turn it to pick what to do
Your ODS sheets as Numbers sheets.Each sheet becomes a Numbers sheet with one table, in the same order.
What you get
A Numbers document with one sheet for each sheet in the ODS file. Each sheet holds one table named after the original sheet.
Values, number formats and date formats are kept. So are fonts, bold, italic, underline, strikethrough, text colors, fill colors, alignment and wrapping. Borders, merged cells, column widths and row heights are kept as well.
Up to five frozen rows and columns become header rows.
What changes
Formulas become their last computed values, so the cells show numbers and text, not formulas. Numbers keep 15 significant digits.
Fonts that Numbers does not have become Helvetica Neue. Hidden sheets, rows and columns are shown.
What is left out
Charts, images, comments, links, conditional formats and validation lists are not carried over. If you need the data back in an ODS file later, NUMBERS to ODS goes the other way.
Large spreadsheets
A document of more than 300,000 cells fails with
unsupported_elements.
ODS and NUMBERS.What each format is.
The formats
OpenDocument Spreadsheet
OpenDocument spreadsheet, the native format of LibreOffice Calc.
- Extensions
- .ods
- MIME type
- application
/vnd .oasis .opendocument .spreadsheet - Kind
- Documents
Apple Numbers
Apple Numbers spreadsheets from macOS and iOS.
- Extensions
- .numbers
- MIME type
- application
/vnd .apple .numbers - Kind
- Documents
In your code.The same ODS to NUMBERS conversion through the API, for your app or your agent.
$ cv convert sheet.ods sheet.numbers$ cv convert sheet.ods sheet.numbersQuestions.What people ask about ODS to NUMBERS.
No. Each formula becomes its last computed value, so the cell holds the result and not the formula.
No. Hidden sheets, rows and columns are shown in the Numbers file.
They are left out. The tables are converted, but charts and images do not appear in the Numbers file.
The document has more than 300,000 cells. A document of that size fails with unsupported_elements.