jquery-google-sheet-to-json

    0.1.2 • Public • Published

    Google Spreadsheet to JSON JQuery Plugin

    Build Status

    Take a Google docs spreadsheet url and retrieve the data in JSON format.

    See the basic example for use.

    Quick Use

    Include after JQuery on your page:

    <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.0.0-beta1/jquery.min.js"></script>
    <script src="jquery-google-sheet-to-json.min.js"></script>
    <script>
    $(document).ready(function(){
     
        // use your spreadsheet id here
        var SPREADSHEET_ID = '1nmrLOKhY_XB9vYgr-8xYTQ7dAB7AykY9G-UolHvcit0'
        $.googleSheetToJSON(SPREADSHEET_ID)
            .done(function(rows){
                // each row is a row of data from the spreadsheet
                console.log(rows);
            })
            .fail(function(err){
                console.log('error!', err);
            });
        });
    });
    </script> 

    Your spreadsheet must be public and published, see the Google documentation on it. You can find the spreadsheet id (and worksheet id if needed) in the url. The spreadsheet id is the first arg to the function, the worksheet id is the optional second arg, it will default to the first worksheet.

    The rows will be an array of objects with each property name being the value used as the first header row of the spreadsheet. See the basic example spreadsheet, things like "first name" will be changed (by Google) to be acceptable JavaScript property names: "firstname".

    Data may be present (or not) based on content:

    • An empty cell will not be in the result
    • A cell that has the header pattern name, nameNumber, ..., nameNumber will become an array with all the values
    • Otherwise it will be a string

    Warning

    Google Spreadsheets have problems if the formatting of the spreadsheet is off even a little bit. No empty rows!

    Install

    npm i jquery-google-sheet-to-json

    DownloadsWeekly Downloads

    4

    Version

    0.1.2

    License

    MIT

    Last publish

    Collaborators

    • tleen