Convert WK1 to PARQUET

Turn WK1 documents into PARQUET files. One Parquet file 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 Parquet tables.Each worksheet becomes its own Parquet file, with typed columns.

  1. What you get

    One Parquet file for each worksheet, named after the worksheet. Hidden worksheets are included. Chart sheets and empty sheets are skipped.

    The column names come from the first row of the sheet. The column types come from the values in the columns.

  2. Formulas

    Cells with formulas give their last computed values. The formulas themselves are not kept.

  3. Choosing a sheet

    Every worksheet is converted unless you set Sheet. Give it a worksheet name, or its number counting from 1, to convert only that one.

    The input can be a .wks, .wk1, .wk3, .wk4 or .123 file. To combine the resulting files afterward, you can merge PARQUET.

WK1 and PARQUET.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 · PARQUET

Parquet

The columnar data format of analytics. Compressed, typed and fast to scan.

Extensions
.parquet .pq
MIME type
application/vnd.apache.parquet
Kind
Text and data

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

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

Questions.What people ask about WK1 to PARQUET.

01OF 04

One Parquet file per worksheet. Chart sheets and empty sheets do not produce a file.

From the first row of each worksheet.

Yes. Hidden worksheets are included, each with its own file.

Yes. Set Sheet to the worksheet's name or its number counting from 1.

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