Elysia Tools Docs
EN
Language
ZHESPTRUFRDEEN
Back to site
Browse tools

Format Conversion

XLSX API To Sheet

Fetch JSON from REST or GraphQL API and write mapped records into an Excel sheet with automatic pagination

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-api-to-sheet' \
  -H 'Content-Type: application/json' \
  -d '{"sourceType":"rest","url":"https://elysiatools.com/zh/api/tools","method":"GET","headers":"{\"Authorization\":\"Bearer xxx\"}","queryParams":"{\"status\":\"active\"}","body":"{\"filters\":{\"status\":\"active\"}}","graphqlQuery":"query($page:Int,$limit:Int){ items(page:$page,limit:$limit){ id name } }","graphqlVariables":"{\"status\":\"active\"}","dataPath":"tools","paginationType":"none","maxPages":50,"pageParam":"page","pageStart":1,"pageSizeParam":"limit","pageSize":100,"offsetParam":"offset","offsetStart":0,"cursorParam":"cursor","cursorStart":"","hasMorePath":"data.pageInfo.hasNextPage","nextCursorPath":"pageInfo.endCursor","totalPagesPath":"meta.totalPages","fieldMapping":"{\n  \"id\": \"id\",\n  \"name\": \"name\",\n  \"category\": \"category\",\n  \"result_type\": \"resultType\",\n  \"featured\": \"featured\",\n  \"last_updated\": \"lastUpdated\"\n}","sheetName":"Tools API","outputFileName":"api-export"}'

© 2026 Elysia Tools. Developer documentation.

Back to siteBrowse tools

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-api-to-sheet

Parameters

NameTypeRequiredDescription
sourceTypeselectNo—
urltextYes—
methodselectNo—
headerstextareaNo—
queryParamstextareaNo—
bodytextareaNo—
graphqlQuerytextareaNo—
graphqlVariablestextareaNo—
dataPathtextNo—
paginationTypeselectNo—
maxPagesnumberNo—
pageParamtextNo—
pageStartnumberNo—
pageSizeParamtextNo—
pageSizenumberNo—
offsetParamtextNo—
offsetStartnumberNo—
cursorParamtextNo—
cursorStarttextNo—
hasMorePathtextNo—
nextCursorPathtextNo—
totalPagesPathtextNo—
fieldMappingtextareaNo—
sheetNametextNo—
outputFileNametextNo—

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-api-to-sheet": {
      "name": "xlsx-api-to-sheet",
      "description": "Fetch JSON from REST or GraphQL API and write mapped records into an Excel sheet with automatic pagination",
      "baseUrl": "https://api.elysiatools.com/mcp/sse?toolId=xlsx-api-to-sheet",
      "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-api-to-sheet",
    "arguments": {
  "sourceType": "rest",
  "url": "https://elysiatools.com/zh/api/tools",
  "method": "GET",
  "headers": "{\"Authorization\":\"Bearer xxx\"}",
  "queryParams": "{\"status\":\"active\"}",
  "body": "{\"filters\":{\"status\":\"active\"}}",
  "graphqlQuery": "query($page:Int,$limit:Int){ items(page:$page,limit:$limit){ id name } }",
  "graphqlVariables": "{\"status\":\"active\"}",
  "dataPath": "tools",
  "paginationType": "none",
  "maxPages": 50,
  "pageParam": "page",
  "pageStart": 1,
  "pageSizeParam": "limit",
  "pageSize": 100,
  "offsetParam": "offset",
  "offsetStart": 0,
  "cursorParam": "cursor",
  "cursorStart": "",
  "hasMorePath": "data.pageInfo.hasNextPage",
  "nextCursorPath": "pageInfo.endCursor",
  "totalPagesPath": "meta.totalPages",
  "fieldMapping": "{\n  \"id\": \"id\",\n  \"name\": \"name\",\n  \"category\": \"category\",\n  \"result_type\": \"resultType\",\n  \"featured\": \"featured\",\n  \"last_updated\": \"lastUpdated\"\n}",
  "sheetName": "Tools API",
  "outputFileName": "api-export"
}
  }
}
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]

Browse tools
Open tool