The Spreadsheet Tools comprise of several Web APIs that can convert XLS to CSV, XLS to JSON, XLS to HTML, XLS to TXT, and XLS to XML. It can come in handy when you want to convert your Excel into a simple text file or when you need to move your Excel data to a database.
The Web API is designed to preserve the structure of the original XLS. When XLS is converted to any of the supported file formats such as HTML, the table values are placed in their correct rows and columns in the raw HTML code.
Security is important to us that is why our servers are hosted on the world-class infrastructure to keep your data safe and secure. To learn about our PDF.co security, please check out https://pdf.co/security
Spreadsheet Tools Benefits
Preserved Layout
The Spreadsheet Web API can reproduce the layout of the XLS file when converted to any of the supported formats.
Portable File Formats
The Web API supports the conversion of Excel to lightweight and portable file formats. File formats such as CSV and TEXT don’t need any special software to open and access them.
On-Premise API Server
Our on-premise API Server gives businesses and enterprises more flexibility and control over document and server management. When the APIs are hosted on their organization’s servers, they can use special server configurations for better and optimal performance. To get a free trial, please contact your support team.
Spreadsheet Tools Integrations
PDF.co has over 300+ app integration. Kindly explore our following plugins:
- Zapier – https://pdf.co/zapier
- Integromat – https://pdf.co/integromat
- Make https://pdf.co/make
- Airtable https://pdf.co/airtable
- Bubble https://pdf.co/bubble
- Salesforce https://pdf.co/salesforce
- Google Apps Script https://pdf.co/apps-script
- UiPath – https://pdf.co/uipath
- BluePrism – https://pdf.co/blueprism
- Automation Anywhere – https://pdf.co/automation-anywhere
- Programming languages: Javascript, PHP, Python, C#, and Java
Spreadsheet Tools Samples & Demo
In this demonstration, we will use the /v1/xls/convert/to/csv endpoint to convert an XLS to CSV. In our sample Excel, we have 2 worksheets named row and column. We will use the worksheetIndex
parameter to specify the worksheet that we want to convert.
Below are the images of the sample XLS and the output CSV.
Images of sample XLS and output CSV
Let’s go over the /v1/xls/convert/to/csv endpoint’s parameters and their corresponding functions real quick.
Endpoint
URL: | https://api.pdf.co/v1/xls/convert/to/csv |
Method: | POST |
Parameter | Description |
url | required. Link to the source file. |
worksheetIndex | optional. index of the worksheet to use. |
quotationSymbol | optional. Must be a String. |
separatorSymbol | optional. Must be a String. |
inline | optional. Set to true to return resulted content in the response instead of the link to results. |
encrypt | optional. Enable encryption to the output file. |
async | optional. Runs processing asynchronously. Returns jobId to use with job/check : true or false |
name | optional. Output file name. |
profiles | optional. Must be a String. Set custom configuration. See profiles examples here |
cURL Code Snippet
curl --location --request POST 'https://api.pdf.co/v1/xls/convert/to/csv' \ --header 'x-api-key: {{x-api-key}}' \ --header 'Content-Type: application/json' \ --data-raw '{ "url": "https://bytescout-com.s3-us-west-2.amazonaws.com/files/demo-files/cloud-api/other/Input.xls", "worksheetIndex": "0" }'
Other XLS to CSV cURL source code samples are available here.
Let’s see the XLS to CSV API in action.
Images of XLS to CSV in action
The XLS to CSV API JavaScript sample code is available here.