Skip to content
HALOWERK

Formatwerk

xlsx typed json

Reads cells with their style index and resolves the number format (built-in ids 14-22 and 45-47 per ECMA-376 §18.8.30, custom format codes analysed for date/time tokens outside quotes and brackets). Date serials are converted with the workbook's date system: 1900 system with the fictitious 29 February 1900 (serial 60, reported as an error) or 1904 system (§18.17.4.1); elapsed-time formats ([h]:mm:ss) become durations. Shared strings, inline and rich text are joined, merged ranges can be.

POST https://format.halowerk.com/v1/xlsx-typed-json

Inputs

Fields of the published input schema
FieldTypeRequiredDescription
content_base64stringNoThe XLSX file as base64 (a data: prefix and whitespace are tolerated); at most 10 MB decoded.
urlstringNoPublic http(s) URL of the XLSX file (at most 10 MB). Private, local and reserved addresses are refused.
sheetstringNoOnly this sheet (name); default all worksheets.
header_rowintegerNoRow number of the header; 0 = no header (columns named A, B, ...). Default: detected.
max_rowsintegerNoRows returned per sheet; types are inferred over all rows.
mergedstringNoCopy the value of a merged range to all its cells, or keep it only in the top-left cell.
Show full input schema
{
  "type": "object",
  "additionalProperties": false,
  "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."
    },
    "sheet": {
      "type": "string",
      "minLength": 1,
      "maxLength": 31,
      "description": "Only this sheet (name); default all worksheets."
    },
    "header_row": {
      "type": "integer",
      "minimum": 0,
      "maximum": 1000,
      "description": "Row number of the header; 0 = no header (columns named A, B, ...). Default: detected."
    },
    "max_rows": {
      "type": "integer",
      "minimum": 1,
      "maximum": 20000,
      "default": 1000,
      "description": "Rows returned per sheet; types are inferred over all rows."
    },
    "merged": {
      "type": "string",
      "enum": [
        "fill",
        "top_left"
      ],
      "default": "fill",
      "description": "Copy the value of a merged range to all its cells, or keep it only in the top-left cell."
    }
  }
}

Open original schema

Published input example

{
  "max_rows": 100,
  "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"
}

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 →