Datasette plugin for outputting tables in formats suitable for copy and paste
Datasette plugin for outputting tables in formats suitable for copy and paste
Install this plugin in the same environment as Datasette.
$ pip install datasette-copyable
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.
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.
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