Convert SLK to SQLITE

Turn SLK documents into SQLITE. A SQLite database with one table named data holding the values, its header from the first row and its columns typed from the values.

Converted in an isolated sandbox on our serversDeleted after 24 hours

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

A SQLite database from a SYLK sheet.The values land in a table named data, ready to query.

  1. What you get

    One SQLite file. It holds a table named data with the values from your SYLK spreadsheet.

    The header of the table comes from the first row of the sheet. Each column is typed from the values in it, so you do not have to set the types yourself.

  2. Where the names come from

    The first row of the sheet is read as the header, so write the column names there before you convert. The rows below it become the rows of the table.

    The file can be saved with the extension sqlite, sqlite3 or db.

  3. Going the other way

    To get a sheet back out of a database, use SQLITE to SLK. For other SYLK conversions, see every SLK conversion.

SLK and SQLITE.What each format is.

The formats

From · SLK

SYLK Spreadsheet

SYLK spreadsheets, a plain-text format from the early Excel years.

Extensions
.slk .sylk
MIME type
application/x-sylk
Kind
Documents
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 SLK to SQLITE conversion through the API, for your app or your agent.

terminal
$ cv convert report.slk report.sqlite
$ cv convert report.slk report.sqlite

Questions.What people ask about SLK to SQLITE.

01OF 04

The table is named data. Query it by that name once you open the database.

They come from the first row of the SYLK sheet.

Each column is typed from the values in it.

Yes. The output is one file, a SQLite database.

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