Convert SQLITE to TSV

Turn SQLITE files into TSV files. One TSV 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 TSV for every table in the database.Each table becomes its own file, named after the table, with a header row.

  1. What you get

    One or more TSV files, one for each table in the SQLite database. Each file is named after its table and starts with a header row.

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

  2. What it leaves behind

    Views are skipped. Only tables produce files, so a view does not get a TSV of its own.

  3. When a conversion stops

    A table with text stored in a number column fails. Check that column before you convert.

    The conversion also stops with input_corrupted when the file could not be parsed.

    To go the other way, use TSV to SQLITE.

SQLITE and TSV.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 · TSV

Tab-Separated Values

Tab-separated values.

Extensions
.tsv .tab
MIME type
text/tab-separated-values
Kind
Text and data

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

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

Questions.What people ask about SQLITE to TSV.

01OF 04

Yes. The output is one TSV per table, named after the table, each with a header row.

They are skipped. No TSV is written for a view.

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

The file could not be parsed. The conversion stops with input_corrupted when that happens.

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