Help getting excel/csv file into SQLite? please help
(1) By jaygray on 2021-03-20 00:13:20 [link] [source]
Noob here. What's the best way to import an excel / csv file into SQLite? Whenever I try I get an error stating "Could not add database." Thank you !!
(2) By Larry Brasfield (larrybr) on 2021-03-20 00:58:32 in reply to 1 [link] [source]
.import (in the CLI shell) is your friend. But don't try to import an Excel file, just .import the tab-separated value format Excel is willing to produce. For that, first tell the shell: .mode tabs .
(3) By Richard PArkins (rparkins) on 2021-03-21 21:54:06 in reply to 1 [source]
sqliteman will also import excel files for you, if you are on Linux or you are prepared to build it for your operating system from the sources. It gives you a few more choices for formats, although I haven't tested the MS Excel XML format since I forked it from pvanek's version. The CSV-like format certainly works. Somewhere I have code to import the Psion database format as well, although it isn't in the published sources.