Skip to content

Instantly share code, notes, and snippets.

@loretoparisi
Created May 4, 2016 15:35
Show Gist options
  • Save loretoparisi/6fd7f0f40035f46ab21c6d4764961c7c to your computer and use it in GitHub Desktop.
Save loretoparisi/6fd7f0f40035f46ab21c6d4764961c7c to your computer and use it in GitHub Desktop.
HTML Table to CSV in JavaScript
function exportTableToCSV($table, filename, delimiter) {
var $headers = $table.find('tr:has(th)'),
$rows = $table.find('tr:has(td)')
// Temporary delimiter characters unlikely to be typed by keyboard
// This is to avoid accidentally splitting the actual contents
,
tmpColDelim = String.fromCharCode(11) // vertical tab character
,
tmpRowDelim = String.fromCharCode(0) // null character
// actual delimiter characters for CSV format
,
colDelim = '"' + delimiter + '"',
rowDelim = '"\r\n"';
// Grab text from table into CSV formatted string
var csv = '"';
csv += formatRows($headers.map(grabRow));
csv += rowDelim;
csv += formatRows($rows.map(grabRow)) + '"';
// Data URI
//var csvData = 'data:application/csv;charset=utf-8,' + encodeURIComponent(csv);
var csvData = encodeURIComponent(csv);
download(csv, filename);
//------------------------------------------------------------
// Helper Functions
//------------------------------------------------------------
function download(csv, filename) {
var pp = document.createElement('a');
pp.setAttribute('href', 'data:application/csv;charset=utf-8,' + encodeURIComponent(csv));
pp.setAttribute('download', filename);
pp.click();
}
// Format the output so it has the appropriate delimiters
function formatRows(rows) {
return rows.get().join(tmpRowDelim)
.split(tmpRowDelim).join(rowDelim)
.split(tmpColDelim).join(colDelim);
}
// Grab and format a row from the table
function grabRow(i, row) {
var $row = $(row);
//for some reason $cols = $row.find('td') || $row.find('th') won't work...
var $cols = $row.find('td');
if (!$cols.length) $cols = $row.find('th');
return $cols.map(grabCol)
.get().join(tmpColDelim);
}
// Grab and format a column from the table
function grabCol(j, col) {
var $col = $(col),
$text = $col.text();
return $text.replace('"', '""'); // escape double quotes
}
}
@loretoparisi
Copy link
Author

Example
This example will export every table of class wikitable to csv file with a column separator ;.

$('.wikitable').each(function(index,item) {
 exportTableToCSV( $(item), 'csv_'+index+'.csv', ";" );
});

Reference test page here.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment