SQLite 3 · Import, export and backup
Import a CSV file
Load a CSV file into a table, creating the table from the first row if it doesn't exist.
.import --csv data.csv users
Official SQLite 3 documentation
More import, export and backup commands
- Export a query to CSV
- Dump the database as SQL
- Restore from a SQL dump
- Make a binary backup
- Run a SQL script
All import, export and backup commands · SQLite 3 cheatsheet