Untitled

<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width">
    <title>Excel to Mysql Insert</title>
    <script>
    function run()
    {
        var query='';
        var lines = document.getElementById("excel").value.split('\n');
        var countl=lines.length;

        for(var i = 0; i < countl; i++)
        {
            var columns=lines[i].split('\t');
            var countc=columns.length;
            var subquery='';

            for(var c = 0; c < countc; c++)
            {
                subquery += "'" + columns[c] + "'";
                if (c !== countc-1){ subquery += ','; }
            }
            query += '(' + subquery + ')';
            if (i !== countl-1){ query += ','; }
            query += "<br>";
        }

        var cols = document.getElementById("columns").value.split('\t');
        countcols=cols.length;
        var prequery='INSERT INTO '+document.getElementById("table").value+' (';
        for(var d = 0; d < countcols; d++)
        {
            prequery += "'" + cols[d] + "'";
            if (d !== countcols-1){ prequery += ', '; }
        }
        prequery +=') values <br>';
        document.getElementById("result").innerHTML=prequery + query + ';';
    }
    </script>
</head>
<body>
    <table width="100%">
        <tr><td>Excel to Mysql Insert</td></tr>
        <tr><td><input style="width:99%" rows="5" id="table" value="TABLE NAME" /></td></tr>
        <tr><td><textarea style="width:99%" rows="5" id="columns">PASTE EXCEL COLUMN NAMES</textarea></td></tr>
        <tr><td><textarea style="width:99%" rows="5" id="excel">PASTE EXCEL DATA</textarea></td></tr>
        <tr><td><button onclick="run();" style="padding:10px">RUN</button></td></tr>
        <tr><td><div id="result" style="border:1px solid red;padding:5px">Test</div></td></tr>
    </table>
</body>
</html>