Convert CWKSHEET to JSON

Turn CWKSHEET 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 CWKSHEET files on the dialor turn it to pick what to do

AppleWorks sheets as JSON rows.Each worksheet becomes its own JSON file, with one object for every row.

  1. What you get

    One JSON file per worksheet, and hidden worksheets are included. Each file holds an array with one object per row. The keys come from the first row of the sheet.

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

  2. What changes

    Formulas give their last computed values, so the JSON holds the results and not the formulas.

    A sheet with only one row becomes an empty array. That row is used for the keys, so no data rows are left to write.

  3. Databases

    A CWK file can also hold a database. Its records come without their field names, so the first record gives the keys. That record is used for the keys, and the rest follow as objects.

    The .cwk extension is shared with AppleWorks word processing documents. This conversion is for the spreadsheets and databases.

CWKSHEET and JSON.What each format is.

The formats

From · CWKSHEET

AppleWorks Spreadsheet

Spreadsheets and databases from ClarisWorks and AppleWorks 5 and 6. They share the .cwk extension with AppleWorks word processing documents.

Extensions
.cwk
MIME type
application/x-appleworks-spreadsheet
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 CWKSHEET to JSON conversion through the API, for your app or your agent.

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

Questions.What people ask about CWKSHEET to JSON.

01OF 04

One JSON file per worksheet. Hidden worksheets are included.

Yes. The keys come from the first row of the sheet. For a database, the first record gives the keys.

No. Each formula gives its last computed value.

The sheet has only one row. That row gives the keys, so there are no rows left to turn into objects. For more on the format, see every JSON conversion.

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