How to Convert Local Spreadsheet Table Data to a JSON File: Step‑by‑Step Guide

Convert a local spreadsheet/Excel table to a JSON file with the Aspose.Cells Cloud Web API.

Convert Table to JSON API

Web API

PUT https://api.aspose.cloud/v4.0/cells/convert/table/json

Security and Authentication

The Aspose.Cells Cloud APIs are secure and require JWT token-based authentication.

Request Parameters

Parameter Name	Type	Location	Description
Spreadsheet	File	FormData	The Excel file to be uploaded.
worksheet	String	Query	Name of the worksheet that contains the table.
tableName	String	Query	Name of the table to convert.
outPath	String	Query	(Optional) The folder path where the resulting JSON file will be stored; defaults to null.
outStorageName	String	Query	(Optional) Name of the storage where the output file will be placed.
fontsLocation	String	Query	(Optional) Path to custom fonts used during conversion.
region	String	Query	(Optional) Regional settings for the workbook.
password	String	Query	(Optional) Password to open a protected workbook.

Response

[
  {
    "Name": "ResponseFile",
    "DataType": {
      "Identifier": "File",
      "Reference": "Stream"
    }
  }
]

HTTP Status Codes

Code	Meaning	Description
200	OK	Filter applied successfully; response contains operation details.
400	Bad Request	Missing or invalid parameters (e.g., unsupported file type).
401	Unauthorized	Invalid or missing JWT token.
413	Payload Too Large	Uploaded file exceeds size limit.
500	Internal Server Error	Unexpected server error.

Where Should You Use the Convert Table to JSON API?

Real‑time Dashboards – Convert live Excel data to JSON for charting libraries such as Chart.js or D3.js.
Spreadsheet‑as‑Service – Expose Excel tables as JSON endpoints for other micro‑services.
Webhook Payloads – Transform spreadsheet data into JSON for webhook notifications.
Rapid Data Prototyping – Quickly convert cleaned Excel data to JSON for Python or R analysis.
Machine‑Learning Pipelines – Pre‑process training data stored in business spreadsheets.
E‑commerce Operations – Sync product catalogs or pricing sheets to websites via JSON.
Reporting Automation – Generate JSON feeds from financial models for automated reporting.
App Configuration – Manage feature flags, settings, or A/B‑test parameters in Excel → JSON.
Multi‑language Support – Convert localization spreadsheets to JSON for i18n libraries.
Dynamic Menus/Navigation – Store website navigation structures in Excel and deploy them as JSON.

Why Should You Use the Convert Table to JSON API?

Developer‑Friendly – Aspose.Cells Cloud provides SDKs for many languages, reducing development effort and offering comprehensive documentation.
Cost‑Effective – Convert table data without first uploading the workbook, saving storage space and reducing costs.
Modern Web & Mobile Compatibility – JSON is the native data language of the web; the API lets you feed live spreadsheet data directly into React, Vue, Angular, mobile apps, or single‑page applications without complex parsing.
Broad Language Support – JSON works with virtually every programming language, database, and web service.
Structured Data Preservation
- Intelligent Structure Detection – Automatically converts tabular data to proper JSON arrays/objects.
- Header Mapping – Uses the first row as JSON keys for clean object structures.
- Data Type Retention – Preserves numbers, dates, and booleans (not just text).

Version History: The Convert Table to JSON endpoint was introduced with API version v4.0 (2024) and remains the current stable release. Earlier v3.x endpoints are deprecated.

How to Use the Convert Table to JSON API with SDKs?

Convert Table to JSON API Specification

The Convert Table to JSON API Specification{:target="_blank" rel=“noopener noreferrer”} provides a publicly accessible programming interface, enabling REST interactions directly from a web browser.

You can use the cURL command‑line tool to access Aspose.Cells web services easily. The following example shows how to make calls to the Cloud API with cURL.

Request

curl -X PUT "https://api.aspose.cloud/v4.0/cells/convert/table/json?worksheet=Sheet1&tableName=Table1" \
  -H "Authorization: Bearer {access_token}" \
  -F "Spreadsheet=@myWorkbook.xlsx" \
  -o converted.json

curl -X PUT "https://api.aspose.cloud/v4.0/cells/convert/table/json?worksheet=Sheet1&tableName=MyTable" \
     -H "Authorization: Bearer {access_token}" \
     -F "Spreadsheet=@/path/to/your/file.xlsx" \
     -F "outPath=output/folder" \
     -F "outStorageName=MyStorage"

Response

{
  "type": "FileContentResult",
  "fileContents": "byte[] (Base64 encoded)",
  "contentType": "MIME type",
  "fileDownloadName": "optional file name"
}

{
 "Code": 200,
 "Status": "OK"
}

Use Aspose.Cells Cloud SDKs

Using an SDK abstracts low‑level details, allowing you to convert a spreadsheet table to a JSON file with minimal code. See the official GitHub repository for a complete list of Aspose.Cells Cloud SDKs.

The following code examples demonstrate how to interact with Aspose.Cells web services using various SDKs:

Convert Excel Range to CSV – Aspose.Cells Cloud API Convert Table to PDF