Pricing

from $3.00 / 1,000 result returneds

Try for free

Go to Apify Store

Excel Spreadsheet To Json Conversion

Try for free

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.

Pricing

from $3.00 / 1,000 result returneds

Rating

0.0

(0)

Developer

Jordan Nabbe

Actor stats

Bookmarked

Total users

Monthly active users

3 days ago

Last modified

Categories

Automation

Developer tools

Business

You can access the Excel Spreadsheet To Json Conversion programmatically from your own applications by using the Apify API. You can also choose the language preference from below. To use the Apify API, you’ll need an Apify account and your API token, found in API & Integrations in Apify Console.

Python

JavaScript

CLI

OpenAPI

HTTP

MCP

{
  "openapi": "3.0.1",
  "info": {
    "version": "0.0",
    "x-build-id": "Y7kqtGz1Y1NoToaoT"
  },
  "servers": [
    {
      "url": "https://api.apify.com/v2"
    }
  ],
  "paths": {
    "/acts/first_watch~excel-spreadsheet-to-json-conversion/run-sync-get-dataset-items": {
      "post": {
        "operationId": "run-sync-get-dataset-items-first_watch-excel-spreadsheet-to-json-conversion",
        "x-openai-isConsequential": false,
        "summary": "Executes an Actor, waits for its completion, and returns Actor's dataset items in response.",
        "tags": [
          "Run Actor"
        ],
        "requestBody": {
          "required": true,
          "content": {
            "application/json": {
              "schema": {
                "$ref": "#/components/schemas/inputSchema"
              }
            }
          }
        },
        "parameters": [
          {
            "name": "token",
            "in": "query",
            "required": true,
            "schema": {
              "type": "string"
            },
            "description": "Enter your Apify token here"
          }
        ],
        "responses": {
          "200": {
            "description": "OK"
          }
        }
      }
    },
    "/acts/first_watch~excel-spreadsheet-to-json-conversion/runs": {
      "post": {
        "operationId": "runs-sync-first_watch-excel-spreadsheet-to-json-conversion",
        "x-openai-isConsequential": false,
        "summary": "Executes an Actor and returns information about the initiated run in response.",
        "tags": [
          "Run Actor"
        ],
        "requestBody": {
          "required": true,
          "content": {
            "application/json": {
              "schema": {
                "$ref": "#/components/schemas/inputSchema"
              }
            }
          }
        },
        "parameters": [
          {
            "name": "token",
            "in": "query",
            "required": true,
            "schema": {
              "type": "string"
            },
            "description": "Enter your Apify token here"
          }
        ],
        "responses": {
          "200": {
            "description": "OK",
            "content": {
              "application/json": {
                "schema": {
                  "$ref": "#/components/schemas/runsResponseSchema"
                }
              }
            }
          }
        }
      }
    },
    "/acts/first_watch~excel-spreadsheet-to-json-conversion/run-sync": {
      "post": {
        "operationId": "run-sync-first_watch-excel-spreadsheet-to-json-conversion",
        "x-openai-isConsequential": false,
        "summary": "Executes an Actor, waits for completion, and returns the OUTPUT from Key-value store in response.",
        "tags": [
          "Run Actor"
        ],
        "requestBody": {
          "required": true,
          "content": {
            "application/json": {
              "schema": {
                "$ref": "#/components/schemas/inputSchema"
              }
            }
          }
        },
        "parameters": [
          {
            "name": "token",
            "in": "query",
            "required": true,
            "schema": {
              "type": "string"
            },
            "description": "Enter your Apify token here"
          }
        ],
        "responses": {
          "200": {
            "description": "OK"
          }
        }
      }
    }
  },
  "components": {
    "schemas": {
      "inputSchema": {
        "type": "object",
        "required": [
          "documents",
          "rowSchema"
        ],
        "properties": {
          "documents": {
            "title": "Documents",
            "minItems": 1,
            "maxItems": 25,
            "type": "array",
            "description": "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).",
            "items": {
              "type": "object"
            }
          },
          "rowSchema": {
            "title": "Row schema",
            "type": "object",
            "description": "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": {
            "title": "Header aliases",
            "type": "object",
            "description": "Map of canonical property name to accepted source header aliases."
          },
          "sheetNames": {
            "title": "Sheet names",
            "type": "array",
            "description": "Worksheets to process (XLSX only). Omit for all visible sheets.",
            "items": {
              "type": "string"
            }
          },
          "headerRow": {
            "title": "Header row",
            "minimum": 1,
            "type": "integer",
            "description": "1-based row number holding the headers.",
            "default": 1
          },
          "coercionMode": {
            "title": "Coercion mode",
            "enum": [
              "strict",
              "permissive"
            ],
            "type": "string",
            "description": "strict converts only unambiguous canonical forms; permissive also trims, strips thousands separators and currency signs, and accepts yes/no.",
            "default": "permissive"
          },
          "dateOutput": {
            "title": "Date output",
            "enum": [
              "isoDate",
              "isoDateTime",
              "excelSerial"
            ],
            "type": "string",
            "description": "How Excel date cells are emitted: ISO date, ISO date-time or the raw Excel serial number.",
            "default": "isoDate"
          },
          "emptyCellMode": {
            "title": "Empty cell mode",
            "enum": [
              "omit",
              "null",
              "emptyString"
            ],
            "type": "string",
            "description": "How empty cells are emitted: omit the key, set it to null, or set it to an empty string.",
            "default": "omit"
          },
          "includeRejectedValues": {
            "title": "Include rejected values",
            "type": "boolean",
            "description": "Include row content and offending values in rejected rows.",
            "default": true
          },
          "maxRows": {
            "title": "Maximum rows",
            "minimum": 1,
            "maximum": 500000,
            "type": "integer",
            "description": "Maximum processed data rows per run (1 to 500000).",
            "default": 100000
          },
          "numberFormat": {
            "title": "Number notation",
            "enum": [
              "auto",
              "en",
              "eu"
            ],
            "type": "string",
            "description": "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.",
            "default": "auto"
          }
        }
      },
      "runsResponseSchema": {
        "type": "object",
        "properties": {
          "data": {
            "type": "object",
            "properties": {
              "id": {
                "type": "string"
              },
              "actId": {
                "type": "string"
              },
              "userId": {
                "type": "string"
              },
              "startedAt": {
                "type": "string",
                "format": "date-time",
                "example": "2025-01-08T00:00:00.000Z"
              },
              "finishedAt": {
                "type": "string",
                "format": "date-time",
                "example": "2025-01-08T00:00:00.000Z"
              },
              "status": {
                "type": "string",
                "example": "READY"
              },
              "meta": {
                "type": "object",
                "properties": {
                  "origin": {
                    "type": "string",
                    "example": "API"
                  },
                  "userAgent": {
                    "type": "string"
                  }
                }
              },
              "stats": {
                "type": "object",
                "properties": {
                  "inputBodyLen": {
                    "type": "integer",
                    "example": 2000
                  },
                  "rebootCount": {
                    "type": "integer",
                    "example": 0
                  },
                  "restartCount": {
                    "type": "integer",
                    "example": 0
                  },
                  "resurrectCount": {
                    "type": "integer",
                    "example": 0
                  },
                  "computeUnits": {
                    "type": "integer",
                    "example": 0
                  }
                }
              },
              "options": {
                "type": "object",
                "properties": {
                  "build": {
                    "type": "string",
                    "example": "latest"
                  },
                  "timeoutSecs": {
                    "type": "integer",
                    "example": 300
                  },
                  "memoryMbytes": {
                    "type": "integer",
                    "example": 1024
                  },
                  "diskMbytes": {
                    "type": "integer",
                    "example": 2048
                  }
                }
              },
              "buildId": {
                "type": "string"
              },
              "defaultKeyValueStoreId": {
                "type": "string"
              },
              "defaultDatasetId": {
                "type": "string"
              },
              "defaultRequestQueueId": {
                "type": "string"
              },
              "buildNumber": {
                "type": "string",
                "example": "1.0.0"
              },
              "containerUrl": {
                "type": "string"
              },
              "usage": {
                "type": "object",
                "properties": {
                  "ACTOR_COMPUTE_UNITS": {
                    "type": "integer",
                    "example": 0
                  },
                  "DATASET_READS": {
                    "type": "integer",
                    "example": 0
                  },
                  "DATASET_WRITES": {
                    "type": "integer",
                    "example": 0
                  },
                  "KEY_VALUE_STORE_READS": {
                    "type": "integer",
                    "example": 0
                  },
                  "KEY_VALUE_STORE_WRITES": {
                    "type": "integer",
                    "example": 1
                  },
                  "KEY_VALUE_STORE_LISTS": {
                    "type": "integer",
                    "example": 0
                  },
                  "REQUEST_QUEUE_READS": {
                    "type": "integer",
                    "example": 0
                  },
                  "REQUEST_QUEUE_WRITES": {
                    "type": "integer",
                    "example": 0
                  },
                  "DATA_TRANSFER_INTERNAL_GBYTES": {
                    "type": "integer",
                    "example": 0
                  },
                  "DATA_TRANSFER_EXTERNAL_GBYTES": {
                    "type": "integer",
                    "example": 0
                  },
                  "PROXY_RESIDENTIAL_TRANSFER_GBYTES": {
                    "type": "integer",
                    "example": 0
                  },
                  "PROXY_SERPS": {
                    "type": "integer",
                    "example": 0
                  },
                  "PROXY_UNBLOCKER_UNITS": {
                    "type": "integer",
                    "example": 0
                  }
                }
              },
              "usageTotalUsd": {
                "type": "number",
                "example": 0.00005
              },
              "usageUsd": {
                "type": "object",
                "properties": {
                  "ACTOR_COMPUTE_UNITS": {
                    "type": "integer",
                    "example": 0
                  },
                  "DATASET_READS": {
                    "type": "integer",
                    "example": 0
                  },
                  "DATASET_WRITES": {
                    "type": "integer",
                    "example": 0
                  },
                  "KEY_VALUE_STORE_READS": {
                    "type": "integer",
                    "example": 0
                  },
                  "KEY_VALUE_STORE_WRITES": {
                    "type": "number",
                    "example": 0.00005
                  },
                  "KEY_VALUE_STORE_LISTS": {
                    "type": "integer",
                    "example": 0
                  },
                  "REQUEST_QUEUE_READS": {
                    "type": "integer",
                    "example": 0
                  },
                  "REQUEST_QUEUE_WRITES": {
                    "type": "integer",
                    "example": 0
                  },
                  "DATA_TRANSFER_INTERNAL_GBYTES": {
                    "type": "integer",
                    "example": 0
                  },
                  "DATA_TRANSFER_EXTERNAL_GBYTES": {
                    "type": "integer",
                    "example": 0
                  },
                  "PROXY_RESIDENTIAL_TRANSFER_GBYTES": {
                    "type": "integer",
                    "example": 0
                  },
                  "PROXY_SERPS": {
                    "type": "integer",
                    "example": 0
                  },
                  "PROXY_UNBLOCKER_UNITS": {
                    "type": "integer",
                    "example": 0
                  }
                }
              }
            }
          }
        }
      }
    }
  }
}

Excel Spreadsheet To Json Conversion OpenAPI definition

OpenAPI is a standard for designing and describing RESTful APIs, allowing developers to define API structure, endpoints, and data formats in a machine-readable way. It simplifies API development, integration, and documentation.

OpenAPI is effective when used with AI agents and GPTs by standardizing how these systems interact with various APIs, for reliable integrations and efficient communication.

By defining machine-readable API specifications, OpenAPI allows AI models like GPTs to understand and use varied data sources, improving accuracy. This accelerates development, reduces errors, and provides context-aware responses, making OpenAPI a core component for AI applications.

You can download the OpenAPI definitions for Excel Spreadsheet To Json Conversion from the options below:

OpenAPI.json

If you’d like to learn more about how OpenAPI powers GPTs, read our blog post.

You can also check out our other API clients:

Excel Spreadsheet To Json Conversion API in Python

Excel Spreadsheet To Json Conversion API in JavaScript

Excel Spreadsheet To Json Conversion API through CLI

Excel Spreadsheet To Json Conversion API

Excel to JSON: XLSX, CSV & TSV files from URLs

glistening_film/spreadsheet-to-json

Convert XLSX, CSV and TSV files from URLs into clean JSON — one dataset item per spreadsheet row — with all sheets included and types preserved. $0.01 per successfully converted file, no start fee. Failed, unsupported or corrupt files are reported but never charged.

Yodesla

Excel Converter — XLSX to CSV & JSON (and back)

hipersoft/excel-converter

Convert Excel workbooks to CSV or JSON (all sheets or one), or build a styled XLSX from JSON. The spreadsheet glue for no-code and n8n automation pipelines.

hiper soft

JSON to Excel Converter - JSON to XLSX, by URL or Bulk

eliai/json-to-excel

Convert JSON to an Excel spreadsheet by URL - arrays of records become clean XLSX sheets with headers, column widths set, one sheet per key for object-of-arrays. Built for scripts, pipelines, and AI agents. $0.03 per file; failures are free.

Broke to Built

CSV to JSON Converter with Schema Inference & Validation

nibble/csv-json-schema-converter

Convert CSV files to clean, typed JSON. Auto-detects delimiter, infers a JSON Schema, and validates rows against your own schema. Ideal for APIs, data pipelines and AI agents.

Simon Fletcher

JSON To YAML Converter

zsoftware/json-to-yaml-converter

JSON to YAML Converter: This Apify Actor takes a JSON file or raw string input, transforms it into a validated YAML document, and outputs a downloadable output.yaml file. Lightweight, fast, and easy to integrate into any workflow.

Karim

Excel MCP Server

constant_quadruped/excel-mcp-server

MCP server enabling AI assistants to read, write, and manipulate Excel files. 12 tools for cells, ranges, formulas, sheet management, and JSON/CSV export. No Excel installation required — pure Python processing. Perfect for AI automation workflows and MCP-enabled applications.

Instagram Followers Export to Excel (cookieless)

monumental_world/instagram-followers-scraper---no-login

Instantly turn Instagram follower lists into a spreadsheet-ready CSV report. No coding required—perfect for precision targeting and audience segmentation without complex tech skills

Raised Pro

1.6K

1.0

(1)

Public Google Sheets to JSON Data Scraper

zinin/public-google-sheets-to-json

Convert public Google Sheets CSV tabs into JSON with preserved text, headers, row numbers, optional types and content hashes. Empty and partial tabs are free.

Tim Zinin

JSON-LD Product Parser

mahogany_songbird/json-ld-product-parser

Extract Product schema.org JSON-LD from e-commerce pages: name, brand, price, rating.

Britton Furness

TikTok Events API - Server-Side Conversions

alizarin_refrigerator-owner/tiktok-events-api---server-side-conversions

Send offline events and server-side conversions to TikTok Events API. Track purchases, signups, and custom events with automatic PII hashing for campaign attribution.