XLSX API To Sheet

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

Load remote API data directly into a worksheet. - Supports REST and GraphQL response payloads - Auto pagination with page/offset/cursor strategies - Optional field mapping from nested JSON paths - Exports result as XLSX file

Example Results

1 examples

Export Elysia Tools API to Sheet

Fetch tool list from Elysia Tools API and map selected fields into an Excel worksheet

workbook-sales.xlsx View File

View input parameters

{ "sourceType": "rest", "url": "https://elysiatools.com/zh/api/tools", "method": "GET", "dataPath": "tools", "paginationType": "none", "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" }

API URL *

Source Type

REST Method

Headers JSON

Query Params JSON

REST Body JSON

GraphQL Query

GraphQL Variables JSON

Data Path

Pagination Type

Max Pages

Page Param

Page Start

Page Size Param

Page Size

Offset Param

Offset Start

Cursor Param

Cursor Start

Has More Path

Next Cursor Path

Total Pages Path

Field Mapping JSON

Sheet Name

Output File Name

API Documentation

Request Endpoint

POST /en/api/tools/xlsx-api-to-sheet

Request Parameters

Parameter Name	Type	Required	Description
sourceType	select	No	-
url	text	Yes	-
method	select	No	-
headers	textarea	No	-
queryParams	textarea	No	-
body	textarea	No	-
graphqlQuery	textarea	No	-
graphqlVariables	textarea	No	-
dataPath	text	No	-
paginationType	select	No	-
maxPages	number	No	-
pageParam	text	No	-
pageStart	number	No	-
pageSizeParam	text	No	-
pageSize	number	No	-
offsetParam	text	No	-
offsetStart	number	No	-
cursorParam	text	No	-
cursorStart	text	No	-
hasMorePath	text	No	-
nextCursorPath	text	No	-
totalPagesPath	text	No	-
fieldMapping	textarea	No	-
sheetName	text	No	-
outputFileName	text	No	-

Response Format

{
  "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)"
}

File: File

AI MCP Documentation

Add this tool to your MCP server configuration:

{
  "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://elysiatools.com/mcp/sse?toolId=xlsx-api-to-sheet",
      "command": "",
      "args": [],
      "env": {},
      "isActive": true,
      "type": "sse"
    }
  }
}

You can chain multiple tools, e.g.: `https://elysiatools.com/mcp/sse?toolId=png-to-webp,jpg-to-webp,gif-to-webp`, max 20 tools.

If you encounter any issues, please contact us at [email protected]

Categories