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 PDF.co built-in files storage. To upload files via API, Check out the Files 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.g cache: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.
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
Set the expiration time for the output link in minutes (default is 60 i.e 60 minutes or 1 hour), After this specified duration, any generated output file(s) will be automatically deleted from PDF.co temporary files storage. The maximum duration for link expiration varies based on your current subscription plan. Learn more

To store permanent input files (e.g. re-usable images, pdf templates, documents), Consider using PDF.co built-in Files Storage.
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
Set async to true for long processes to run in the background, API will then return a jobId which you can use with /job/check endpoint to check the status of the process and retrieve the output while you can proceed with other tasks without waiting for this process to finish.
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