sqlitebiterfile
is a subcommand to convert tabular data file(s) to a SQLite database file.--format
optionsqlitebiterfile
subcommand help¶Format | File Extension | Remarks Fallout 4 the rebel download. |
---|---|---|
CSV | .csv | |
Excel | .xlsx /.xls | Create table for each sheet in the Excel workbook. |
HTML | .html /.htm | Scrape tabular data from <table> tags in the HTML file. |
JSON | .json | |
Jupyter Notebook | .ipynb | |
Line-delimited JSON | .jsonl /.ldjson /.ndjson | |
LTSV | .ltsv | |
Markdown | .md | And create a table for each <table> tabular data. |
SQLite | .sqlite /.sqlite3 | |
TSV | .tsv |
Format | Table Name |
---|---|
CSV | <filename> |
Excel | <Sheetname> |
HTML | <title>_<key> . <title> replaced with the title tag of the page.<key> replaced with: (1)id attribute of the table tag.(2) unique string if id attribute not present in the table tag. |
JSON | |
LTSV | <filename> |
Markdown | <filename> |
TSV | <filename> |
<filename>
replaced with filename of converting file (without extensions)sample.csv
, <filename>
is sample
A
) and create table (after this referred to as B
) structure:A
and B
has the same table name and table structureA
and B
has the same table name, but different table structuresqlitebiter
try to create unique table name for B
by appending suffix id number