I suggest you write a utility program that converts your data into RFC-4180 CSV. You could probably do this as a script in Python or TCL. Suppose the program is called "column-to-csv" and works like this: > ~~~~ column-to-csv 1,15,35 file >file.csv ~~~~ Once you have such a converter program, then you can import into SQLite using a command-line like this: > ~~~~ .import -csv '|column-to-csv 1,15,35 file' table ~~~~