How to Convert a Spreadsheet to CSV Using Aspose.Cells Cloud API
The ConvertSpreadsheetToCsv endpoint reads a spreadsheet file uploaded from a local drive, processes the conversion entirely on Aspose.Cells Cloud servers, and returns the resulting CSV file as a binary stream. This cloud‑native operation eliminates the need to upload the source file to cloud storage, reduces storage costs, and simplifies the workflow for developers needing quick spreadsheet‑to‑CSV transformations. Supported formats depend on the underlying libraries, and proper permissions are required for reading the source file. Errors such as missing files, invalid requests, or conversion failures are returned with standard HTTP status codes.
Convert Spreadsheet To CSV API
PUT https://api.aspose.cloud/v4.0/cells/convert/spreadsheet/csv
Security and Authentication
The Aspose.Cells Cloud APIs are secure and require JWT token-based authentication.
Request Parameters:
| Parameter Name | Type | Location | Requirement | Description |
|---|---|---|---|---|
| Spreadsheet | File | FormData | Required | The spreadsheet file to be converted. Accepts common formats like .xls, .xlsx, .xlsm. Must be provided as multipart/form‑data. Example: myWorkbook.xlsx. |
| outPath | String | Query | Optional | Destination folder path where the converted CSV should be saved. If omitted, the CSV is returned directly in the response body. Example: /output/reports/. |
| outStorageName | String | Query | Optional | Name of the cloud storage service where the output file will be stored. When not supplied, the default storage configured for the Aspose.Cells account is used. |
| fontsLocation | String | Query | Optional | Path to a folder containing custom fonts required by the spreadsheet. Enables correct rendering of cells that use non‑standard fonts. |
| region | String | Query | Optional | Spreadsheet region/language setting (e.g., en-US, fr-FR). Influences number formatting, date parsing, and locale‑specific behavior. |
| password | String | Query | Optional | Password used to open password‑protected spreadsheets. If the file is encrypted and the password is omitted or incorrect, a 400/401 error is returned. |
Response
On success the API returns HTTP 200 (or 202 for asynchronous processing) with the header Content-Type: application/octet-stream. The response body contains the generated CSV file as a binary stream.
[
{
"Name": "ResponseFile",
"DataType": {
"Identifier": "File",
"Reference": "Stream"
}
}
]
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 You Use the Convert Spreadsheet To CSV API?
- Data Export for Reporting Systems – Generate CSV extracts from Excel‑based reports to feed BI tools or data warehouses without manual file handling.
- Automated Batch Processing – Convert large numbers of locally stored spreadsheets to CSV in a server‑side job, then stream results directly to downstream services.
- Web Applications with File Uploads – Allow end‑users to upload an Excel file and instantly receive a CSV version for further analysis or import into other platforms.
- Legacy System Integration – Translate legacy spreadsheet formats into CSV for systems that only accept plain‑text delimited files.
Why Use the Convert Spreadsheet To CSV API?
- Zero‑Upload Architecture – No need to store the source file in cloud storage; conversion happens directly from the uploaded stream, saving time and storage costs.
- High‑Performance Cloud Processing – Leverages Aspose.Cells’ optimized conversion engine on scalable cloud servers, delivering fast CSV output even for large workbooks.
- Simple Integration – Single PUT request with optional query parameters; returns the CSV as a ready‑to‑download binary stream, eliminating post‑processing steps.
- Full Feature Support – Handles password‑protected files, custom fonts, and locale‑specific settings, ensuring accurate conversion for complex spreadsheets.
How to Use the Convert Spreadsheet To CSV API with SDKs
Convert Spreadsheet To CSV API Specification
The Convert Spreadsheet To CSV API Specification provides a publicly accessible programming interface for executing REST interactions directly from a web browser.
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 the low‑level details, allowing you to work with spreadsheets using concise code. Please check out the GitHub repository for a complete list of Aspose.Cells Cloud SDKs. The following code examples demonstrate how to interact with Aspose.Cells web services using various SDKs: