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

Click or drag over the table cells, columns or rows to select. Copy the selection to the clipboard. Paste in your spreadsheet program or text editor. Use the Popup menu to change the extension options.

Select with modifier keys

Press and hold and click to select cells:

ShakespeareWilliam15641616
DefoeDaniel16601731
SwiftJonathan16671745
BlakeWilliam17571827
AustenJane17751817
DickensCharles18121870
OrwellGeorge19031950

Press and hold and click to select columns:

ShakespeareWilliam15641616
DefoeDaniel16601731
SwiftJonathan16671745
BlakeWilliam17571827
AustenJane17751817
DickensCharles18121870
OrwellGeorge19031950

Press and hold both and and click 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

Alternatively, you can press a keyboard shortcut (⌃⌥S by default) and just 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 need and click Copy.

You can also use the keyboard shortcut to copy (⌃⌥C by default).

Copy 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, transpose columns and rows.
  • HTML — HTML source code of the table. Use this if you want to insert the table in your website code.
  • 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