Convert WK1 to DBF

Turn WK1 documents into DBF files. Each sheet, hidden ones included, becomes its own dBASE III table with formulas as their last results and the first row as field names, cut to 10 Latin letters, digits and underscores (FIELD1 and so on when none are left).

Converted in an isolated sandbox on our serversDeleted after 24 hours

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

Each sheet becomes its own dBASE table.Formulas turn into their last results, and the first row names the fields.

  1. What you get

    One dBASE III table for each sheet in the worksheet. Hidden sheets are included, so a workbook with several sheets gives you several DBF files.

    Formulas are stored as the results they last had, not as formulas. The first row of each sheet becomes the field names.

  2. How fields are named and typed

    Field names are cut to 10 characters, using Latin letters, digits and underscores. When no usable characters are left, the field is named FIELD1 and so on.

    Numbers, dates and true/false values become typed fields. Other cells are stored as text of up to 254 bytes, in the Windows code page that fits the text, or else in UTF-8.

WK1 and DBF.What each format is.

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 · DBF

dBase Table

dBase tables, the attribute tables of shapefiles and many legacy databases.

Extensions
.dbf
MIME type
application/x-dbf
Kind
Documents

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

terminal
$ cv convert report.wk1 report/ --to dbf
$ cv convert report.wk1 report/ --to dbf

Questions.What people ask about WK1 to DBF.

01OF 04

Yes. Each sheet, hidden ones included, becomes its own dBASE III table, so you may get more than one file.

No. A formula is stored as its last result.

From the first row of the sheet. They are cut to 10 Latin letters, digits and underscores, and FIELD1 and so on are used when none are left.

The WK1 format covers .wks, .wk1, .wk3, .wk4 and .123 files. See every WK1 conversion for the others.

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