How to Convert Local Spreadsheet Range Data to a JSON File: Step-by-Step Guide

Export range data from a local Excel file to a JSON file using the Cloud API.

Convert Range to JSON API

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

Security and Authentication

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

Request Parameters:

Parameter Name Type Path/Query String/HTTP Body Description
Spreadsheet File FormData Upload the spreadsheet file.
worksheet String Query Name of the worksheet in the spreadsheet.
range String Query Cell area to convert, e.g., A1:C10.
outPath String Query (Optional) Folder path where the workbook is stored; default is null.
outStorageName String Query Name of the output file storage.
fontsLocation String Query Location for storing custom fonts for home use.
region String Query The spreadsheet region setting.
password String Query Password for opening the spreadsheet file.

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 Range to JSON API?

  • Real‑time dashboards: Convert live Excel data to JSON for charting libraries such as Chart.js or D3.js.
  • Spreadsheet‑as‑a‑service: Expose Excel ranges as JSON endpoints for other services.
  • Webhook payloads: Transform spreadsheet data to 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 from business‑maintained spreadsheets.
  • E‑commerce operations: Sync product catalogs or pricing sheets to websites via JSON.
  • Reporting automation: Generate JSON data feeds from financial models for automated reporting.
  • Application 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.

For other conversion options, see the Convert Range to CSV guide.

Why should you use the Convert Range to JSON API?

  • SDK support: Aspose.Cells Cloud provides libraries for multiple languages, reducing the amount of custom code needed.
  • Reduced storage costs: The range can be converted without first uploading the entire workbook, saving storage space.
  • Compatibility with web and mobile apps: JSON is the native data format for modern JavaScript frameworks such as React, Vue, and Angular.
  • Broad language support: Virtually every programming language and database can consume JSON.
  • Structured data preservation
    • Intelligent structure detection: Automatically converts tabular data to proper JSON arrays or objects.
    • Header mapping: Uses the first row as JSON keys for clean object structures.
    • Data type retention: Preserves number, date, and boolean types instead of plain text.

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

Convert Range to JSON API Specification

The Convert Range to JSON API Specification defines a publicly accessible programming interface and allows you to carry out 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.

Use Aspose.Cells Cloud SDKs

Using the SDK is the fastest way to develop, as it abstracts away low‑level details, allowing you to convert a range of data to a JSON file with concise code.
Please check out the GitHub repository for a complete list of Aspose.Cells Cloud SDKs.

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

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