Cheat Sheet logoCheat Sheet Today
SQLite CLI and Shell Cheatsheet/Use aligned column output

Render query results in a readable table.

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

Use aligned column output

text
text
.mode column
Explanation

Great for interactive browsing in a terminal.

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
Show column headers
Enable headers in tabular output.
OpenIn sheettextsame section
Export rows as CSV
Switch output mode to CSV.
OpenIn sheettextsame section
Import a CSV file into a table
Load rows from CSV using the shell importer.
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