Copy the data out of a Confluence table as CSV using Chrome devtools

confluence-table-to-csv.js

function escapeAsCsv(str) {
    // Double up double quotes and quote the entire string if necessary
    if (str.includes(',') || str.includes('\n') || str.includes('"')) {
        return '"' + str.replace(/"/g, '""') + '"';
    }
    return str;
}

// Export Confluence table as CSV
// Select the tbody element in Chrome devtools Elements panel then run the
// following in the Console to copy the contents of the table as CSV to the
// clipboard.
copy(jQuery('tr', $0).get().map(function (row) {
    return jQuery('p', row).get().map(function (elm) {
        return escapeAsCsv(elm.textContent);
    }).join(',');
}).join('\n'));

copy with headers

function escapeAsCsv(str) {
  // Double up double quotes and quote the entire string if necessary
  if (str.includes(",") || str.includes("\n") || str.includes('"')) {
    return '"' + str.replace(/"/g, '""') + '"';
  }
  return str;
}

// Export Confluence table as CSV including headers
// Select the tbody element in Chrome devtools Elements panel then run the
// following in the Console to copy the contents of the table as CSV to the
// clipboard.
copy(
  jQuery("tr", $0).get().map(function (row) {
      if (jQuery("th", row).length > 0) {
        // If the row is a header, return the header text
        return jQuery("th", row).get().map(function (elm) {
            return escapeAsCsv(elm.textContent);
          }).join(",");
      } else {
        return jQuery("td", row).get().map(function (elm) {
            return escapeAsCsv(elm.textContent);
          }).join(",");
      }
  }).join("\n"),
);