Combine Multiple Excel Files into One – Batch Merge Spreadsheets to 30+ Formats

One‑Line Summary: Merge multiple local Excel, CSV, or ODS files into a single workbook and convert it to 30+ output formats with Aspose.Cells Cloud API.

Merge Spreadsheet API

Web API

PUT https://api.aspose.cloud/v4.0/cells/merge/spreadsheet

Request Parameters

Parameter Name Type Location Description
Spreadsheet File FormData The local spreadsheet file to upload. Supports XLSX, XLS, CSV, ODS, etc.
outFormat String Query Desired output format (e.g., XLSX, PDF, CSV, HTML). Supports 30+ formats.
mergeInOneSheet Boolean Query true → all data merged into a single worksheet; false → each original sheet is preserved.
outPath String Query (optional) Cloud folder path where the merged file will be saved. If omitted, the default location is used.
outStorageName String Query Name of the cloud storage to use (default or custom).
fontsLocation String Query (optional) Cloud folder containing custom fonts for correct PDF/image rendering.
region String Query (optional) Locale for number, date, and currency formatting (e.g., en-US, zh-CN).
password String Query (optional) Password for opening a protected spreadsheet.

Parameter Glossary

outFormat
Output file format such as **XLSX**, **PDF**, **CSV**, **HTML**, etc.
mergeInOneSheet
If **true**, all worksheets are combined into a single sheet; otherwise each source sheet is retained.
fontsLocation
Path to a folder with custom font files to ensure accurate rendering in PDF or image outputs.

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 client credentials.
  • 404 Not Found – The specified spreadsheet file is not accessible.
  • 500 Server Error – An internal error occurred while processing the spreadsheet.

Where should we use the Merge Spreadsheet API?

Education and Academic Applications

  • Student Assignment Grading – Merge multiple student assignment files for unified comments and grading.
  • Research Data Collection – Consolidate data spreadsheets from different experimental groups.
  • Teaching Material Creation – Combine exercises from multiple chapters into a single question‑bank workbook.

Data Processing and Analysis

  • Small Data Set Integration – Merge CSV or Excel files exported from disparate sources.
  • Data Analysis Pre‑processing – Combine relevant data files before performing analysis.
  • Template Data Filling – Populate pre‑set report templates with merged data.

Development and Technical Support

  • Test Data Preparation – Merge several test case files for automated testing.
  • Log File Analysis – Consolidate Excel reports of system logs from different periods.
  • Configuration Management – Merge multiple configuration spreadsheets into a unified configuration file.

Why should you use the Merge Spreadsheet API?

  • Developer‑Friendly – SDK libraries are available for many languages, reducing development effort compared with building a custom solution.
  • Reduced Labor Costs – Eliminates the need for dedicated staff to perform manual document consolidation.
  • Pay‑per‑Use – Only pay for the API calls you actually make; no upfront investment.
  • Zero Maintenance Costs – No servers to maintain, no software updates, and no compatibility concerns.

How to Use the Merge Spreadsheet API with SDKs

OpenAPI Specification

The OpenAPI Specification provides a machine‑readable description of the API, enabling direct REST interactions.

Use Aspose.Cells Cloud SDKs

Using an SDK abstracts low‑level details, allowing you to merge multiple spreadsheets into a single workbook with minimal code.

Example: Merge multiple spreadsheets into a spreadsheet with short code.

Please check the GitHub repository for a complete list of Aspose.Cells Cloud SDKs.