Copytables

Safari App Extension
Copy tables from websites and paste them into spreadsheets and text documents

Download_on_the_Mac_App_Store_Badge_US-UK_RGB_blk_092917

How to use Copytables

1 Hold the command⌘ key and click table cells to select them

2 Click the extension icon on the toolbar to open the menu

3 Select the Copy icon and click Copy

4 Paste the table in your spreadsheet program or text editor

Note that Copytables only works with actual HTML tables.
Generic tabular pages and online spreadsheets are not supported.

More modifier keys

Press and hold command⌘ and click or drag to select table cells

ShakespeareWilliam15641616
DefoeDaniel16601731
SwiftJonathan16671745
BlakeWilliam17571827
AustenJane17751817
DickensCharles18121870
OrwellGeorge19031950

Press and hold option⌥ and click or drag to select columns:

ShakespeareWilliam15641616
DefoeDaniel16601731
SwiftJonathan16671745
BlakeWilliam17571827
AustenJane17751817
DickensCharles18121870
OrwellGeorge19031950

Press and hold both command⌘ and option⌥ and click or drag to select rows:

ShakespeareWilliam15641616
DefoeDaniel16601731
SwiftJonathan16671745
BlakeWilliam17571827
AustenJane17751817
DickensCharles18121870
OrwellGeorge19031950

You can configure the modifier keys in the Popup menu
under Drag & select

Select with a keyboard shortcut

Press control ^ option ⌥ S and simply drag over a table to select.

Configure the shortcut in the Popup menu under Keyboard

Copy to the clipboard

In the Copy tab in the Popup menu, select the format you want to use and click Copy

You can also press control ^ option ⌥ C to copy.

Configure the shortcut in the Popup menu under Keyboard

Formats

You can copy your selection in various formats:

  • Formatted : as seen of the screen, with all formatting. Use this if you want to copy a table into a text editor.
  • CSV : Comma Separated Values, a common standard text-based format. Use this to copy into a spreadsheet application.
  • CSV transposed : CSV format with columns and rows swapped.
  • HTML : HTML source code of the table. Use this if you want to insert the table in your website code.
  • Markdown : a nicely aligned table, suitable for Markdown and Text documents.

    • Infobox

    The Infobox displays useful information about selected numbers: their sum, average, maximum and minimum values.

    You can configure the infobox, or turn it off, in the Popup menu
    under Infobox