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

Web 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.

-H "Authorization: Bearer {access_token}"

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"
    }
  }
]

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 is not accessible.
  • 500 Server Error: The spreadsheet has encountered an anomaly while obtaining calculation data.

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.

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