Skip to content
HALOWERK

Formatwerk

xlsx diff

Reads both workbooks with the same typed cell reader as xlsx-typed-json (dates via number formats, shared formulas expanded) and compares sheets matched by name. Address mode reports every cell that was added, removed, changed in value, in formula, in both, or in type, in row-major order. Key mode aligns rows by a key column (header name or column letter) so inserted, deleted or re-sorted rows do not cascade: it lists added and removed keys and, for matching keys, the changed columns by.

POST https://format.halowerk.com/v1/xlsx-diff

Inputs

Fields of the published input schema
FieldTypeRequiredDescription
oldobjectYesThe earlier workbook.
newobjectYesThe later workbook.
matchstringNoCompare by cell address or align rows by a key column.
key_columnstringNoHeader name or column letter of the key column (match = key).
header_rowintegerNoHeader row for match = key.
sheetsarrayNoOnly these sheet names.
tolerancenumberNoAbsolute tolerance for numeric values.
max_changesintegerNoUpper limit for listed changes.
Show full input schema
{
  "type": "object",
  "additionalProperties": false,
  "required": [
    "old",
    "new"
  ],
  "properties": {
    "old": {
      "type": "object",
      "additionalProperties": false,
      "description": "The earlier workbook.",
      "properties": {
        "content_base64": {
          "type": "string",
          "minLength": 8,
          "maxLength": 13981016,
          "description": "The XLSX file as base64 (a data: prefix and whitespace are tolerated); at most 10 MB decoded."
        },
        "url": {
          "type": "string",
          "format": "uri",
          "maxLength": 2048,
          "description": "Public http(s) URL of the XLSX file (at most 10 MB). Private, local and reserved addresses are refused."
        }
      }
    },
    "new": {
      "type": "object",
      "additionalProperties": false,
      "description": "The later workbook.",
      "properties": {
        "content_base64": {
          "type": "string",
          "minLength": 8,
          "maxLength": 13981016,
          "description": "The XLSX file as base64 (a data: prefix and whitespace are tolerated); at most 10 MB decoded."
        },
        "url": {
          "type": "string",
          "format": "uri",
          "maxLength": 2048,
          "description": "Public http(s) URL of the XLSX file (at most 10 MB). Private, local and reserved addresses are refused."
        }
      }
    },
    "match": {
      "type": "string",
      "enum": [
        "address",
        "key"
      ],
      "default": "address",
      "description": "Compare by cell address or align rows by a key column."
    },
    "key_column": {
      "type": "string",
      "minLength": 1,
      "maxLength": 200,
      "description": "Header name or column letter of the key column (match = key)."
    },
    "header_row": {
      "type": "integer",
      "minimum": 1,
      "maximum": 1000,
      "default": 1,
      "description": "Header row for match = key."
    },
    "sheets": {
      "type": "array",
      "maxItems": 50,
      "items": {
        "type": "string",
        "minLength": 1,
        "maxLength": 31
      },
      "description": "Only these sheet names."
    },
    "tolerance": {
      "type": "number",
      "minimum": 0,
      "maximum": 1000000,
      "default": 0,
      "description": "Absolute tolerance for numeric values."
    },
    "max_changes": {
      "type": "integer",
      "minimum": 1,
      "maximum": 10000,
      "default": 2000,
      "description": "Upper limit for listed changes."
    }
  }
}

Open original schema

Published input example

{
  "old": {
    "content_base64": "UEsDBBQAAAAIAAAAYl0cdPw42AAAAPYBAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbK2RvU4DMQzHX+WUtWpcGDqgXhfKCgy8gJvz9aLLl2K3XN++uVAYUIGFyUr+Hz9L3rydE3EzeRe4VYNIegBgM5BH1jFRKEofs0cpz3yAhGbEA8H9arUGE4NQkKXMHWq72VGPRyfN01S+2cbQqkyOVfP4YZxZrcKUnDUoRYdT6L5RlleCLsnq4cEmXhSDgpuEWfkZcM29nChn21Hzilme0RcXTA7eYx73MY7695IbW8a+t4a6aI6+RDSnTNjxQCTe6Tq1RxsWf/OrmaGOu39e5Kv/cw+o595eAFBLAwQUAAAACAAAAGJd/luGcooAAADwAAAACwAAAF9yZWxzLy5yZWxzjc8xDsIwDAXQq1Q+QF0YGFDaiaUr4gImddqqTRw5QZTbk7EgBkbrf70vmyuvlGcJaZpjqja/htTClHM8IyY7sadUS+RQEifqKZdTR4xkFxoZj01zQt0b0Jm9WfVDC9oPB6hur8j/2OLcbPki9uE55B8TX40ik46cW9hWfIoud5GlLihgZ/Djwe4NUEsDBBQAAAAIAAAAYl22VKrPjgAAAPEAAAAaAAAAeGwvX3JlbHMvd29ya2Jvb2sueG1sLnJlbHONzz0OwjAMBeCrVDlA3TIwoCYTS1fEBaLUbaI2P7KNgNsTMaAiMTBZfpa+Jw8X3KyEnNiHws0jbom18iLlBMDOY7Tc5oKpXuZM0UpdaYFi3WoXhEPXHYH2hjLD3mzGSSsap14112fBf+w8z8HhObtbxCQ/KuCeaWWPKBW1tKBo9YkY3qNvq6rADPD1oXkBUEsDBBQAAAAIAAAAYl124Es9kgAAAOMAAAAPAAAAeGwvd29ya2Jvb2sueG1sjY8xDoMwDEWvEvkANXTogICpC3NPkAbTRJA4soPa4xdB2TvZ/3/5fbl9s8xP5tl84pK0A19KbhDVeYpWL5wpbcnEEm3ZpLxQs5Ad1ROVuOC1qm4YbUhwEBr5h8HTFBzd2a2RUjkgQostgZP6kBX6dm/Q3zTJRurgUdjNYHZrGDuowUgTtkWGsQbsWzyv8Hys/wJQSwMEFAAAAAgAAABiXdOY6AsKAQAAhQIAABgAAAB4bC93b3Jrc2hlZXRzL3NoZWV0MS54bWx1ksFugzAQRH8F+ZhDF3DVQ2QsEcihUg8tTT7AIqZYxTayt0n79wWKaEBw845n7DfSspt1n76WEoNv3RifkBqx3QP4spZa+AfbStPdVNZpgd3oPsC3TorLENINxGH4BFooQzi7KC2NV9YETlYJSaN9TglwNnhzgYIzZ2+BS0jUucv+kEYkwIQo0ygj39F1uvKcIX/OGSBn0E9Qju7DlvvtSxhU+LOSybYyZ6Pw1alSroTyrdDJomjmAeg6TcXiqVi88UJWpKfjWrc+euUxg+s9/aiGcznv5Yof4l3WBare8vhvmRHRiYhuEBXnl2OxRkSHv6MF0aguiegfEd1ldCSKlkRwtwgwbR7/BVBLAQIUAxQAAAAIAAAAYl0cdPw42AAAAPYBAAATAAAAAAAAAAAAAACAAQAAAABbQ29udGVudF9UeXBlc10ueG1sUEsBAhQDFAAAAAgAAABiXf5bhnKKAAAA8AAAAAsAAAAAAAAAAAAAAIABCQEAAF9yZWxzLy5yZWxzUEsBAhQDFAAAAAgAAABiXbZUqs+OAAAA8QAAABoAAAAAAAAAAAAAAIABvAEAAHhsL19yZWxzL3dvcmtib29rLnhtbC5yZWxzUEsBAhQDFAAAAAgAAABiXXbgSz2SAAAA4wAAAA8AAAAAAAAAAAAAAIABggIAAHhsL3dvcmtib29rLnhtbFBLAQIUAxQAAAAIAAAAYl3TmOgLCgEAAIUCAAAYAAAAAAAAAAAAAACAAUEDAAB4bC93b3Jrc2hlZXRzL3NoZWV0MS54bWxQSwUGAAAAAAUABQBFAQAAgQQAAAAA"
  },
  "new": {
    "content_base64": "UEsDBBQAAAAIAAAAYl0cdPw42AAAAPYBAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbK2RvU4DMQzHX+WUtWpcGDqgXhfKCgy8gJvz9aLLl2K3XN++uVAYUIGFyUr+Hz9L3rydE3EzeRe4VYNIegBgM5BH1jFRKEofs0cpz3yAhGbEA8H9arUGE4NQkKXMHWq72VGPRyfN01S+2cbQqkyOVfP4YZxZrcKUnDUoRYdT6L5RlleCLsnq4cEmXhSDgpuEWfkZcM29nChn21Hzilme0RcXTA7eYx73MY7695IbW8a+t4a6aI6+RDSnTNjxQCTe6Tq1RxsWf/OrmaGOu39e5Kv/cw+o595eAFBLAwQUAAAACAAAAGJd/luGcooAAADwAAAACwAAAF9yZWxzLy5yZWxzjc8xDsIwDAXQq1Q+QF0YGFDaiaUr4gImddqqTRw5QZTbk7EgBkbrf70vmyuvlGcJaZpjqja/htTClHM8IyY7sadUS+RQEifqKZdTR4xkFxoZj01zQt0b0Jm9WfVDC9oPB6hur8j/2OLcbPki9uE55B8TX40ik46cW9hWfIoud5GlLihgZ/Djwe4NUEsDBBQAAAAIAAAAYl22VKrPjgAAAPEAAAAaAAAAeGwvX3JlbHMvd29ya2Jvb2sueG1sLnJlbHONzz0OwjAMBeCrVDlA3TIwoCYTS1fEBaLUbaI2P7KNgNsTMaAiMTBZfpa+Jw8X3KyEnNiHws0jbom18iLlBMDOY7Tc5oKpXuZM0UpdaYFi3WoXhEPXHYH2hjLD3mzGSSsap14112fBf+w8z8HhObtbxCQ/KuCeaWWPKBW1tKBo9YkY3qNvq6rADPD1oXkBUEsDBBQAAAAIAAAAYl124Es9kgAAAOMAAAAPAAAAeGwvd29ya2Jvb2sueG1sjY8xDoMwDEWvEvkANXTogICpC3NPkAbTRJA4soPa4xdB2TvZ/3/5fbl9s8xP5tl84pK0A19KbhDVeYpWL5wpbcnEEm3ZpLxQs5Ad1ROVuOC1qm4YbUhwEBr5h8HTFBzd2a2RUjkgQostgZP6kBX6dm/Q3zTJRurgUdjNYHZrGDuowUgTtkWGsQbsWzyv8Hys/wJQSwMEFAAAAAgAAABiXZF14GUMAQAAhQIAABgAAAB4bC93b3Jrc2hlZXRzL3NoZWV0MS54bWx1ksFugzAQRH8F+ZhDF3DUQ2QsEcihUg8tTT7AIiZYxQbZ26T9+xqCEIng5p2dsd9IZrfWfrtaSgx+dWNcQmrEbgfgylpq4V7aThq/qVqrBfrRXsB1VorzENINxGH4ClooQzg7Ky2NU60JrKwSkka7nBLgbPDmAgVntr0FNiGRd5f9IY1IgAlRplFGfqH1unKcIX/LGSBn0E9Qju79mvvzRxhU+LeQydYyJ6Pww6pSLoTytdCxRdE8BsB3morFU7F45YasSI+HpW599MpjBtc5/ag+yXkvV3wfbzK/qXrLdjtZHojoRERXiIrT+6FYIqLD29ET0aiGT0T0TkQ3GR2JZpY7Ecw+Akw/j/8DUEsBAhQDFAAAAAgAAABiXRx0/DjYAAAA9gEAABMAAAAAAAAAAAAAAIABAAAAAFtDb250ZW50X1R5cGVzXS54bWxQSwECFAMUAAAACAAAAGJd/luGcooAAADwAAAACwAAAAAAAAAAAAAAgAEJAQAAX3JlbHMvLnJlbHNQSwECFAMUAAAACAAAAGJdtlSqz44AAADxAAAAGgAAAAAAAAAAAAAAgAG8AQAAeGwvX3JlbHMvd29ya2Jvb2sueG1sLnJlbHNQSwECFAMUAAAACAAAAGJdduBLPZIAAADjAAAADwAAAAAAAAAAAAAAgAGCAgAAeGwvd29ya2Jvb2sueG1sUEsBAhQDFAAAAAgAAABiXZF14GUMAQAAhQIAABgAAAAAAAAAAAAAAIABQQMAAHhsL3dvcmtzaGVldHMvc2hlZXQxLnhtbFBLBQYAAAAABQAFAEUBAACDBAAAAAA="
  },
  "match": "key",
  "key_column": "ID"
}

Result & documentation

Machine-readable documentation of this hub

Source of this page: the published HALOWERK catalog. Updated: 2026-11-17 UTC.

More endpoints in this hub

All endpoints in this hub โ†’