SQLite Forum

Noob Question
Login
I think you have data currently in Excel, and want your data in SQLite.

The CSV format is a widely-used format.  Pretty-much all software that handles data in columns can read and write files in this format.  So when moving data from one system to another, it's common to use CSV as a half-way-house.

The normal way to do this is to use the Save or Export functions in Excel to save the data to a .csv file in CSV format.  Then to use the SQLite command line tool to import data from the .csv file into a SQLite database.  You can find information on the SQLite site of this here:

<https://sqlite.org/cli.html#importing_csv_files>

If you're new to SQLite I recommend reading the entire page, since it is a good introduction to an incredibly useful tool for manipulating SQLite files.  You won't understand it all, but it'll get you thinking right.

To add another column to an existing SQLite database, use the <code>ALTER TABLE ADD COLUMN</code> command described in section 4 of

<https://www.sqlite.org/lang_altertable.html>