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.
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.
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.
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.
- 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
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.
$ cv convert report.wk1 report/ --to json$ cv convert report.wk1 report/ --to jsonQuestions.What people ask about WK1 to JSON.
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.