Cheat Sheet logoCheat Sheet Today
SQLite CLI and Shell Cheatsheet/Import a CSV file into a table

Load rows from CSV using the shell importer.

Back to sheetBrowse commands
Sign in to save
Section: Output, import, and export

Import a CSV file into a table

text
text
.import ./users.csv users
Explanation

Make sure the target table exists first or use a staging table for cleanup.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Output, import, and export
Export rows as CSV
Switch output mode to CSV.
OpenIn sheettextsame section
Show column headers
Enable headers in tabular output.
OpenIn sheettextsame section
Use aligned column output
Render query results in a readable table.
OpenIn sheettextsame section
Execute SQL from a file
Run a script inside the shell.
OpenIn sheettextsame section
Dump the full database as SQL
Export schema and data as executable SQL.
OpenIn sheettextsame section
Write the next query result to a file
Send one result set to a file without changing subsequent output.
OpenIn sheettextsame section