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.
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.
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.
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.
- 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
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
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.
$ cv convert report.wk1 report.sqlite$ cv convert report.wk1 report.sqliteQuestions.What people ask about WK1 to SQLITE.
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.