SQLite Forum

Noob Question
Login
By the way, if you use [SQLitespeed](https://sqlitespeed.com) you can simply select the data in Excel (or any other spreadsheet program) and copy it then paste into SQLitespeed by using the "Import from Clipboard" - one click, no mess no fuss.

The import page will also let you change column names, set column types/affinities etc. and set the Table name.

It's one of the base needs that system was created for.

PS: That button is one of three small import buttons to the left of the Query edit box.