Convert Excel#
Available Methods#
/xls/convert/to/json#
Converts a xls
/xlsx
/csv
file to json
.
Method: POST
Endpoint: /v1/xls/convert/to/json
/xls/convert/to/html#
Converts a xls
/xlsx
/csv
file to html
.
Method: POST
Endpoint: /v1/xls/convert/to/html
/xls/convert/to/txt#
Converts a xls
/xlsx
/csv
file to txt
.
Method: POST
Endpoint: /v1/xls/convert/to/txt
/xls/convert/to/xml#
Converts a xls
/xlsx
/csv
file to xml
.
Method: POST
Endpoint: /v1/xls/convert/to/xml
/xls/convert/to/pdf#
Converts a xls
/xlsx
/csv
file to pdf
.
Method: POST
Endpoint: /v1/xls/convert/to/pdf
Attributes#
Note
Attributes are case-sensitive and should be inside JSON for POST request, for example:
{
"url": "https://example.com/file1.pdf"
}
Attribute |
Description |
Required |
---|---|---|
|
URL to the source file. 1 |
yes |
|
HTTP auth user name if required to access source |
no |
|
HTTP auth password if required to access source |
no |
|
The index of the worksheet to use. |
no |
|
Set to |
no |
|
Set |
no |
|
File name for the generated output, the input must be in string format. |
no |
|
Set the expiration time for the output link in minutes (default is |
no |
|
Use this parameter to set additional configurations for fine-tuning and extra options. Explore the Profiles section for more. |
no |
Query parameters#
No query parameters accepted.
Payload#
{
"url": "https://pdfco-test-files.s3.us-west-2.amazonaws.com/other/Input.xls",
"async": false,
"name": "Output"
}
Response 2#
{
"url": "https://pdf-temp-files.s3.amazonaws.com/bd58508fdbaf41cb81309e2195276305/Input.csv",
"error": false,
"status": 200,
"name": "Output.csv",
"remainingCredits": 59856
}
CURL#
curl --location --request POST 'https://api.pdf.co/v1/xls/convert/to/csv' \
--header 'x-api-key: ' \
--header 'Content-Type: application/json' \
--data-raw '{
"url": "https://pdfco-test-files.s3.us-west-2.amazonaws.com/other/Input.xls",
"async": false
}'
Code samples#
Footnotes
- 1
Supports links from Google Drive, Dropbox, and PDF.co Built-In Files Storage. To upload files via the API check out the File Upload section. Note: If you experience intermittent Too Many Requests or Access Denied errors, please try to add
cache:
to enable built-in URL caching. (e.gcache:https://example.com/file1.pdf
) For data security, you have the option to encrypt output files and decrypt input files. Learn more about user-controlled data encryption.- 2
Main response codes as follows:
Code
Description
200
Success
400
Bad request. Typically happens because of bad input parameters, or because the input URLs can’t be reached, possibly due to access restrictions like needing a login or password.
401
Unauthorized
402
Not enough credits
445
Timeout error. To process large documents or files please use asynchronous mode (set the
async
parameter totrue
) and then check status using the /job/check endpoint. If a file contains many pages then specify a page range using thepages
parameter. The number of pages of the document can be obtained using the /pdf/info endpoint.Note
For more see the complete list of available response codes.