How to Convert a Spreadsheet to another format: Step-by-Step Guide

Convert a local spreadsheet/Excel file to another format with the Aspose.Cells Cloud Web API.

Convert Spreadsheet API

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

Security and Authentication

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

Request Parameters:

Parameter Name Type Path/Query String/HTTPBody Description
Spreadsheet File FormData Upload the spreadsheet file to be converted.
format String Query (Required) The desired output format (e.g., “XLSX”, “PDF”, “CSV”).
outPath String Query (Optional) The folder path where the converted workbook will be stored. The default is null.
outStorageName String Query Specify an output file storage name.
fontsLocation String Query Use custom fonts for the spreadsheet.
region String Query Specify the spreadsheet region setting.
password String Query The password for opening the spreadsheet file if it is protected.

Response

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

Success status

  • 200 OK – The conversion succeeded and the response body contains the converted file stream.
  • The Content-Type header reflects the MIME type of the requested output format (e.g., application/pdf for PDF).

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.

Format

Out Format Description
XLS Excel 95/5.0 - 2003 Workbook.
XLSX The Office Open XML SpreadsheetML File Format.
XLSB Excel Binary Workbook.
XLSM Excel Macro-Enabled Workbook.
XLT Excel 97 - Excel 2003 Template.
XLTX Excel Template.
XLTM Excel Macro-Enabled Template.
XLAM An Excel Macro-Enabled Add-In file that’s used to add new functions to Excel.
CSV CSV (Comma Separated Value) file.
TSV TSV (Tab-separated values) file.
TXT Delimited plain-text file.
HTML HTML format.
MHTML MHTML file.
ODS ODS (OpenDocument Spreadsheet).
SpreadsheetML Excel 2003 XML file.
Numbers The document is created by Apple’s “Numbers” application, which is part of the iWork suite for macOS and iOS.
JSON JavaScript Object Notation.
DIF Data Interchange Format.
DBF The file with a .dbf extension is a database file used by the dBASE database-management system.
PDF Adobe Portable Document Format.
XPS XML Paper Specification format.
SVG Scalable Vector Graphics format.
TIFF Tagged Image File Format.
PNG Portable Network Graphics format.
BMP Bitmap Image format.
EMF Enhanced Metafile format.
JPEG JPEG is a type of image format that is saved using lossy compression.
GIF Graphics Interchange Format.
MARKDOWN Represents a Markdown document.
SXC An XML-based format used by OpenOffice and StarOffice.
FODS This is an Open Document format stored as flat XML.
DOCX A well-known format for Microsoft Word documents that combines XML and binary files.
PPTX The PPTX format is based on the Microsoft PowerPoint Open XML presentation file format.
SqlScript Structured Query Language.
XHtml XHTML is a text-based file format with markup in XML, using a reformulation of HTML 4.0.
Epub Files with a .epub extension are an e-book format that provides a standard digital publication for publishers and consumers.
Xml XML stands for Extensible Markup Language; it is similar to HTML but uses tags to define objects.
Ots Open Document Template Sheet (OTS) file.
AZW3 AZW is a digital e-book file format developed by Amazon for Kindle devices. AZW3, also known as Kindle Format 8 (KF8).

Where should you use the Convert Spreadsheet API?

  • Legacy System Migration: Convert thousands of legacy XLS files to XLSX for modern systems.
  • Archive Standardization: Normalize various spreadsheet formats (XLS, XLSM, ODS, CSV) to a single format for archival.
  • Office Suite Interoperability: Convert Excel files to formats compatible with LibreOffice, Google Sheets, or Apple Numbers.
  • Data Source Normalization: Convert various spreadsheet formats to CSV or JSON for database ingestion.
  • Web Publishing: Convert financial models to HTML for web display.

Why should you use the Convert Spreadsheet API?

  • Developer-Friendly: Aspose.Cells Cloud offers SDK libraries in multiple languages, enabling quick development and comes with comprehensive documentation. Compared with building custom chart-rendering 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.
  • Comprehensive Format Support: Convert between 20+ spreadsheet formats.
  • Preserve Data Fidelity & Formatting.

How to Use the Convert Spreadsheet API with SDKs?

The following code examples demonstrate how to use the Convert Spreadsheet API with various SDKs.

Convert Spreadsheet API Specification

Convert Spreadsheet API Specification defines a publicly accessible programming interface, allowing you to perform 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 a spreadsheet file to another format with concise code. Please check out the GitHub repository for a complete list of Aspose.Cells Cloud SDKs.

Convert Excel Range to CSV – Aspose.Cells Cloud API Convert Table to PDF