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

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

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

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

-H "Authorization: Bearer {access_token}"

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.

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

The file can be downloaded directly from the FileUrl or saved to the location specified by outPath.

400 Bad Request – Invalid Aspose.Cells Cloud API URI. Check the endpoint and required parameters.
401 Unauthorized – Invalid access token or client credentials. Refresh your OAuth token and ensure the Authorization header is correct.
404 Not Found – The specified spreadsheet file is not accessible. Verify the file path or upload the file again.
500 Server Error – An internal error occurred while processing the spreadsheet. Retry the request; if the problem persists, contact support with the request ID.

Where should we use the Merge Spreadsheet API?

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.

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.

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.

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.

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

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.