MediaWiki:Gadget-copyTable.js

Note: After publishing, you may have to bypass your browser's cache to see the changes.

Firefox / Safari: Hold Shift while clicking Reload, or press either Ctrl-F5 or Ctrl-R (⌘-R on a Mac)
Google Chrome: Press Ctrl-Shift-R (⌘-Shift-R on a Mac)
Edge: Hold Ctrl while clicking Refresh, or press Ctrl-F5.

/**
 * Gadget: CopyTable
 * Discreet copy icon at the bottom-right of every wikitable.
 * Copies content as TSV for pasting into Excel / Sheets.
 */
( function () {
    'use strict';

    // Standard two-rectangle "copy" icon
    var COPY_ICON = '<svg xmlns="http://www.w3.org/2000/svg" width="14" height="14" '
        + 'viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" '
        + 'stroke-linecap="round" stroke-linejoin="round">'
        + '<rect x="9" y="9" width="13" height="13" rx="2" ry="2"/>'
        + '<path d="M5 15H4a2 2 0 0 1-2-2V4a2 2 0 0 1 2-2h9a2 2 0 0 1 2 2v1"/>'
        + '</svg>';

    // Checkmark shown after copy
    var CHECK_ICON = '<svg xmlns="http://www.w3.org/2000/svg" width="14" height="14" '
        + 'viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" '
        + 'stroke-linecap="round" stroke-linejoin="round">'
        + '<polyline points="20 6 9 17 4 12"/>'
        + '</svg>';

    function tableToTSV( table ) {
        var lines = [];
        $( table ).find( 'tr' ).each( function () {
            var cells = [];
            $( this ).find( 'th, td' ).each( function () {
                cells.push( $( this ).text().trim().replace( /[\t\n\r]+/g, ' ' ) );
            } );
            lines.push( cells.join( '\t' ) );
        } );
        return lines.join( '\n' );
    }

    mw.hook( 'wikipage.content' ).add( function ( $content ) {
        $content.find( 'table.wikitable' ).not( '.copy-table-added' ).each( function () {
            var $table = $( this ).addClass( 'copy-table-added' );

            var $btn = $( '<button>' )
                .addClass( 'copy-table-btn' )
                .attr( 'title', 'Copy table' )
                .html( COPY_ICON )
                .on( 'click', function () {
                    var tsv = tableToTSV( $table[ 0 ] );
                    navigator.clipboard.writeText( tsv ).then( function () {
                        $btn.html( CHECK_ICON ).addClass( 'copy-table-btn--ok' );
                        setTimeout( function () {
                            $btn.html( COPY_ICON ).removeClass( 'copy-table-btn--ok' );
                        }, 2000 );
                    } );
                } );

            // Wrap table so button can be absolutely positioned
            $table.wrap( '<div class="copy-table-wrapper">' );
            $table.parent().append( $btn );
        } );
    } );
}() );