How to Convert the Local Spreadsheet data of Range to a JSON file: Step-by-Step Guide

Export data of range from a local Excel Files to a JSON file using Cloud API

Convert Range to JSON API

API Endpoint

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

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

Error Codes

  • 400 Bad Request: Invalid Aspose.Cells Cloud API URI.
  • 401 Unauthorized: Invalid access token. Or invalid client id and secret.
  • 404 Not Found: The spreadsheet file not accessible.
  • 500 Server Error: The spreadsheet has encountered an anomaly in obtaining calculation data.

Where Should You Use the Convert Range to JSON API?

  • Real-time Dashboards: Convert live Excel data to JSON for real-time charting libraries (Chart.js, D3.js).
  • Spreadsheet-as-Service: Excel ranges as JSON endpoints for other microservices to consume.
  • Webhook Payloads: Convert spreadsheet data to JSON for webhook notifications.
  • Rapid Data Prototyping: Quick conversion of cleaned Excel data to JSON for Python/R analysis.
  • Machine Learning Pipelines: Preprocess training data from business-maintained spreadsheets.
  • E-commerce Operations: Transform product catalogs or pricing sheets to JSON for website sync.
  • Reporting Automation: Generate JSON data feeds from financial models for automated reportin.
  • 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: Manage website navigation structures in Excel, deploy as JSON

Why should you use the Convert Range to JSON API?

  • Developer-Friendly: Aspose.Cells Cloud offers SDK libraries in multiple languages, enabling quick development and comes with comprehensive documentation. Compared to building custom chart rendering solutions, this significantly reduces the development workload.
  • Cost-Effective: You can convert range data without first uploading the workbook, which saves storage space and reduces costs.
  • To Fuel Modern Web & Mobile Applications: JSON is the native data language of the web. By converting Excel ranges to JSON, you can seamlessly feed live spreadsheet data into JavaScript frameworks (React, Vue, Angular), mobile apps, or single-page applications (SPAs) without complex parsing logic.
  • JSON is the lingua franca of modern systems: compatible with virtually every programming language, database, and web service. Unlike proprietary formats, JSON ensures your Excel data can be consumed anywhere.
  • Structured Data Preservation
    • Intelligent Structure Detection: Automatically converts tabular data to proper JSON arrays/objects
    • Header Mapping: Uses first row as JSON keys for clean object structures
    • Data Type Retention: Preserves number, date, and boolean types (not just 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.

Use Aspose.Cells Cloud SDKs

Using the SDK is the fastest way to develop, as it abstracts away the low-level details, allowing you to convert a data of range to a json file with short 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:

Aspose.Cells Cloud Web API - Convert Local Excel Range to a CSV file - Free Online Tool