Real SQLite reader — WebAssembly — no upload

Export SQLite to CSV
Any table, any
query.

Free SQLite to CSV converter. Upload any .db or .sqlite file — all tables are detected automatically. Select a table or write a custom SQL query. Download CSV or copy to clipboard. Your database never leaves your browser.

Your database never leaves your browser
sql.js WebAssembly engine
Custom SQL queries
Copy to clipboard
Always free
Need the reverse? CSV to SQLite converter
SQLite to CSV Converter  WebAssembly
Uses sql.js — SQLite compiled to WebAssembly. Your .db file is read entirely in your browser. No data is uploaded.
Drop your SQLite database here
.db, .sqlite, .sqlite3, .s3db — all tables detected automatically
 Export complete 

      

 
    

  

 
  
  
Native SQLite CSV export commands

  
Faster alternatives when you have the sqlite3 CLI or Python available.

 
  

    
sqlite3 CLI — one-liner

    
sqlite3 -header -csv database.db "SELECT * FROM table_name;" > output.csv

    
The -header flag adds column names as the first row. -csv sets output mode. Works on macOS, Linux and Windows with sqlite3 installed.

  

 
  

    
sqlite3 interactive mode

    
sqlite3 database.db
.headers on
.mode csv
.output output.csv
SELECT * FROM table_name;
.output stdout

    
Useful when you want to run multiple queries or inspect the schema first with .tables and .schema commands.

  

 
  

    
Python — pandas + sqlite3

    
import sqlite3, pandas as pd
 
conn = sqlite3.connect('database.db')
df   = pd.read_sql('SELECT * FROM table_name', conn)
df.to_csv('output.csv', index=False)
conn.close()

    
Works for any SELECT query — filter, join or transform data before exporting.

  

 
  

 
  
  
How SQLite to CSV conversion works

  

    

      
1

      

      
sql.js opens the binary .db file

      
sql.js loads the SQLite 3 WebAssembly engine and reads your .db file as an ArrayBuffer. It parses the SQLite binary format and gives you a full in-memory database with the complete schema and data intact.

    

    

      
2

      

      
Tables listed, query auto-filled

      
CSVShift queries sqlite_master to list all tables with their row counts. Selecting a table auto-fills the query as SELECT * FROM "table"; — edit to add WHERE, JOINs or aggregates.

    

    

      
3

      

      
Query executed, CSV downloaded

      
The query runs against the in-memory database. Results are serialised to RFC 4180 CSV with UTF-8 BOM encoding — ready to open in Excel, Google Sheets, or re-import into any database tool.

    

  

 
  

 
  
  
When do you need to export SQLite to CSV?

  

    

      
 Extracting mobile app data

      
iOS and Android apps store data in SQLite databases. Exporting tables as CSV is the standard way to analyse or back up app data without special tools.

    

    

      
 Browser data export

      
Chrome, Firefox and Safari store history, bookmarks and downloads in SQLite databases. Exporting to CSV lets you analyse browsing patterns or migrate data.

    

    

      
 Database migration

      
Moving data from SQLite to MySQL, PostgreSQL or a cloud service requires exporting to CSV first. Custom query support lets you select specific columns and filter rows before migration.

    

    

      
 Analysis and reporting

      
SQLite databases from data pipelines, IoT devices and embedded systems often need to be analysed in Excel or Google Sheets. Exporting tables to CSV is the fastest path from binary .db to a shareable spreadsheet.

    

  

 
  

 
  
  
Related CSV tools

  
CSV to SQLite
Create a real SQLite .db database file from a CSV.
CSV to SQL
Generate CREATE TABLE and INSERT statements for any SQL database.
CSV to MySQL
Ready-to-run MySQL CREATE TABLE and INSERT with utf8mb4.
MySQL to CSV
Convert mysqldump files and MySQL CLI output to CSV.
CSV to Access
Access SQL and a VBA TransferText macro for your CSV.
SQL to CSV
Turn SQL dumps and INSERT statements into a CSV file.
CSV to PostgreSQL
PostgreSQL CREATE TABLE plus COPY or INSERT from any CSV.
PostgreSQL to CSV
Export pg_dump files and psql output to CSV.
CSV to Excel
Turn any CSV into a formatted .xlsx workbook — no Excel needed.
All database converters 

 
  
  
 
  

 
  
  

    

      
Binary .db read
in your browser. No server.

      
CSVShift opens SQLite databases using sql.js — SQLite 3 compiled to WebAssembly. Your .db file is read as an ArrayBuffer in your browser tab. The binary SQLite format is parsed locally without any data leaving your device.

    

    

      
Full SQL query support
SELECT, WHERE, JOIN, GROUP BY, LIMIT — any valid SQLite SQL runs against your database.

      
All tables auto-detected
Every user table is listed with its row count on load — no need to know the schema in advance.

      
All SQLite file types
.db, .sqlite, .sqlite3, .s3db, .sl3 — all standard SQLite file extensions accepted.

      
Free, no conditions
No file size cap, no watermark, no account. Funded by display advertising only.

    

  

 
  
  

    
Frequently asked questions

 
    

      
How do I export SQLite to CSV?

      
Upload your .db file to CSVShift. The tool lists all tables automatically. Select a table, the query is auto-filled, and click Export to CSV. You can also write a custom SELECT query to filter or transform the data before exporting.

    

 
    

      
How do I convert SQLite to CSV in Python?

      
Using pandas: import sqlite3, pandas as pd; df = pd.read_sql('SELECT * FROM table', sqlite3.connect('db.sqlite')); df.to_csv('out.csv', index=False).

    

 
    

      
How do I export a SQLite table to CSV from the command line?

      
sqlite3 -header -csv database.db "SELECT * FROM table;" > output.csv — works on macOS, Linux and Windows.

    

 
    

      
Can I run custom SQL queries to filter data before exporting?

      
Yes. The query field is fully editable — add WHERE clauses, SELECT specific columns, JOIN tables or use aggregate functions. The result of the query becomes the CSV output.

    

 
    

      
Is my SQLite database safe when converting online?

      
Yes. CSVShift reads the .db file entirely in your browser using sql.js WebAssembly. Your database is never uploaded to any server.