XLSX S3 Batch Processor

Batch process XLSX files in S3-compatible object storage with filtering/cleaning and upload processed outputs back

file· File resultOpen tool

Quick start

Call this tool from your code in three languages.

cURL

curl -X POST 'https://api.elysiatools.com/en/api/tools/xlsx-s3-batch-processor' \
  -H 'Content-Type: application/json' \
  -d '{"endpoint":"https://s3.amazonaws.com","region":"us-east-1","bucket":"my-data-bucket","accessKeyId":"","secretAccessKey":"","sessionToken":"","objectKeys":"input/a.xlsx\ninput/b.xlsx","sheetName":"Sheet1","headerRow":1,"filterColumn":"status","filterOperator":"equals","filterValue":"paid","outputFormat":"xlsx","csvDelimiter":",","trimWhitespace":true,"removeEmptyRows":true,"uploadBack":false,"outputPrefix":"processed/"}'

API reference

Send a POST request with your inputs as JSON. File parameters require a separate upload first.

Endpoint

HTTP

POST https://api.elysiatools.com/en/api/tools/xlsx-s3-batch-processor

Parameters

Name	Type	Required	Description
endpoint	text	No	—
region	text	No	—
bucket	text	Yes	—
accessKeyId	text	Yes	—
secretAccessKey	text	Yes	—
sessionToken	text	No	—
objectKeys	textarea	Yes	—
sheetName	text	No	—
headerRow	number	No	—
filterColumn	text	No	—
filterOperator	select	No	—
filterValue	text	No	—
outputFormat	select	No	—
csvDelimiter	text	No	—
trimWhitespace	checkbox	No	—
removeEmptyRows	checkbox	No	—
uploadBack	checkbox	No	—
outputPrefix	text	No	—

Response format

File result

JSON

{
  "filePath": "/public/processing/randomid.ext",
  "fileName": "output.ext",
  "contentType": "application/octet-stream",
  "size": 1024,
  "metadata": {
    "key": "value"
  },
  "error": "Error message (optional)",
  "message": "Notification message (optional)"
}

MCP integration

Add this tool to your Model Context Protocol server so AI agents can list and call it.

Server configuration

Add this block to your MCP client configuration:

mcp.json

{
  "mcpServers": {
    "elysiatools-xlsx-s3-batch-processor": {
      "name": "xlsx-s3-batch-processor",
      "description": "Batch process XLSX files in S3-compatible object storage with filtering/cleaning and upload processed outputs back",
      "baseUrl": "https://api.elysiatools.com/mcp/sse?toolId=xlsx-s3-batch-processor",
      "command": "",
      "args": [],
      "env": {},
      "isActive": true,
      "type": "sse"
    }
  }
}

List available tools

After connecting to the SSE endpoint, list the exposed tools:

tools/list

{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/list"
}

Call this tool

Invoke the tool by its id, passing arguments built from its parameters:

tools/call

{
  "jsonrpc": "2.0",
  "id": 2,
  "method": "tools/call",
  "params": {
    "name": "xlsx-s3-batch-processor",
    "arguments": {
  "endpoint": "https://s3.amazonaws.com",
  "region": "us-east-1",
  "bucket": "my-data-bucket",
  "accessKeyId": "",
  "secretAccessKey": "",
  "sessionToken": "",
  "objectKeys": "input/a.xlsx\ninput/b.xlsx",
  "sheetName": "Sheet1",
  "headerRow": 1,
  "filterColumn": "status",
  "filterOperator": "equals",
  "filterValue": "paid",
  "outputFormat": "xlsx",
  "csvDelimiter": ",",
  "trimWhitespace": true,
  "removeEmptyRows": true,
  "uploadBack": false,
  "outputPrefix": "processed/"
}
  }
}

Chain multiple tools in one session with a comma-separated toolId list, e.g. /mcp/sse?toolId=png-to-webp,jpg-to-webp,gif-to-webp (max 20).

Questions or issues? Contact [email protected]