Convert CWKSHEET to SQLITE

Turn CWKSHEET documents into SQLITE. A SQLite database with the spreadsheet as one table, which takes its column names from the first row and its column types from the values.

Converted in an isolated sandbox on our serversDeleted after 24 hours

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

A spreadsheet as a SQLite table.One table, with column names from the first row and types from the values.

  1. What you get

    A single SQLite file that holds the spreadsheet as one table. The column names come from the first row of the sheet. Each column's type comes from the values in it.

    Cells with formulas hold the last value that was computed for them.

  2. Databases in the same format

    AppleWorks databases use the same .cwk extension as spreadsheets. A database stores its records without their field names. The first record gives the column names for the table.

CWKSHEET and SQLITE.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 · SQLITE

SQLite Database

A whole relational database in one file. Tables, indexes and views.

Extensions
.sqlite .sqlite3 .db
MIME type
application/vnd.sqlite3
Kind
Text and data

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

terminal
$ cv convert report.cwk report.sqlite
$ cv convert report.cwk report.sqlite

Questions.What people ask about CWKSHEET to SQLITE.

01OF 04

One. The spreadsheet becomes a single table.

For a spreadsheet, they come from the first row. For a database, the records have no field names, so the first record gives them.

They come from the values in each column.

Each formula cell gives its last computed value.

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