Convert WK1 to SQLITE

Turn WK1 documents into SQLITE. A SQLite database with one table per worksheet, named after it, hidden ones included; chart sheets and empty sheets are skipped.

Converted in an isolated sandbox on our serversDeleted after 24 hours

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

Lotus worksheets as database tables.Each worksheet becomes a table in one SQLite file you can query.

  1. What you get

    One SQLite database file. Every worksheet becomes its own table, named after the worksheet. Hidden worksheets are included.

    Each table takes its column names from the first row of the sheet. Its column types come from the values in the columns.

  2. What is left out

    Chart sheets are skipped. Empty worksheets are skipped too, so they do not appear as tables.

    Formulas do not carry over as formulas. The table holds the last value each formula computed.

  3. Converting one sheet

    Every worksheet is converted when you leave Sheet out. Set Sheet to a worksheet name, or to its number counting from 1, to convert only that one.

    The same conversion reads the older and newer Lotus files alike: .wks, .wk1, .wk3, .wk4 and .123. See every WK1 conversion for the other formats.

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

  1. 01 · sheet

    Sheet

    The one worksheet to convert, by its name or by its number counting from 1. Every worksheet is converted when it is left out.

The formats

From · WK1

Lotus 1-2-3 Worksheet

Lotus 1-2-3 worksheets: .wks and .wk1 from Releases 1 and 2, .wk3 and .wk4 from Releases 3 and 4, and .123 from 1-2-3 97 and Millennium Edition.

Extensions
.wk1 .wks .wk3 .wk4 .123
MIME type
application/vnd.lotus-1-2-3
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 WK1 to SQLITE conversion through the API, for your app or your agent.

terminal
$ cv convert report.wk1 report.sqlite
$ cv convert report.wk1 report.sqlite

Questions.What people ask about WK1 to SQLITE.

01OF 04

Yes. Each worksheet becomes one table named after it. Chart sheets and empty sheets are skipped.

From the first row of each worksheet. The column types are taken from the values below it.

No. The table holds the last computed value of each formula, not the formula itself.

Yes. Set Sheet to the worksheet's name or its number, counting from 1. Leave it out to convert all of them.

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