Categories

← View All Tools

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

Key Facts

Category
Format Conversion
Input Types
select, text, textarea, number
Output Type
file
Sample Coverage
4
API Ready
Yes

Overview

XLSX API To Sheet allows you to fetch data directly from REST or GraphQL endpoints and convert it into a structured Excel file. It simplifies data reporting by automating API requests, handling pagination, and mapping complex JSON responses into clean, readable spreadsheet columns.

When to Use

  • •When you need to export live data from a REST or GraphQL API into an Excel format for reporting.
  • •When your API data is spread across multiple pages and requires automated fetching to consolidate into one file.
  • •When you need to extract specific nested fields from a JSON response and map them to custom column headers.

How It Works

  • •Select your API source type (REST or GraphQL) and provide the endpoint URL.
  • •Configure pagination settings if your data spans multiple pages using page, offset, or cursor strategies.
  • •Define your field mapping as a JSON object to map specific JSON paths to your desired Excel column names.
  • •Execute the request to automatically fetch, parse, and generate your downloadable XLSX file.

Use Cases

Generating weekly inventory reports by pulling live stock levels from an internal REST API.
Consolidating customer feedback data from a GraphQL endpoint into a single spreadsheet for analysis.
Automating the export of paginated transaction logs from a payment gateway API into Excel.

Examples

1. Exporting Tool Directory to Excel

Data Analyst
Background
The team maintains a list of software tools in a remote database accessed via a REST API.
Problem
Manually copying JSON data into Excel is error-prone and slow.
How to Use
Set the API URL, define the data path as 'tools', and use the field mapping to select specific attributes like ID, name, and category.
Example Config
{"id":"id","name":"name","category":"category","result_type":"resultType"}
Outcome
A clean Excel file containing all tool records, ready for team review.

2. Fetching Paginated User Logs

System Administrator
Background
System logs are stored in an API that returns 100 records per page.
Problem
Need to aggregate thousands of logs into one file without manual page-by-page requests.
How to Use
Set pagination type to 'page', define the page parameter, and set the max pages to cover the required log range.
Example Config
{"paginationType":"page","pageParam":"page","pageSize":100,"maxPages":20}
Outcome
A single, consolidated XLSX file containing all logs across 20 pages.

Try with Samples

json, xlsx, xls
Postman Collections - API Testing
Comprehensive Postman collection examples including API testing, automation scripts, environment variables, mock servers, and advanced testing patterns for REST APIs
title token api
json
XLSX Samples
Sample XLSX spreadsheets for worksheet parsing and data extraction testing
title token xlsx
xlsx, xls
OpenAPI/Swagger Samples
Comprehensive API documentation examples using OpenAPI 3.0 and Swagger specifications for RESTful services
preferred input family json
json
JWT Samples
Comprehensive JWT examples from basic token structure to advanced security implementations
preferred input family json
json

Related Hubs

Json Convert Tools
Explore 100 json tools for convert workflows and compare closely related utilities quickly.
Json Tools
Explore 43 json tools for utility workflows and compare closely related utilities quickly.
Json Generate Tools
Explore 33 json tools for generate workflows and compare closely related utilities quickly.
Json Format Tools
Explore 6 json tools for format workflows and compare closely related utilities quickly.

FAQ

Does this tool support GraphQL?

Yes, you can select GraphQL as the source type and provide your query and variables in the configuration fields.

How does the pagination feature work?

The tool supports page, offset, and cursor strategies. It automatically requests subsequent pages based on your configuration until the data is fully retrieved or the max page limit is reached.

Can I rename columns in the output file?

Yes, use the Field Mapping JSON field to map specific JSON paths from your API response to your preferred column headers.

Is there a limit to how much data I can fetch?

You can configure the 'Max Pages' setting to control the depth of the data retrieval, with a default limit of 50 pages.

What output formats are supported?

The tool generates and exports your data exclusively as an XLSX file.

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]