How to Convert Spreadsheet Table Data to a CSV File: Step‑By‑Step Guide
Export table data from a local Excel file to a CSV file using the Cloud API.
Convert Table to CSV API
Web API
PUT http://api.aspose.cloud/v4.0/cells/convert/table/csv
Security and Authentication
The Aspose.Cells Cloud APIs are secure and require JWT token-based authentication.
-H "Authorization: Bearer {access_token}"
Request Parameters:
| Parameter Name | Type | Path/Query String/HTTP Body | Description |
|---|---|---|---|
| Spreadsheet | File | FormData | Upload the spreadsheet file. |
| worksheet | String | Query | Name of the worksheet in the spreadsheet. |
| tableName | String | Query | Name of the table to be converted. |
| outPath | String | Query | (Optional) Folder path where the workbook is stored; defaults to null. |
| outStorageName | String | Query | Name of the storage for the output file. |
| fontsLocation | String | Query | Path for using custom fonts. |
| region | String | Query | Spreadsheet region/language setting (e.g., en-US, fr-FR). Influences number formatting, date parsing, and locale‑specific behavior. |
| password | String | Query | Password for opening the spreadsheet file. |
Response
[
{
"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 Table to CSV API?
- Database Migration: Convert Excel tables to CSV for bulk import into SQL databases (MySQL, PostgreSQL, SQL Server).
- Data Warehouse Loading: Transform Excel‑based reporting tables to CSV for loading into Snowflake, Redshift, or BigQuery.
- Batch API Payloads: Convert Excel table data to CSV for bulk API uploads to REST services.
- Service‑to‑Service Communication: Use CSV as a lightweight data‑exchange format between microservices.
- Machine Learning Data Prep: Convert feature tables from Excel to CSV for Python/R machine‑learning libraries.
- Statistical Analysis: Transform research data tables to CSV for SPSS, SAS, or Stata import.
- Content Migration: Move structured content from Excel to CMS systems via CSV.
Why should you use the Convert Table to CSV API?
- Developer‑Friendly: Aspose.Cells Cloud offers SDK libraries in multiple languages, enabling quick development and comes with comprehensive documentation. Compared with building custom solutions, this significantly reduces development workload.
- Cost‑Effective: You can convert table data without first uploading the workbook, which saves storage space and reduces costs.
- Pure data extraction without formatting.
- CSV is supported by virtually every system:
- Databases (all major RDBMS)
- Programming languages (native parsers in all)
- Business intelligence tools (Tableau, Power BI, Looker)
- Spreadsheet software (Excel, Google Sheets, LibreOffice)
- Command‑line tools (awk, sed, grep)
How to Use the Convert Table to CSV API with SDKs?
Convert Table to CSV API Specification
The Convert Table to CSV API Specification provides a publicly accessible programming interface, allowing 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 low‑level details, allowing you to convert spreadsheet table data to a CSV file with minimal code. Please check out the GitHub repository for a complete list of Aspose.Cells Cloud SDKs.
The following code examples illustrate how to make calls to Aspose.Cells web services using various SDKs: