Cheat Sheet logoCheat Sheet Today
SQLite CLI and Shell Cheatsheet/Export rows as CSV

Switch output mode to CSV.

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

Export rows as CSV

text
text
.mode csv
Explanation

Useful before redirecting or writing query output to a file.

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
Import a CSV file into a table
Load rows from CSV using the shell importer.
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