Convert TSV to SQLITE

Turn TSV files into SQLITE. A SQLite database with one table named data, its columns typed from the values, such as integers, decimals, dates and text.

Converted in an isolated sandbox on our serversDeleted after 24 hours

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

A SQLite database from your TSV file.One table named data, with columns typed from the values.

  1. What you get

    A single SQLite file with one table named data. Each column is typed from the values in it, such as integers, decimals, dates and text.

    A column that mixes numbers and text further down is kept as text.

  2. Column names

    By default, the first row holds the column names. Turn off Header row if your file has no header. The columns are then named column0, column1 and so on.

TSV and SQLITE.What each format is, and the options this conversion takes.

  1. 01 · header

    Header row

    Whether the first row holds the column names rather than data.

    default true

The formats

From · TSV

Tab-Separated Values

Tab-separated values.

Extensions
.tsv .tab
MIME type
text/tab-separated-values
Kind
Text and data
To · 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

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

terminal
$ cv convert sheet.tsv sheet.sqlite
$ cv convert sheet.tsv sheet.sqlite

Questions.What people ask about TSV to SQLITE.

01OF 04

One. The table is named data.

Yes. They are typed from the values, such as integers, decimals, dates and text.

It is kept as text.

They are named column0, column1 and so on. Turn off Header row to use this naming.

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