Convert SQL to SLK

Turn SQL files into SLK files. The tables the script creates are loaded first, with a dump from MySQL, MariaDB or PostgreSQL rewritten into SQLite's dialect.

Converted in an isolated sandbox on our serversDeleted after 24 hours

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

One spreadsheet of values for each table.Each table in the script becomes its own SYLK file with a header row.

  1. What you get

    The tables the script creates are loaded first, then each one is written as a SYLK file of values. The file is named after its table and starts with a header row. A script with several tables gives you several files.

    A dump from MySQL, MariaDB or PostgreSQL is rewritten into SQLite's dialect before it is loaded.

  2. What changes

    SYLK holds only Western text, so other letters, such as Korean, become question marks.

    Dates that are not real dates, such as MySQL's 0000-00-00, are left empty. PostgreSQL true and false become 1 and 0.

  3. What is left out

    Views, functions and triggers are not converted. They are left out with a warning. Only the tables and their values reach the SYLK files.

SQL and SLK.What each format is.

The formats

From · SQL

SQL Script

SQL statements as text. A database dump that any SQL tool can read or replay.

Extensions
.sql
MIME type
application/sql
Kind
Text and data
To · SLK

SYLK Spreadsheet

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

Extensions
.slk .sylk
MIME type
application/x-sylk
Kind
Documents

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

terminal
$ cv convert report.sql report/ --to slk
$ cv convert report.sql report/ --to slk

Questions.What people ask about SQL to SLK.

01OF 04

Yes. Each table becomes one SYLK file named after it, with a header row.

Yes. A dump from MySQL, MariaDB or PostgreSQL is rewritten into SQLite's dialect before the tables are loaded.

SYLK holds only Western text, so Korean letters become question marks.

It is not a real date, so the cell is left empty.

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