Link Search Menu Expand Document

Convert Excel to JSON in jQuery - JavaScript

XLS/XLSX to JSON sample in JavaScript demonstrating ‘Convert Excel to JSON in jQuery’

$(document).ready(function () {
    $("#result").attr("href", '').html('');

$(document).on("click", "#submit", function () {
    $("#inlineOutput").text(''); // inline output div
    $("#status").text(''); // status div

    var apiKey = $("#apiKey").val().trim(); //Get your API key at

    var formData = $("#form input[type=file]")[0].files[0]; // file to upload
    var toType = $("#convertType").val(); // output type
    var isInline = $("#outputType").val() == "inline"; // if we need output as inline content or link to output file

    $("#status").html('Requesting presigned url for upload... &nbsp;&nbsp;&nbsp; <img src="ajax-loader.gif" />');

        url: '',
        type: 'GET',
        headers: { 'x-api-key': apiKey }, // passing our api key
        success: function (result) {

            if (result['error'] === false) {
                var presignedUrl = result['presignedUrl']; // reading provided presigned url to put our content into
                var accessUrl = result['url']; // reading output url that will indicate uploaded file

                $("#status").html('Uploading... &nbsp;&nbsp;&nbsp; <img src="ajax-loader.gif" />');

                    url: presignedUrl, // no api key is required to upload file
                    type: 'PUT',
                    data: formData,
                    processData: false,
                    success: function (result) {

                        $("#status").html('Processing... &nbsp;&nbsp;&nbsp; <img src="ajax-loader.gif" />');

                            url: '' + toType + '?url=' + presignedUrl + '&encrypt=true&inline=' + isInline,
                            type: 'POST',
                            headers: { 'x-api-key': apiKey },
                            success: function (result) {

                                $("#status").text('done converting.');

                                // console.log(JSON.stringify(result));


                                if (isInline) {
                                else {
                                    $("#result").attr("href", result['url']).html(result['url']);


                    error: function () {


<!DOCTYPE html>
<html lang="en">

    <meta charset="utf-8">
    <title>Cloud API JQuery sample</title>
    <script src=""></script>
    <script src="converter.js" type="text/javascript" encoding="UTF-8"></script>


    <form id="form" enctype="multipart/form-data">
            <label>Copy-paste your API Key for ByteScout Cloud API here</label>
            <input type="text" id="apiKey" placeholder="your cloud API Key" value="" /> No API Key yet? Sign up
            <a href="" target="_blank">here</a>.
            <label>Input Excel File (*.xls, *.xlsx)</label>
            <input type="file" name="file" id="inputFile" />
            <label>Convert To</label>
            <select id="convertType">
                <option value="csv">CSV</option>
                <option selected="selected" value="json">JSON</option>
                <option value="html">HTML</option>
                <option value="pdf">PDF</option>
            <label>Output As</label>
            <select id="outputType">
                <option value="link"> URL to output file </option>
                <option value="inline"> inline content</option>
        <button type="button" id="submit">Convert</button>
        <span id="status"></span>

    <div id="errorBlock">
            <span id="statusCode"></span>
        <ul id="errors"></ul>

    <div id="resultBlock">
        <a id="result" href="" target="_blank"></a>
        <div id="inlineOutput"></div>


</html> Web API: the Web API with a set of tools for documents manipulation, data conversion, data extraction, splitting and merging of documents. Includes image recognition, built-in OCR, barcode generation and barcode decoders to decode bar codes from scans, pictures and pdf.

Get your API key here!

Download Source Code (.zip)

return to the previous page explore XLS/XLSX to JSON endpoint