Convert WK1 to JSON

Turn WK1 documents into JSON files. One JSON file per worksheet, hidden ones included: an array with one object per row, keyed by the sheet's first row.

Converted in an isolated sandbox on our serversDeleted after 24 hours

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

Worksheet rows as JSON data.Each Lotus 1-2-3 worksheet becomes a JSON array with one object per row.

  1. What you get

    One JSON file per worksheet, and hidden worksheets are included. Each file is an array with one object per row, keyed by the first row of the sheet. So the first row works as the column names.

    Numbers are typed as numbers. Dates are written as YYYY-MM-DD. Booleans stay the text TRUE or FALSE, not JSON true and false.

  2. Formulas and empty sheets

    A formula cell gives its last computed value, the one stored in the file.

    A sheet with only one row becomes an empty array. That row is used for the keys, so no row is left to turn into an object.

  3. Choosing a worksheet

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

    The WK1 label covers the .wks, .wk1, .wk3, .wk4 and .123 files. To see other options for these files, look at every WK1 conversion.

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

JSON

JSON, the data format of every API.

Extensions
.json
MIME type
application/json
Kind
Text and data

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

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

Questions.What people ask about WK1 to JSON.

01OF 04

Yes, hidden ones included, and each worksheet gets its own JSON file. Set Sheet to convert just one.

The keys come from the first row of the sheet. Each object after that holds one row, under those keys.

You get the last computed values of the formulas.

The sheet has only one row. That row gives the keys, so there are no data rows to write.

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