How to Convert a Spreadsheet Table data to a CSV file: Step-by-Step Guide
Contents
[
Hide
]
Export data of table from a local Excel Files to a CSV file using Cloud API.
Convert Table to CSV API
API Endpoint
PUT http://api.aspose.cloud/v4.0/cells/convert/table/csv
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 output file storage. |
| fontsLocation | String | Query | Path for using custom fonts. |
| region | String | Query | Defines the spreadsheet region setting. |
| password | String | Query | Password for opening the spreadsheet file. |
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 invalid client id and secret.
- 404 Not Found: The spreadsheet file not accessible.
- 500 Server Error: The spreadsheet has encountered an anomaly in obtaining calculation data.
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 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 to building custom chart rendering solutions, this significantly reduces the 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.
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 convert a spreadsheet table data to a CSV file with short 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: