# Excel Spreadsheet To Json Conversion (`first_watch/excel-spreadsheet-to-json-conversion`) Actor Automation workflows need to turn recurring Excel spreadsheets into predictable JSON without silently accepting malformed dates, numbers, headers, or required fields. Basic converters produce rows but often do not enforce a data contract or clearly quarantine invalid records. - **URL**: https://apify.com/first\_watch/excel-spreadsheet-to-json-conversion.md - **Developed by:** [Jordan Nabbe](https://apify.com/first_watch) (community) - **Categories:** Automation, Developer tools, Business - **Stats:** 2 total users, 1 monthly users, 57.1% runs succeeded, 0 bookmarks - **User rating**: No ratings yet ## Pricing from $3.00 / 1,000 result returneds This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events. Learn more: https://docs.apify.com/actors/running/actors-in-store.md#pay-per-event ## What's an Apify Actor? An Actor is a serverless cloud program that runs on the Apify platform. It has two run modes. In Batch mode, an Actor accepts a well-defined JSON input, performs an action which can take anything from a few seconds to a few hours, and optionally produces a well-defined JSON output, datasets with results, or files in key-value store. In Standby mode, an Actor provides a web server which can be used as a website, API, or an MCP server. Apify vocabulary and the platform model are defined once, in the agent quickstart at https://apify.com/agents.md. ## How to integrate an Actor? If asked about integration, you help developers integrate Actors into their projects. You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready. Do not guess an integration path. Every one of them is in the agent quickstart at https://apify.com/agents.md: the Apify MCP server, Agent Skills with the Apify CLI, the JavaScript and Python clients, the REST API, and the account-free path for an agent with no human to sign in. It also carries the rule on stating cost before the first paid run. For examples already wired to this Actor's own input schema, see the [API](#api) section below. Each client library has reference documentation the quickstart does not restate: [JavaScript/TypeScript](https://docs.apify.com/api/client/js/docs.md) (`npm install apify-client`) and [Python](https://docs.apify.com/api/client/python/docs.md) (`pip install apify-client`). # README ## Excel Contract Validator to JSON Turn recurring supplier and partner spreadsheets (.xlsx, CSV) into JSON rows you can import safely: every row is checked against a JSON Schema you supply. Press **Start** to try it: the prefilled input is a real .xlsx order export with European amounts and one row with an invalid date. Valid rows and rejected rows are kept apart, and each rejection says which document, sheet, row and column failed and why. It makes no web requests and never scrapes anything. ### Input - `documents` (required, 1 to 25): each has `id` and `source`. - `csv`: inline CSV text in `csv` (comma delimiter, RFC-style quotes). - `records` / `json`: an array of objects (or a single object) in `records` / `json`, up to 1000 items, depth 8, 100 keys per object. - `base64`: an XLSX file in `base64` plus `fileName`. - `apifyKeyValueStore`: `keyValueStoreId` and `recordKey`; the only storage read the Actor performs, and only when you ask for it. - `rowSchema` (required): JSON Schema for one row. Supported keywords: type, required, properties, additionalProperties (boolean), enum, const, minimum, maximum, exclusiveMinimum, exclusiveMaximum, minLength, maxLength, pattern, minItems, maxItems, format (`date`, `date-time`). Any other keyword stops the run with `UNSUPPORTED_SCHEMA_KEYWORD` instead of being silently ignored. - `headerAliases`: canonical property name mapped to accepted header variants (case and whitespace insensitive). Headers without an alias become camelCase keys. - `sheetNames`, `headerRow`, `coercionMode` (`strict` or `permissive`), `dateOutput`, `emptyCellMode`, `includeRejectedValues`, `maxRows` (default 100000, max 500000). Strict coercion only converts canonical numeric strings and `true`/`false`. Permissive also trims, reads both 1,234.56 and 1.234,56 notation and currency signs, accepts yes/no, and normalises `YYYY/M/D` dates. A text value such as 1.234 that means 1234 in one notation and 1.234 in the other is never guessed: it is rejected unless you set `numberFormat` to `en` or `eu`. ### Output The default dataset receives one item per valid row (`recordType: validRow`) and nothing else, so every dataset item is a usable result. The `OUTPUT` key-value record holds `outcome` (status and counts), `validRows`, `rejectedRows` (document, sheet, row, column, value and reason) and `manifest` (per-document status, headers and counts). Row keys are sorted alphabetically for deterministic results. ### Pricing Pay per event. The main charge is per valid row; everything else listed below is free. | Event | Price (USD) | Charged when | |---|---|---| | Run start (`apify-actor-start`) | $0.005 | once per run; the default 512 MB memory is one event | | Valid row (`apify-default-dataset-item`) | $0.003 | per valid row delivered to the dataset | Not charged: - rejected rows with the sheet, row, column and reason (in the OUTPUT record) - documents that could not be opened (corrupt, encrypted, legacy .xls, unsafe) - the manifest with per-document status and detected headers Examples (default 512 MB memory, one start event): - Weekly supplier file with 200 valid rows: $0.005 start + 200 × $0.003 = **$0.605** - Monthly export with 5,000 valid rows: $0.005 start + 5000 × $0.003 = **$15.005** - A file that cannot be opened: $0.005 start + 0 × $0.003 = **$0.005** Spending limit: when you set a maximum cost per run, the Actor stops before it would exceed it, keeps every valid row it already delivered and reports `limitReached` in the `OUTPUT` record. It never delivers results beyond the limit. The Store's Pricing tab shows the prices in force. If this section and the Pricing tab ever differ, the Pricing tab applies. ### Limits 25 documents, 25 MB per compressed document, 200 MB expanded, ZIP expansion ratio 100, 5 million cells, 500000 rows per run. Documents are processed one at a time. ### Failure behaviour - Invalid input or schema: the run fails with a non-zero exit before any processing. - A document that is unreadable, encrypted, legacy XLS (`UNSUPPORTED_XLS`), oversized, unsafe (ZIP path traversal, DTD/entity XML, zip bomb) or over `maxRows` is marked `FAILED` in the manifest and its rows are discarded; other documents continue. - Row errors are quarantined in `rejectedRows`. - Run outcome (`OUTPUT.outcome.status`): `SUCCEEDED` when all is clean, `PARTIAL` when any row or document was rejected, `LIMIT_REACHED` when your spending limit stopped delivery, `FAILED` when no valid row was produced. A `FAILED` run ends as a failed run after saving OUTPUT, so integrations and webhooks see the failure. Only common OOXML workbooks are supported. Formulas are never evaluated (cached values are used), macros and external links are ignored, and formatting-based date detection covers Excel built-in and common custom date formats. Logs contain document IDs, counts and error codes, never cell values. # Actor input Schema ## `documents` (type: `array`): 1 to 25 documents. Each has id and source (base64, csv, json, records, apifyKeyValueStore) plus the matching content field (base64+fileName, csv, json, records, keyValueStoreId+recordKey). ## `rowSchema` (type: `object`): JSON Schema for one output row. Supported keywords: type, required, properties, additionalProperties (boolean), enum, const, minimum, maximum, exclusiveMinimum, exclusiveMaximum, minLength, maxLength, pattern, minItems, maxItems, format (date, date-time). Others are rejected. ## `headerAliases` (type: `object`): Map of canonical property name to accepted source header aliases. ## `sheetNames` (type: `array`): Worksheets to process (XLSX only). Omit for all visible sheets. ## `headerRow` (type: `integer`): 1-based row number holding the headers. ## `coercionMode` (type: `string`): strict converts only unambiguous canonical forms; permissive also trims, strips thousands separators and currency signs, and accepts yes/no. ## `dateOutput` (type: `string`): How Excel date cells are emitted: ISO date, ISO date-time or the raw Excel serial number. ## `emptyCellMode` (type: `string`): How empty cells are emitted: omit the key, set it to null, or set it to an empty string. ## `includeRejectedValues` (type: `boolean`): Include row content and offending values in rejected rows. ## `maxRows` (type: `integer`): Maximum processed data rows per run (1 to 500000). ## `numberFormat` (type: `string`): Used by permissive coercion for numbers stored as text. In auto mode a value like 1.234 that could mean 1234 or 1.234 is rejected instead of guessed. ## Actor input object example ```json { "documents": [ { "id": "orders-september", "source": "base64", "fileName": "orders-september.xlsx", "base64": "UEsDBBQAAAAIAO+sO11DcEUeFAEAAC8DAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbK1SS08CMRD+K02vhBY8GGNYOPg4qon4A8Z2lm3oK50B4d9bFjTGoFz2NGm/ZyYzW+yCF1ss5FJs5FRNpMBoknVx1ci35eP4RgpiiBZ8itjIPZJczGfLfUYSVRupkR1zvtWaTIcBSKWMsSJtKgG4PstKZzBrWKG+mkyutUmRMfKYDx5yPrvHFjaexcOufh97FPQkxd2ReMhqJOTsnQGuuN5G+ytlfEpQVdlzqHOZRpUg9dmEA/J3wEn3XBdTnEXxAoWfIFSW3nn9kcr6PaW1+t/kTMvUts6gTWYTqkRRLgiWOkQOXvVTBXBxdDm/J5Pux3TgIt/+F3oQ7z3S0FvoTS8ld1DQvnKpZzp4gZ/eXz10f/DzT1BLAwQUAAAACADvrDtdmNrri64AAAAnAQAACwAAAF9yZWxzLy5yZWxzjc/BDoIwDAbgV1l6l4EHYwyDizHhavAB5lYGAdZlmwpv745iPHhs+vf707Je5ok90YeBrIAiy4GhVaQHawTc2svuCCxEabWcyKKAFQPUVXnFScZ0EvrBBZYMGwT0MboT50H1OMuQkUObNh35WcY0esOdVKM0yPd5fuD+04CtyRotwDe6ANauDv+xqesGhWdSjxlt/FHxlUiy9AajgGXiL/LjnWjMEgq8KvnmweoNUEsDBBQAAAAIAO+sO12pNLMUvAAAABsBAAAPAAAAeGwvd29ya2Jvb2sueG1sjY/LbsJADEV/ZeR9mcACoSgJm6oSKzblA6YZh4zI2JE9FPh7XB77rvzSvb6n2V7z5H5RNDG1sFxU4JB6jomOLRy+vz424LQEimFiwhZuqLDtmgvL6Yf55ExO2sJYylx7r/2IOeiCZyS7DCw5FBvl6HUWDFFHxJInv6qqtc8hETwdavmPBw9D6vGT+3NGKk8TwSkUC69jmhW65vFBX9VRyBZ6L9EIDeRvt4vGCU7qZI3s4hJ81/i3zL/JujtQSwMEFAAAAAgA76w7XYFikqLWAAAANAIAABoAAAB4bC9fcmVscy93b3JrYm9vay54bWwucmVsc62Rz2rDMAyHX8XovjjpYIxRt5cx6LV/HkDYShya2MbS2uXtazZWUihjh56EZPT9Pqzl+msc1Iky9zEYaKoaFAUbXR86A4f9x9MrKBYMDocYyMBEDOvVcksDSllh3ydWhRHYgBdJb1qz9TQiVzFRKC9tzCNKaXOnE9ojdqQXdf2i85wBt0y1cQbyxjWg9lOi/7Bj2/aW3qP9HCnInQh9jvnInkgKFHNHYuA6Yv1dmqpQQd+XWTxShmUayl9eTX76v+KfHxrvMZPbSS6HnlvMx78y+ubaqwtQSwMEFAAAAAgA76w7XahIIpgqAQAAhQIAAA0AAAB4bC9zdHlsZXMueG1snZLBbsMgDIZfBXFfaaJtmqYkPVSKtMsu7aRdaeKkkcAgoFWzp58JaZeepu2Ebf7/wwaKzUUrdgbnB4Mlz1ZrzgAb0w7Yl/xjXz+8cOaDxFYqg1DyETzfVIUPo4LdESAwAqAv+TEE+yqEb46gpV8ZC0g7nXFaBkpdL7x1IFsfTVqJfL1+FloOyKuiMxg8a8wJA/UwF+iQL3aWiioZF1WBUkPKt1INBzfEokjKafHkG5S6gXKeClVhZQjgsKaEzfF+tDQN0kwJM+l+UfdOjln+tDBMC517MK6lO1yOkEpROm9WRQNK7eLFfXZ30kvH8KRrHd7aktMDxGGuIfHnMGFSErFLWmIvsPm/sOzS3fh37uzxT3YmrVXj+0kfwNXTD4iDXpue+hU/P6j6BlBLAwQUAAAACADvrDtd/cYjKzsBAAA0BAAAFAAAAHhsL3NoYXJlZFN0cmluZ3MueG1slZPBTsMwEER/xfKBUxo7aQttSVLRVkggJCQoPXCzkqWxGtvB67Tw9xgOiBvbm+194xmN5WL5YTp2BI/a2ZJnqeQMbO0abfclf9nejmacYVC2UZ2zUPJPQL6sCsTAotJiydsQ+oUQWLdgFKauBxsnb84bFeLW7wX2HlSDLUAwncilvBRGactZ7QYbSp5H08Hq9wHWvwfRQlfFj8kCe1VH63gLgj8Crx59A57dbQoRqkJ8g//CGxWAhK8HDM6AJ8E35jswDR1lUmYkdOXdcIqZV+kuJQmyNJ/KREp6kJyE3iuLYNkW6tZqOJA0s3kyn9KDjEnoBtjOa0B2oUx/zV4trZY8ncxkMj2jlwkJHezBuhMtxLPRgT24vcagayRJxtl5j0mre6cxrtgTBKU7kiJP5dU0mfxJIuK/r74AUEsDBBQAAAAIAO+sO10hMruRJQEAAMcDAAAYAAAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1sdZNRboQgFEW3YvjvoKjMTKNOWk1X0C6AKB1NFQwQp9196bQhjxf7B5x3wwk3VJfPZU42aeykVU2yQ0oSqXo9TOpak7fXl4cTSawTahCzVrImX9KSS1PdtPmwo5Qu8XllazI6tz5SavtRLsIe9CqVJ+/aLML5rblSuxophntomSlLU04XMSnSVPezTjjRVEbfEuM9/Gn/s3jKSOJqYv1+a9KKbk1F+z/2DFkWsxYyFrMOsjww6u8OAiwIMDBcIAHP7K+sZ5xxjiRgtkQSkPF9iTxI5GD4iCRyJHFCEjCLWAfZeV+iCBIFfG7cRYEszsgiCqOyugiyfY8yeJRwOkceEUR9tRHEhUTwn0Z4kOBwGlfC48c4Isk2CuNOIohLoeCv0PAJm29QSwECFAAUAAAACADvrDtdQ3BFHhQBAAAvAwAAEwAAAAAAAAAAAAAAgAEAAAAAW0NvbnRlbnRfVHlwZXNdLnhtbFBLAQIUABQAAAAIAO+sO12Y2uuLrgAAACcBAAALAAAAAAAAAAAAAACAAUUBAABfcmVscy8ucmVsc1BLAQIUABQAAAAIAO+sO12pNLMUvAAAABsBAAAPAAAAAAAAAAAAAACAARwCAAB4bC93b3JrYm9vay54bWxQSwECFAAUAAAACADvrDtdgWKSotYAAAA0AgAAGgAAAAAAAAAAAAAAgAEFAwAAeGwvX3JlbHMvd29ya2Jvb2sueG1sLnJlbHNQSwECFAAUAAAACADvrDtdqEgimCoBAACFAgAADQAAAAAAAAAAAAAAgAETBAAAeGwvc3R5bGVzLnhtbFBLAQIUABQAAAAIAO+sO139xiMrOwEAADQEAAAUAAAAAAAAAAAAAACAAWgFAAB4bC9zaGFyZWRTdHJpbmdzLnhtbFBLAQIUABQAAAAIAO+sO10hMruRJQEAAMcDAAAYAAAAAAAAAAAAAACAAdUGAAB4bC93b3Jrc2hlZXRzL3NoZWV0MS54bWxQSwUGAAAAAAcABwDCAQAAMAgAAAAA" } ], "rowSchema": { "type": "object", "additionalProperties": false, "required": [ "orderId", "orderDate", "amount" ], "properties": { "orderId": { "type": "string", "minLength": 1 }, "orderDate": { "type": "string", "format": "date" }, "customer": { "type": "string" }, "amount": { "type": "number", "minimum": 0 } } }, "headerAliases": { "orderId": [ "Order ID", "Order Number" ], "orderDate": [ "Order Date", "Date" ], "amount": [ "Amount", "Total" ] }, "headerRow": 1, "coercionMode": "strict", "dateOutput": "isoDate", "emptyCellMode": "omit", "includeRejectedValues": true, "maxRows": 100000, "numberFormat": "auto" } ``` # Actor output Schema ## `results` (type: `string`): Every result row stored in the default dataset. ## `summary` (type: `string`): Summary written to the OUTPUT record. # API You can run this Actor programmatically using our API. Below are code examples in JavaScript, Python, and CLI, as well as the OpenAPI specification and MCP server setup. ## JavaScript example ```javascript import { ApifyClient } from 'apify-client'; // Initialize the ApifyClient with your Apify API token // Replace the '' with your token const client = new ApifyClient({ token: '', }); // Prepare Actor input const input = { "documents": [ { "id": "orders-september", "source": "base64", "fileName": "orders-september.xlsx", "base64": "UEsDBBQAAAAIAO+sO11DcEUeFAEAAC8DAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbK1SS08CMRD+K02vhBY8GGNYOPg4qon4A8Z2lm3oK50B4d9bFjTGoFz2NGm/ZyYzW+yCF1ss5FJs5FRNpMBoknVx1ci35eP4RgpiiBZ8itjIPZJczGfLfUYSVRupkR1zvtWaTIcBSKWMsSJtKgG4PstKZzBrWKG+mkyutUmRMfKYDx5yPrvHFjaexcOufh97FPQkxd2ReMhqJOTsnQGuuN5G+ytlfEpQVdlzqHOZRpUg9dmEA/J3wEn3XBdTnEXxAoWfIFSW3nn9kcr6PaW1+t/kTMvUts6gTWYTqkRRLgiWOkQOXvVTBXBxdDm/J5Pux3TgIt/+F3oQ7z3S0FvoTS8ld1DQvnKpZzp4gZ/eXz10f/DzT1BLAwQUAAAACADvrDtdmNrri64AAAAnAQAACwAAAF9yZWxzLy5yZWxzjc/BDoIwDAbgV1l6l4EHYwyDizHhavAB5lYGAdZlmwpv745iPHhs+vf707Je5ok90YeBrIAiy4GhVaQHawTc2svuCCxEabWcyKKAFQPUVXnFScZ0EvrBBZYMGwT0MboT50H1OMuQkUObNh35WcY0esOdVKM0yPd5fuD+04CtyRotwDe6ANauDv+xqesGhWdSjxlt/FHxlUiy9AajgGXiL/LjnWjMEgq8KvnmweoNUEsDBBQAAAAIAO+sO12pNLMUvAAAABsBAAAPAAAAeGwvd29ya2Jvb2sueG1sjY/LbsJADEV/ZeR9mcACoSgJm6oSKzblA6YZh4zI2JE9FPh7XB77rvzSvb6n2V7z5H5RNDG1sFxU4JB6jomOLRy+vz424LQEimFiwhZuqLDtmgvL6Yf55ExO2sJYylx7r/2IOeiCZyS7DCw5FBvl6HUWDFFHxJInv6qqtc8hETwdavmPBw9D6vGT+3NGKk8TwSkUC69jmhW65vFBX9VRyBZ6L9EIDeRvt4vGCU7qZI3s4hJ81/i3zL/JujtQSwMEFAAAAAgA76w7XYFikqLWAAAANAIAABoAAAB4bC9fcmVscy93b3JrYm9vay54bWwucmVsc62Rz2rDMAyHX8XovjjpYIxRt5cx6LV/HkDYShya2MbS2uXtazZWUihjh56EZPT9Pqzl+msc1Iky9zEYaKoaFAUbXR86A4f9x9MrKBYMDocYyMBEDOvVcksDSllh3ydWhRHYgBdJb1qz9TQiVzFRKC9tzCNKaXOnE9ojdqQXdf2i85wBt0y1cQbyxjWg9lOi/7Bj2/aW3qP9HCnInQh9jvnInkgKFHNHYuA6Yv1dmqpQQd+XWTxShmUayl9eTX76v+KfHxrvMZPbSS6HnlvMx78y+ubaqwtQSwMEFAAAAAgA76w7XahIIpgqAQAAhQIAAA0AAAB4bC9zdHlsZXMueG1snZLBbsMgDIZfBXFfaaJtmqYkPVSKtMsu7aRdaeKkkcAgoFWzp58JaZeepu2Ebf7/wwaKzUUrdgbnB4Mlz1ZrzgAb0w7Yl/xjXz+8cOaDxFYqg1DyETzfVIUPo4LdESAwAqAv+TEE+yqEb46gpV8ZC0g7nXFaBkpdL7x1IFsfTVqJfL1+FloOyKuiMxg8a8wJA/UwF+iQL3aWiioZF1WBUkPKt1INBzfEokjKafHkG5S6gXKeClVhZQjgsKaEzfF+tDQN0kwJM+l+UfdOjln+tDBMC517MK6lO1yOkEpROm9WRQNK7eLFfXZ30kvH8KRrHd7aktMDxGGuIfHnMGFSErFLWmIvsPm/sOzS3fh37uzxT3YmrVXj+0kfwNXTD4iDXpue+hU/P6j6BlBLAwQUAAAACADvrDtd/cYjKzsBAAA0BAAAFAAAAHhsL3NoYXJlZFN0cmluZ3MueG1slZPBTsMwEER/xfKBUxo7aQttSVLRVkggJCQoPXCzkqWxGtvB67Tw9xgOiBvbm+194xmN5WL5YTp2BI/a2ZJnqeQMbO0abfclf9nejmacYVC2UZ2zUPJPQL6sCsTAotJiydsQ+oUQWLdgFKauBxsnb84bFeLW7wX2HlSDLUAwncilvBRGactZ7QYbSp5H08Hq9wHWvwfRQlfFj8kCe1VH63gLgj8Crx59A57dbQoRqkJ8g//CGxWAhK8HDM6AJ8E35jswDR1lUmYkdOXdcIqZV+kuJQmyNJ/KREp6kJyE3iuLYNkW6tZqOJA0s3kyn9KDjEnoBtjOa0B2oUx/zV4trZY8ncxkMj2jlwkJHezBuhMtxLPRgT24vcagayRJxtl5j0mre6cxrtgTBKU7kiJP5dU0mfxJIuK/r74AUEsDBBQAAAAIAO+sO10hMruRJQEAAMcDAAAYAAAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1sdZNRboQgFEW3YvjvoKjMTKNOWk1X0C6AKB1NFQwQp9196bQhjxf7B5x3wwk3VJfPZU42aeykVU2yQ0oSqXo9TOpak7fXl4cTSawTahCzVrImX9KSS1PdtPmwo5Qu8XllazI6tz5SavtRLsIe9CqVJ+/aLML5rblSuxophntomSlLU04XMSnSVPezTjjRVEbfEuM9/Gn/s3jKSOJqYv1+a9KKbk1F+z/2DFkWsxYyFrMOsjww6u8OAiwIMDBcIAHP7K+sZ5xxjiRgtkQSkPF9iTxI5GD4iCRyJHFCEjCLWAfZeV+iCBIFfG7cRYEszsgiCqOyugiyfY8yeJRwOkceEUR9tRHEhUTwn0Z4kOBwGlfC48c4Isk2CuNOIohLoeCv0PAJm29QSwECFAAUAAAACADvrDtdQ3BFHhQBAAAvAwAAEwAAAAAAAAAAAAAAgAEAAAAAW0NvbnRlbnRfVHlwZXNdLnhtbFBLAQIUABQAAAAIAO+sO12Y2uuLrgAAACcBAAALAAAAAAAAAAAAAACAAUUBAABfcmVscy8ucmVsc1BLAQIUABQAAAAIAO+sO12pNLMUvAAAABsBAAAPAAAAAAAAAAAAAACAARwCAAB4bC93b3JrYm9vay54bWxQSwECFAAUAAAACADvrDtdgWKSotYAAAA0AgAAGgAAAAAAAAAAAAAAgAEFAwAAeGwvX3JlbHMvd29ya2Jvb2sueG1sLnJlbHNQSwECFAAUAAAACADvrDtdqEgimCoBAACFAgAADQAAAAAAAAAAAAAAgAETBAAAeGwvc3R5bGVzLnhtbFBLAQIUABQAAAAIAO+sO139xiMrOwEAADQEAAAUAAAAAAAAAAAAAACAAWgFAAB4bC9zaGFyZWRTdHJpbmdzLnhtbFBLAQIUABQAAAAIAO+sO10hMruRJQEAAMcDAAAYAAAAAAAAAAAAAACAAdUGAAB4bC93b3Jrc2hlZXRzL3NoZWV0MS54bWxQSwUGAAAAAAcABwDCAQAAMAgAAAAA" } ], "rowSchema": { "type": "object", "additionalProperties": false, "required": [ "orderId", "orderDate", "amount" ], "properties": { "orderId": { "type": "string", "minLength": 1 }, "orderDate": { "type": "string", "format": "date" }, "customer": { "type": "string" }, "amount": { "type": "number", "minimum": 0 } } }, "headerAliases": { "orderId": [ "Order ID", "Order Number" ], "orderDate": [ "Order Date", "Date" ], "amount": [ "Amount", "Total" ] }, "coercionMode": "strict", "dateOutput": "isoDate", "emptyCellMode": "omit" }; // Run the Actor and wait for it to finish const run = await client.actor("first_watch/excel-spreadsheet-to-json-conversion").call(input); // Fetch and print Actor results from the run's dataset (if any) console.log('Results from dataset'); console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`); const { items } = await client.dataset(run.defaultDatasetId).listItems(); items.forEach((item) => { console.dir(item); }); // 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs ``` ## Python example ```python from apify_client import ApifyClient # Initialize the ApifyClient with your Apify API token # Replace '' with your token. client = ApifyClient("") # Prepare the Actor input run_input = { "documents": [{ "id": "orders-september", "source": "base64", "fileName": "orders-september.xlsx", "base64": "UEsDBBQAAAAIAO+sO11DcEUeFAEAAC8DAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbK1SS08CMRD+K02vhBY8GGNYOPg4qon4A8Z2lm3oK50B4d9bFjTGoFz2NGm/ZyYzW+yCF1ss5FJs5FRNpMBoknVx1ci35eP4RgpiiBZ8itjIPZJczGfLfUYSVRupkR1zvtWaTIcBSKWMsSJtKgG4PstKZzBrWKG+mkyutUmRMfKYDx5yPrvHFjaexcOufh97FPQkxd2ReMhqJOTsnQGuuN5G+ytlfEpQVdlzqHOZRpUg9dmEA/J3wEn3XBdTnEXxAoWfIFSW3nn9kcr6PaW1+t/kTMvUts6gTWYTqkRRLgiWOkQOXvVTBXBxdDm/J5Pux3TgIt/+F3oQ7z3S0FvoTS8ld1DQvnKpZzp4gZ/eXz10f/DzT1BLAwQUAAAACADvrDtdmNrri64AAAAnAQAACwAAAF9yZWxzLy5yZWxzjc/BDoIwDAbgV1l6l4EHYwyDizHhavAB5lYGAdZlmwpv745iPHhs+vf707Je5ok90YeBrIAiy4GhVaQHawTc2svuCCxEabWcyKKAFQPUVXnFScZ0EvrBBZYMGwT0MboT50H1OMuQkUObNh35WcY0esOdVKM0yPd5fuD+04CtyRotwDe6ANauDv+xqesGhWdSjxlt/FHxlUiy9AajgGXiL/LjnWjMEgq8KvnmweoNUEsDBBQAAAAIAO+sO12pNLMUvAAAABsBAAAPAAAAeGwvd29ya2Jvb2sueG1sjY/LbsJADEV/ZeR9mcACoSgJm6oSKzblA6YZh4zI2JE9FPh7XB77rvzSvb6n2V7z5H5RNDG1sFxU4JB6jomOLRy+vz424LQEimFiwhZuqLDtmgvL6Yf55ExO2sJYylx7r/2IOeiCZyS7DCw5FBvl6HUWDFFHxJInv6qqtc8hETwdavmPBw9D6vGT+3NGKk8TwSkUC69jmhW65vFBX9VRyBZ6L9EIDeRvt4vGCU7qZI3s4hJ81/i3zL/JujtQSwMEFAAAAAgA76w7XYFikqLWAAAANAIAABoAAAB4bC9fcmVscy93b3JrYm9vay54bWwucmVsc62Rz2rDMAyHX8XovjjpYIxRt5cx6LV/HkDYShya2MbS2uXtazZWUihjh56EZPT9Pqzl+msc1Iky9zEYaKoaFAUbXR86A4f9x9MrKBYMDocYyMBEDOvVcksDSllh3ydWhRHYgBdJb1qz9TQiVzFRKC9tzCNKaXOnE9ojdqQXdf2i85wBt0y1cQbyxjWg9lOi/7Bj2/aW3qP9HCnInQh9jvnInkgKFHNHYuA6Yv1dmqpQQd+XWTxShmUayl9eTX76v+KfHxrvMZPbSS6HnlvMx78y+ubaqwtQSwMEFAAAAAgA76w7XahIIpgqAQAAhQIAAA0AAAB4bC9zdHlsZXMueG1snZLBbsMgDIZfBXFfaaJtmqYkPVSKtMsu7aRdaeKkkcAgoFWzp58JaZeepu2Ebf7/wwaKzUUrdgbnB4Mlz1ZrzgAb0w7Yl/xjXz+8cOaDxFYqg1DyETzfVIUPo4LdESAwAqAv+TEE+yqEb46gpV8ZC0g7nXFaBkpdL7x1IFsfTVqJfL1+FloOyKuiMxg8a8wJA/UwF+iQL3aWiioZF1WBUkPKt1INBzfEokjKafHkG5S6gXKeClVhZQjgsKaEzfF+tDQN0kwJM+l+UfdOjln+tDBMC517MK6lO1yOkEpROm9WRQNK7eLFfXZ30kvH8KRrHd7aktMDxGGuIfHnMGFSErFLWmIvsPm/sOzS3fh37uzxT3YmrVXj+0kfwNXTD4iDXpue+hU/P6j6BlBLAwQUAAAACADvrDtd/cYjKzsBAAA0BAAAFAAAAHhsL3NoYXJlZFN0cmluZ3MueG1slZPBTsMwEER/xfKBUxo7aQttSVLRVkggJCQoPXCzkqWxGtvB67Tw9xgOiBvbm+194xmN5WL5YTp2BI/a2ZJnqeQMbO0abfclf9nejmacYVC2UZ2zUPJPQL6sCsTAotJiydsQ+oUQWLdgFKauBxsnb84bFeLW7wX2HlSDLUAwncilvBRGactZ7QYbSp5H08Hq9wHWvwfRQlfFj8kCe1VH63gLgj8Crx59A57dbQoRqkJ8g//CGxWAhK8HDM6AJ8E35jswDR1lUmYkdOXdcIqZV+kuJQmyNJ/KREp6kJyE3iuLYNkW6tZqOJA0s3kyn9KDjEnoBtjOa0B2oUx/zV4trZY8ncxkMj2jlwkJHezBuhMtxLPRgT24vcagayRJxtl5j0mre6cxrtgTBKU7kiJP5dU0mfxJIuK/r74AUEsDBBQAAAAIAO+sO10hMruRJQEAAMcDAAAYAAAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1sdZNRboQgFEW3YvjvoKjMTKNOWk1X0C6AKB1NFQwQp9196bQhjxf7B5x3wwk3VJfPZU42aeykVU2yQ0oSqXo9TOpak7fXl4cTSawTahCzVrImX9KSS1PdtPmwo5Qu8XllazI6tz5SavtRLsIe9CqVJ+/aLML5rblSuxophntomSlLU04XMSnSVPezTjjRVEbfEuM9/Gn/s3jKSOJqYv1+a9KKbk1F+z/2DFkWsxYyFrMOsjww6u8OAiwIMDBcIAHP7K+sZ5xxjiRgtkQSkPF9iTxI5GD4iCRyJHFCEjCLWAfZeV+iCBIFfG7cRYEszsgiCqOyugiyfY8yeJRwOkceEUR9tRHEhUTwn0Z4kOBwGlfC48c4Isk2CuNOIohLoeCv0PAJm29QSwECFAAUAAAACADvrDtdQ3BFHhQBAAAvAwAAEwAAAAAAAAAAAAAAgAEAAAAAW0NvbnRlbnRfVHlwZXNdLnhtbFBLAQIUABQAAAAIAO+sO12Y2uuLrgAAACcBAAALAAAAAAAAAAAAAACAAUUBAABfcmVscy8ucmVsc1BLAQIUABQAAAAIAO+sO12pNLMUvAAAABsBAAAPAAAAAAAAAAAAAACAARwCAAB4bC93b3JrYm9vay54bWxQSwECFAAUAAAACADvrDtdgWKSotYAAAA0AgAAGgAAAAAAAAAAAAAAgAEFAwAAeGwvX3JlbHMvd29ya2Jvb2sueG1sLnJlbHNQSwECFAAUAAAACADvrDtdqEgimCoBAACFAgAADQAAAAAAAAAAAAAAgAETBAAAeGwvc3R5bGVzLnhtbFBLAQIUABQAAAAIAO+sO139xiMrOwEAADQEAAAUAAAAAAAAAAAAAACAAWgFAAB4bC9zaGFyZWRTdHJpbmdzLnhtbFBLAQIUABQAAAAIAO+sO10hMruRJQEAAMcDAAAYAAAAAAAAAAAAAACAAdUGAAB4bC93b3Jrc2hlZXRzL3NoZWV0MS54bWxQSwUGAAAAAAcABwDCAQAAMAgAAAAA", }], "rowSchema": { "type": "object", "additionalProperties": False, "required": [ "orderId", "orderDate", "amount", ], "properties": { "orderId": { "type": "string", "minLength": 1, }, "orderDate": { "type": "string", "format": "date", }, "customer": { "type": "string" }, "amount": { "type": "number", "minimum": 0, }, }, }, "headerAliases": { "orderId": [ "Order ID", "Order Number", ], "orderDate": [ "Order Date", "Date", ], "amount": [ "Amount", "Total", ], }, "coercionMode": "strict", "dateOutput": "isoDate", "emptyCellMode": "omit", } # Run the Actor and wait for it to finish run = client.actor("first_watch/excel-spreadsheet-to-json-conversion").call(run_input=run_input) # Fetch and print Actor results from the run's dataset (if there are any) print(f"💾 Check your data here: https://console.apify.com/storage/datasets/{run.default_dataset_id}") for item in client.dataset(run.default_dataset_id).iterate_items(): print(item) # 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start ``` ## CLI example ```bash echo '{ "documents": [ { "id": "orders-september", "source": "base64", "fileName": "orders-september.xlsx", "base64": "UEsDBBQAAAAIAO+sO11DcEUeFAEAAC8DAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbK1SS08CMRD+K02vhBY8GGNYOPg4qon4A8Z2lm3oK50B4d9bFjTGoFz2NGm/ZyYzW+yCF1ss5FJs5FRNpMBoknVx1ci35eP4RgpiiBZ8itjIPZJczGfLfUYSVRupkR1zvtWaTIcBSKWMsSJtKgG4PstKZzBrWKG+mkyutUmRMfKYDx5yPrvHFjaexcOufh97FPQkxd2ReMhqJOTsnQGuuN5G+ytlfEpQVdlzqHOZRpUg9dmEA/J3wEn3XBdTnEXxAoWfIFSW3nn9kcr6PaW1+t/kTMvUts6gTWYTqkRRLgiWOkQOXvVTBXBxdDm/J5Pux3TgIt/+F3oQ7z3S0FvoTS8ld1DQvnKpZzp4gZ/eXz10f/DzT1BLAwQUAAAACADvrDtdmNrri64AAAAnAQAACwAAAF9yZWxzLy5yZWxzjc/BDoIwDAbgV1l6l4EHYwyDizHhavAB5lYGAdZlmwpv745iPHhs+vf707Je5ok90YeBrIAiy4GhVaQHawTc2svuCCxEabWcyKKAFQPUVXnFScZ0EvrBBZYMGwT0MboT50H1OMuQkUObNh35WcY0esOdVKM0yPd5fuD+04CtyRotwDe6ANauDv+xqesGhWdSjxlt/FHxlUiy9AajgGXiL/LjnWjMEgq8KvnmweoNUEsDBBQAAAAIAO+sO12pNLMUvAAAABsBAAAPAAAAeGwvd29ya2Jvb2sueG1sjY/LbsJADEV/ZeR9mcACoSgJm6oSKzblA6YZh4zI2JE9FPh7XB77rvzSvb6n2V7z5H5RNDG1sFxU4JB6jomOLRy+vz424LQEimFiwhZuqLDtmgvL6Yf55ExO2sJYylx7r/2IOeiCZyS7DCw5FBvl6HUWDFFHxJInv6qqtc8hETwdavmPBw9D6vGT+3NGKk8TwSkUC69jmhW65vFBX9VRyBZ6L9EIDeRvt4vGCU7qZI3s4hJ81/i3zL/JujtQSwMEFAAAAAgA76w7XYFikqLWAAAANAIAABoAAAB4bC9fcmVscy93b3JrYm9vay54bWwucmVsc62Rz2rDMAyHX8XovjjpYIxRt5cx6LV/HkDYShya2MbS2uXtazZWUihjh56EZPT9Pqzl+msc1Iky9zEYaKoaFAUbXR86A4f9x9MrKBYMDocYyMBEDOvVcksDSllh3ydWhRHYgBdJb1qz9TQiVzFRKC9tzCNKaXOnE9ojdqQXdf2i85wBt0y1cQbyxjWg9lOi/7Bj2/aW3qP9HCnInQh9jvnInkgKFHNHYuA6Yv1dmqpQQd+XWTxShmUayl9eTX76v+KfHxrvMZPbSS6HnlvMx78y+ubaqwtQSwMEFAAAAAgA76w7XahIIpgqAQAAhQIAAA0AAAB4bC9zdHlsZXMueG1snZLBbsMgDIZfBXFfaaJtmqYkPVSKtMsu7aRdaeKkkcAgoFWzp58JaZeepu2Ebf7/wwaKzUUrdgbnB4Mlz1ZrzgAb0w7Yl/xjXz+8cOaDxFYqg1DyETzfVIUPo4LdESAwAqAv+TEE+yqEb46gpV8ZC0g7nXFaBkpdL7x1IFsfTVqJfL1+FloOyKuiMxg8a8wJA/UwF+iQL3aWiioZF1WBUkPKt1INBzfEokjKafHkG5S6gXKeClVhZQjgsKaEzfF+tDQN0kwJM+l+UfdOjln+tDBMC517MK6lO1yOkEpROm9WRQNK7eLFfXZ30kvH8KRrHd7aktMDxGGuIfHnMGFSErFLWmIvsPm/sOzS3fh37uzxT3YmrVXj+0kfwNXTD4iDXpue+hU/P6j6BlBLAwQUAAAACADvrDtd/cYjKzsBAAA0BAAAFAAAAHhsL3NoYXJlZFN0cmluZ3MueG1slZPBTsMwEER/xfKBUxo7aQttSVLRVkggJCQoPXCzkqWxGtvB67Tw9xgOiBvbm+194xmN5WL5YTp2BI/a2ZJnqeQMbO0abfclf9nejmacYVC2UZ2zUPJPQL6sCsTAotJiydsQ+oUQWLdgFKauBxsnb84bFeLW7wX2HlSDLUAwncilvBRGactZ7QYbSp5H08Hq9wHWvwfRQlfFj8kCe1VH63gLgj8Crx59A57dbQoRqkJ8g//CGxWAhK8HDM6AJ8E35jswDR1lUmYkdOXdcIqZV+kuJQmyNJ/KREp6kJyE3iuLYNkW6tZqOJA0s3kyn9KDjEnoBtjOa0B2oUx/zV4trZY8ncxkMj2jlwkJHezBuhMtxLPRgT24vcagayRJxtl5j0mre6cxrtgTBKU7kiJP5dU0mfxJIuK/r74AUEsDBBQAAAAIAO+sO10hMruRJQEAAMcDAAAYAAAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1sdZNRboQgFEW3YvjvoKjMTKNOWk1X0C6AKB1NFQwQp9196bQhjxf7B5x3wwk3VJfPZU42aeykVU2yQ0oSqXo9TOpak7fXl4cTSawTahCzVrImX9KSS1PdtPmwo5Qu8XllazI6tz5SavtRLsIe9CqVJ+/aLML5rblSuxophntomSlLU04XMSnSVPezTjjRVEbfEuM9/Gn/s3jKSOJqYv1+a9KKbk1F+z/2DFkWsxYyFrMOsjww6u8OAiwIMDBcIAHP7K+sZ5xxjiRgtkQSkPF9iTxI5GD4iCRyJHFCEjCLWAfZeV+iCBIFfG7cRYEszsgiCqOyugiyfY8yeJRwOkceEUR9tRHEhUTwn0Z4kOBwGlfC48c4Isk2CuNOIohLoeCv0PAJm29QSwECFAAUAAAACADvrDtdQ3BFHhQBAAAvAwAAEwAAAAAAAAAAAAAAgAEAAAAAW0NvbnRlbnRfVHlwZXNdLnhtbFBLAQIUABQAAAAIAO+sO12Y2uuLrgAAACcBAAALAAAAAAAAAAAAAACAAUUBAABfcmVscy8ucmVsc1BLAQIUABQAAAAIAO+sO12pNLMUvAAAABsBAAAPAAAAAAAAAAAAAACAARwCAAB4bC93b3JrYm9vay54bWxQSwECFAAUAAAACADvrDtdgWKSotYAAAA0AgAAGgAAAAAAAAAAAAAAgAEFAwAAeGwvX3JlbHMvd29ya2Jvb2sueG1sLnJlbHNQSwECFAAUAAAACADvrDtdqEgimCoBAACFAgAADQAAAAAAAAAAAAAAgAETBAAAeGwvc3R5bGVzLnhtbFBLAQIUABQAAAAIAO+sO139xiMrOwEAADQEAAAUAAAAAAAAAAAAAACAAWgFAAB4bC9zaGFyZWRTdHJpbmdzLnhtbFBLAQIUABQAAAAIAO+sO10hMruRJQEAAMcDAAAYAAAAAAAAAAAAAACAAdUGAAB4bC93b3Jrc2hlZXRzL3NoZWV0MS54bWxQSwUGAAAAAAcABwDCAQAAMAgAAAAA" } ], "rowSchema": { "type": "object", "additionalProperties": false, "required": [ "orderId", "orderDate", "amount" ], "properties": { "orderId": { "type": "string", "minLength": 1 }, "orderDate": { "type": "string", "format": "date" }, "customer": { "type": "string" }, "amount": { "type": "number", "minimum": 0 } } }, "headerAliases": { "orderId": [ "Order ID", "Order Number" ], "orderDate": [ "Order Date", "Date" ], "amount": [ "Amount", "Total" ] }, "coercionMode": "strict", "dateOutput": "isoDate", "emptyCellMode": "omit" }' | apify call first_watch/excel-spreadsheet-to-json-conversion --silent --output-dataset ``` ## MCP server setup ```json { "mcpServers": { "apify": { "type": "http", "url": "https://mcp.apify.com/?tools=fetch-actor-details,first_watch/excel-spreadsheet-to-json-conversion" } } } ``` The hosted server signs you in with OAuth on first connect, so no API token belongs in this config. Clients without OAuth support can send an `Authorization: Bearer ` header instead, using a token from API & Integrations in Apify Console (https://console.apify.com/settings/integrations). ## OpenAPI specification Download the OpenAPI definition: https://api.apify.com/v2/actors/tUMEGFpOiju0jAyKG/builds/e6jl5vOUZWocnqKPe/openapi.json