ConvertOnline

Menu

1. Convert Online
2. Document Converters
3. ODS to XLSX

{
  "convert": "ods-xlsx",
  "multiple": true,
  "from": "ods",
  "to": "xlsx",
  "controls": [
    {
      "type": "checkbox",
      "name": "preserve_formulas",
      "label": "Preserve Formulas",
      "defaultValue": true,
      "desc": "Attempts to retain all formulas from the original ODS file. Some OpenDocument-specific formulas may be converted to static values if Excel doesn't support them."
    },
    {
      "type": "checkbox",
      "name": "preserve_formatting",
      "label": "Preserve Cell Formatting",
      "defaultValue": true,
      "desc": "Keeps the original fonts, colors, borders, and number formatting in the converted XLSX file."
    },
    {
      "type": "checkbox",
      "name": "preserve_macros",
      "label": "Preserve Macros (if supported)",
      "defaultValue": false,
      "desc": "Attempts to retain macros when possible. Note that Excel macros are in VBA and may not be preserved from ODS unless they are already in compatible format."
    },
    {
      "type": "checkbox",
      "name": "convert_charts",
      "label": "Convert Charts to Excel Format",
      "defaultValue": true,
      "desc": "Converts embedded charts to Excel's chart engine. Complex ODS charts may be flattened to images if not fully compatible."
    },
    {
      "type": "checkbox",
      "name": "convert_pivot_tables",
      "label": "Convert Pivot Tables",
      "defaultValue": true,
      "desc": "Attempts to convert pivot tables to Excel format. Some advanced ODS pivot table features may not be supported."
    },
    {
      "type": "checkbox",
      "name": "remove_hidden_sheets",
      "label": "Remove Hidden Sheets",
      "defaultValue": false,
      "desc": "Deletes hidden sheets from the output XLSX file to reduce size or hide confidential data."
    },
    {
      "type": "checkbox",
      "name": "password_protect",
      "label": "Password Protect Output",
      "defaultValue": false,
      "desc": "Applies a password to protect the output XLSX file from being opened without authorization."
    }
  ],
  "note": "ODS (OpenDocument Spreadsheet) is the default open format for LibreOffice Calc and other open-source spreadsheet programs. When converting to XLSX, most standard data, formulas, and formatting are preserved, but advanced OpenDocument-specific features—such as certain formula functions, conditional formatting styles, or custom data validations—may be simplified or lost. If the file contains macros, only Excel-compatible VBA macros will be retained.",
  "type": "document",
  "operation": "convert"
}