Link Search Menu Expand Document

XLS/XLSX to JSON

Explore Samples

Convert XLS, XLSX or CSV into JSON.

Available Methods

[POST] /xls/convert/to/json

Attributes
url required
URL to the source file. Supports links from Google Drive, Dropbox and from built-in PDF.co files storage.

For uploading files via API please check Files Upload section.

If you are randomly getting a Too Many Requests or Access Denied error for your input URL, Please try to add cache: to enable built-in URL caching.

You can also encrypt data for output files and decrypt data input files with user-controlled data encryption to learn more.
httpusername optional
HTTP auth user name if required to access source url.
httppassword optional
HTTP auth password if required to access source url.
name optional
File name for the generated output. Must be in a “string” format.
expiration optional
Output link expiration in minutes. The default is 60 (i.e. 60 minutes or 1 hour). After this delay generated output file(s) (if any) will be auto-removed from PDF.co temporary files storage.
Max allowed expiration period depends on your current subscription plan. To store permanent input files (e.g. re-usable images, pdf, documents), please use PDF.co built-in Files Storage instead.
worksheetIndex optional
The index of the worksheet to use.
inline optional
Set to true to return result content in the response instead of linking to the result. Must be one of: true, or false.
async optional
Runs processing asynchronously and returns JobId that you may use with /job/check to check the state of the processing (possible states: working, failed, aborted and success). Must be one of: true, or false.
profiles optional
Use this parameter to set additional configurations for fine-tuning and extra options. Must be in a “string” format. Explore PDF.co knowledgebase for profile examples.
  • Method: POST
  • URL: /v1/xls/convert/to/json

Query parameters

No query parameters accepted.

Body payload

{
    "url": "https://pdfco-test-files.s3.us-west-2.amazonaws.com/other/Input.xls",
    "async": false
}

Example responses

/xls/convert/to/json
{
    "url": "https://pdf-temp-files.s3.amazonaws.com/c4e7e487bf324c3b955f5aa7388e3e17/Input.json",
    "error": false,
    "status": 200,
    "name": "Input.json",
    "remainingCredits": 59859
}

Code Snippet

CURL
curl --location --request POST 'https://api.pdf.co/v1/xls/convert/to/json' \
--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
}'

Samples