snipt

Ctrl+h for KB shortcuts

JavaScript

HTML tables to CSV

javascript:(function() {
    $('table').each(function() {
        var $table = $(this);
        $('<div/>').css('border', $table.css('border')).css('width', $table.width()).html(
            $.map($table.find('tr'), function(tr) {
                return $.map($(tr).find('td'), function(e) {
                    return '"' + $(e).text().replace('"', '""') + '"'
                }).join(';')
            }).join('<br>')
        ).insertAfter($table);
    })
})()
https://snipt.net/embed/04fc92bbff0c0f3ddf7dc1c1b7a68470/
/raw/04fc92bbff0c0f3ddf7dc1c1b7a68470/
04fc92bbff0c0f3ddf7dc1c1b7a68470
js
JavaScript
12
2019-07-16T10:24:47
True
False
False
/api/public/snipt/25068/
html-tables-to-csv
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1"> 1</a> <a href="#L-2"> 2</a> <a href="#L-3"> 3</a> <a href="#L-4"> 4</a> <a href="#L-5"> 5</a> <a href="#L-6"> 6</a> <a href="#L-7"> 7</a> <a href="#L-8"> 8</a> <a href="#L-9"> 9</a> <a href="#L-10">10</a> <a href="#L-11">11</a> <a href="#L-12">12</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="nx">javascript</span><span class="o">:</span><span class="p">(</span><span class="kd">function</span><span class="p">()</span> <span class="p">{</span> </span><span id="L-2"><a name="L-2"></a> <span class="nx">$</span><span class="p">(</span><span class="s1">&#39;table&#39;</span><span class="p">).</span><span class="nx">each</span><span class="p">(</span><span class="kd">function</span><span class="p">()</span> <span class="p">{</span> </span><span id="L-3"><a name="L-3"></a> <span class="kd">var</span> <span class="nx">$table</span> <span class="o">=</span> <span class="nx">$</span><span class="p">(</span><span class="k">this</span><span class="p">);</span> </span><span id="L-4"><a name="L-4"></a> <span class="nx">$</span><span class="p">(</span><span class="s1">&#39;&lt;div/&gt;&#39;</span><span class="p">).</span><span class="nx">css</span><span class="p">(</span><span class="s1">&#39;border&#39;</span><span class="p">,</span> <span class="nx">$table</span><span class="p">.</span><span class="nx">css</span><span class="p">(</span><span class="s1">&#39;border&#39;</span><span class="p">)).</span><span class="nx">css</span><span class="p">(</span><span class="s1">&#39;width&#39;</span><span class="p">,</span> <span class="nx">$table</span><span class="p">.</span><span class="nx">width</span><span class="p">()).</span><span class="nx">html</span><span class="p">(</span> </span><span id="L-5"><a name="L-5"></a> <span class="nx">$</span><span class="p">.</span><span class="nx">map</span><span class="p">(</span><span class="nx">$table</span><span class="p">.</span><span class="nx">find</span><span class="p">(</span><span class="s1">&#39;tr&#39;</span><span class="p">),</span> <span class="kd">function</span><span class="p">(</span><span class="nx">tr</span><span class="p">)</span> <span class="p">{</span> </span><span id="L-6"><a name="L-6"></a> <span class="k">return</span> <span class="nx">$</span><span class="p">.</span><span class="nx">map</span><span class="p">(</span><span class="nx">$</span><span class="p">(</span><span class="nx">tr</span><span class="p">).</span><span class="nx">find</span><span class="p">(</span><span class="s1">&#39;td&#39;</span><span class="p">),</span> <span class="kd">function</span><span class="p">(</span><span class="nx">e</span><span class="p">)</span> <span class="p">{</span> </span><span id="L-7"><a name="L-7"></a> <span class="k">return</span> <span class="s1">&#39;&quot;&#39;</span> <span class="o">+</span> <span class="nx">$</span><span class="p">(</span><span class="nx">e</span><span class="p">).</span><span class="nx">text</span><span class="p">().</span><span class="nx">replace</span><span class="p">(</span><span class="s1">&#39;&quot;&#39;</span><span class="p">,</span> <span class="s1">&#39;&quot;&quot;&#39;</span><span class="p">)</span> <span class="o">+</span> <span class="s1">&#39;&quot;&#39;</span> </span><span id="L-8"><a name="L-8"></a> <span class="p">}).</span><span class="nx">join</span><span class="p">(</span><span class="s1">&#39;;&#39;</span><span class="p">)</span> </span><span id="L-9"><a name="L-9"></a> <span class="p">}).</span><span class="nx">join</span><span class="p">(</span><span class="s1">&#39;&lt;br&gt;&#39;</span><span class="p">)</span> </span><span id="L-10"><a name="L-10"></a> <span class="p">).</span><span class="nx">insertAfter</span><span class="p">(</span><span class="nx">$table</span><span class="p">);</span> </span><span id="L-11"><a name="L-11"></a> <span class="p">})</span> </span><span id="L-12"><a name="L-12"></a><span class="p">})()</span> </span></pre></div> </td></tr></table>
bookmarklet, csv, table