sqlitebiter 0.4.1a0

sqlitebiter is a CLI tool to convert CSV/Excel/HTML/JSON/Markdown/Google-Sheets to a SQLite database file.

sqlitebiter

Summary

sqlitebiter is a CLI tool to convert CSV/Excel/HTML/JSON/Markdown/Google-Sheets to a SQLite database file.

Features

• Create a SQLite database file from:

  • CSV file(s)

  • Microsoft Excel ^TM file(s)

  • HTML file(s): extract table tag data

  • JSON file(s)

  • Markdown file(s): extract Markdown table

  • Google Sheets

Usage

For more information

More examples are available at http://sqlitebiter.readthedocs.io/en/latest/pages/usage/index.html

Installation

Install via pip

sqlitebiter can be installed via pip (Python package manager).

sudo pip install sqlitebiter

Dependencies

Python packages (mandatory)

Dependency python packages are automatically installed during sqlitebiter installation via pip.

• click

• DataPropery

• logbook

• path.py

• pytablereader

• SimpleSQLite

Google Sheets dependencies

Manual installation required to use Google Sheets feature.

• oauth2client

• pyOpenSSL

Test dependencies

• pytest

• pytest-runner

• tox

• XlsxWriter

Python packages (optional)

• lxml (Faster HTML convert if installed)

Documentation

http://sqlitebiter.readthedocs.org/en/latest/