datasette-copyable

Datasette plugin for outputting tables in formats suitable for copy and paste

Installation

Install this plugin in the same environment as Datasette.

$ pip install datasette-copyable

Demo

You can try this plugin on fivethirtyeight.datasettes.com - browse for tables or queries there and look for the "copyable" link. Here's an example for a table of airline safety data.

Usage

This plugin adds a .copyable output extension to every table, view and query.

Navigating to this page will show an interface allowing you to select a format for copying and pasting the demo. The default is TSV, which is suitable for copying into Google Sheets or Excel.

You can add ?_raw=1 to get back just the raw data.

Development

To set up this plugin locally, first checkout the code. Then create a new virtual environment:

cd datasette-copyable
python3 -mvenv venv
source venv/bin/activate

Or if you are using pipenv:

pipenv shell

Now install the dependencies and tests:

pip install -e '.[test]'

To run the tests:

pytest