SQLite Forum

How to set the column separator for the CSV extension in the CLI?
As you say, that code mentions something about separators, saying "... extended with the option of having a separator other than ','.".  But it does not, in fact as written, provide a way to specify any other separator than ','. So that is your primary problem.

You would do better to use the sqlite3 .import command after setting ".mode tabs".