Bradley Kirton's Blog

Published on May 11, 2025

Go home

Importing files into sqlite

The following commands are useful for importing delimited files (CSV, TSV etc) into sqlite.

CSV

cat test | sqlite3 test.db ".mode csv" ".import /dev/stdin data"

TSV Gzipped

zcat name.basics.tsv.gz | sqlite3 imdb.sqlite3 ".mode tabs" ".import /dev/stdin names"