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-jsonInputs
| Field | Type | Required | Description |
|---|---|---|---|
| content_base64 | string | No | The XLSX file as base64 (a data: prefix and whitespace are tolerated); at most 10 MB decoded. |
| url | string | No | Public http(s) URL of the XLSX file (at most 10 MB). Private, local and reserved addresses are refused. |
| sheet | string | No | Only this sheet (name); default all worksheets. |
| header_row | integer | No | Row number of the header; 0 = no header (columns named A, B, ...). Default: detected. |
| max_rows | integer | No | Rows returned per sheet; types are inferred over all rows. |
| merged | string | No | Copy 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."
}
}
}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
- Formatwerk0.004 USDC
accounting csv unify
POSThttps://format.halowerk.com/v1/accounting-csv-unifyDATEV booking batch files (EXTF/DTVF, category 21) are read by their documented field positions: amount and S/H become a signed amount relative to the account, Belegdatum TTMM is resolved within the fiscal year from the header. Other export
- Formatwerk0.005 USDC
avv checklist
POSThttps://format.halowerk.com/v1/avv-checklistChecklist after Art. 28 GDPR (Regulation (EU) 2016/679 Art. 28 (GDPR), https://eur-lex.europa.eu/eli/reg/2016/679/oj, German and English text retrieved from the EU Publications Office 2026-11-01): Art. 28(3) sentence 1 (subject-matter, dura
- Formatwerk0.004 USDC
bagit package
POSThttps://format.halowerk.com/v1/bagit-packageCreate: files go to data/, manifest-<alg>.txt and tagmanifest-<alg>.txt are written for SHA-256 (default), SHA-512 or legacy SHA-1/MD5, bag-info.txt gets your metadata plus Bagging-Date, Bag-Size and Payload-Oxum; paths are checked (no abso