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