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.
Web API
PUT https://api.aspose.cloud/v4.0/cells/merge/spreadsheet
Security and Authentication
The Aspose.Cells Cloud APIs are secure and require JWT token-based authentication.
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. |
Response
{
"Name": "ResponseFile",
"DataType": {
"Identifier": "File",
"Reference": "Stream"
}
}
The file can be downloaded directly from or saved to the location specified by outPath.
Success response details
| Status Code | Content‑Type | Description |
|---|---|---|
| 200 OK | application/octet-stream |
Binary stream of the merged workbook file. |
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 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.
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 import data into a spreadsheet worksheet with short code. Please check out the GitHub repository for a complete list of Aspose.Cells Cloud SDKs.