ConvertOnline

Menu

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

{
  "convert": "xls-ods",
  "multiple": true,
  "from": "xls",
  "to": "ods",
  "controls": [
    {
      "type": "checkbox",
      "name": "preserve_formatting",
      "label": "Preserve Formatting",
      "defaultValue": true,
      "desc": "Attempts to retain original cell formatting, fonts, borders, and colors during conversion."
    },
    {
      "type": "checkbox",
      "name": "preserve_formulas",
      "label": "Preserve Formulas",
      "defaultValue": true,
      "desc": "Keeps spreadsheet formulas in editable form whenever possible, rather than converting them to static values."
    },
    {
      "type": "checkbox",
      "name": "convert_macros",
      "label": "Convert Macros (Experimental)",
      "defaultValue": false,
      "desc": "Attempts to convert Excel VBA macros to OpenDocument-compatible macros. Due to language differences, this may not work perfectly."
    },
    {
      "type": "dropdown",
      "name": "image_compression",
      "label": "Image Compression",
      "options": [
        {
          "label": "None (retain original)",
          "value": "none"
        },
        {
          "label": "Low (smallest size)",
          "value": "low"
        },
        {
          "label": "Medium (balanced)",
          "value": "medium"
        },
        {
          "label": "High (better quality)",
          "value": "high"
        }
      ],
      "defaultValue": "medium",
      "desc": "Controls the compression level for embedded images in the spreadsheet."
    },
    {
      "type": "checkbox",
      "name": "remove_comments",
      "label": "Remove Comments",
      "defaultValue": false,
      "desc": "Deletes all cell comments/notes from the spreadsheet during conversion."
    },
    {
      "type": "checkbox",
      "name": "password_protect",
      "label": "Password Protect Output",
      "defaultValue": false,
      "desc": "Applies a password to the resulting ODS file. You will be prompted for the password before conversion."
    },
    {
      "type": "text",
      "name": "metadata_author",
      "label": "Author Metadata",
      "optional": true,
      "placeholder": "e.g., Jane Smith",
      "desc": "Sets the 'Author' field in the spreadsheet's metadata."
    },
    {
      "type": "checkbox",
      "name": "remove_personal_info",
      "label": "Remove Personal Information",
      "defaultValue": false,
      "desc": "Removes personal metadata such as creator name, company, and revision history."
    }
  ],
  "note": "ODS (OpenDocument Spreadsheet) is the ISO-standard open format for spreadsheets, primarily used by LibreOffice and OpenOffice. Converting from XLS may cause minor differences in complex formulas, pivot tables, or macros due to differences in supported features. ODS is better for open-source compatibility, collaborative editing, and long-term archival, but some advanced Excel-specific features like VBA macros and certain conditional formatting rules may not transfer perfectly.",
  "type": "document",
  "operation": "convert"
}