Convert SQLITE to CSV

Turn SQLITE files into CSV files. One CSV per table, named after it, with a header row; views are skipped.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop SQLITE files on the dialor turn it to pick what to do

One CSV for each table in your database.Each table gets its own file with a header row. Views are skipped.

  1. What you get

    One CSV per table, named after the table. The first row of each file holds the column names, and the rows follow below it.

    A database with several tables gives you several files, so you can open each table on its own in any program that reads CSV.

  2. What it changes or skips

    Views are skipped. Only tables are written, so a view does not produce a file.

    Values are written as stored. Binary values are written as escaped text.

  3. When a conversion fails

    A table with text stored in a number column fails. The conversion also stops with input_corrupted when the file could not be parsed.

    To go the other way, use CSV to SQLITE.

SQLITE and CSV.What each format is.

The formats

From · SQLITE

SQLite Database

A whole relational database in one file. Tables, indexes and views.

Extensions
.sqlite .sqlite3 .db
MIME type
application/vnd.sqlite3
Kind
Text and data
To · CSV

CSV

Rows of comma-separated values. The plainest way to move a table between programs.

Extensions
.csv
MIME type
text/csv
Kind
Text and data

In your code.The same SQLITE to CSV conversion through the API, for your app or your agent.

terminal
$ cv convert report.sqlite report/ --to csv
$ cv convert report.sqlite report/ --to csv

Questions.What people ask about SQLITE to CSV.

01OF 04

Yes. Each table is written to one CSV named after it, with a header row.

No. Views are skipped, and only tables become files.

Binary values are written as escaped text.

The file could not be parsed. The conversion stops with input_corrupted in that case.

More conversions.Other ways in and out of SQLITE and CSV.