Spreadsheet Data Processing – Merge, Split & Import

Aspose.Cells Cloud – a RESTful service that enables programmatic manipulation of Excel files in the cloud. It supports importing data from various formats, merging workbooks, and splitting large spreadsheets.

The Data Processing section of Aspose.Cells Cloud API enables you to import, merge, and split spreadsheet data programmatically. Use the endpoints below to handle CSV/JSON imports, combine workbooks, or split large files into manageable pieces.

Prerequisites

• An active Aspose.Cloud account with a valid OAuth 2.0 access token.
• Required scope: Cells.ReadWrite.
• Supported storage locations: Aspose Cloud storage, Amazon S3, Azure Blob, Google Cloud Storage.
• API version: v3.0 (June 2026).

Data Import and Management

• Import CSV, JSON, XML data into Excel files

  • Supports multiple data‑format conversions,
  • Batch data‑import processing,
  • Field mapping and format preservation.

  When to use

  • Use case: Load external data sources into a workbook for further analysis.
  • Typical payload size: Up to 50 MB per request.
  • Supported file types: CSV, JSON, XML.

File Merging Operation

Basic Merging Functionality

• Merge Remote Excel Files into Specified Workbook

  • Merging across cloud‑storage files,
  • Sheet‑level merging control.

  When to use

  • Use case: Consolidate several workbooks stored in cloud storage into a single workbook.
  • Typical payload size: Up to 200 MB total source size.
  • Supported file types: XLSX, XLS, CSV.

Batch Merging Function

• Merge Multiple Excel Files into a Single Workbook

  • Intelligent merging of multiple files,
  • Automatic handling of conflicting data.

  When to use

  • Use case: Combine a collection of related reports into one comprehensive document.
  • Typical payload size: Up to 500 MB aggregated source size.
  • Supported file types: XLSX, XLS.

Folder‑level Merging

• Merge Excel files that match in a remote folder

  • Filter files by rules,
  • Batch folder operations.

  When to use

  • Use case: Merge all spreadsheets that follow a naming convention within a specific cloud folder.
  • Typical payload size: Dependent on the number of matched files (recommended ≤ 1 GB total).
  • Supported file types: XLSX, XLS.

File Splitting Operation

Worksheet Level Splitting

• Split an Excel file into multiple files based on worksheets

  • Each worksheet generates an independent file,
  • Preserves formatting and formulas.

  When to use

  • Use case: Distribute individual worksheets to different stakeholders.
  • Typical payload size: Up to 100 MB per source workbook.
  • Supported file types: XLSX, XLS.

Custom Rule Splitting

• Split Excel File According to Custom Rules

  • Split by row count, column count, content conditions,
  • Flexible rule‑based partitioning.

  When to use

  • Use case: Partition a large dataset into smaller, more manageable files for batch processing.
  • Typical payload size: Up to 200 MB per source workbook.
  • Supported file types: XLSX, XLS.