Convert SDC to PARQUET
Turn SDC documents into PARQUET files. One Parquet file per worksheet, named after it, hidden ones included; chart sheets and empty sheets are skipped.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop SDC files on the dialor turn it to pick what to do
One Parquet file for each worksheet.Old StarCalc spreadsheets become typed, columnar data you can load into analytics tools.
What you get
Each worksheet becomes its own Parquet file, named after the sheet. Hidden worksheets are included. Chart sheets and empty sheets are skipped.
The first row of a sheet gives the column names. The values in each column give its column type. Cells with formulas hold the last values that were computed for them.
Converting one sheet
Set Sheet to convert only one worksheet. Give its name, or its number counting from 1. When Sheet is left out, every worksheet is converted.
Because the output is one or more files, a workbook with several worksheets gives you several Parquet files. If you want them in one file afterward, you can merge PARQUET files.
SDC and PARQUET.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
StarOffice Spreadsheet
Spreadsheets from StarCalc in StarOffice 3 to 5, the binary format that came before OpenOffice.org's XML.
- Extensions
- .sdc
- MIME type
- application
/vnd .stardivision .calc - Kind
- Documents
Parquet
The columnar data format of analytics. Compressed, typed and fast to scan.
- Extensions
- .parquet .pq
- MIME type
- application
/vnd .apache .parquet - Kind
- Text and data
In your code.The same SDC to PARQUET conversion through the API, for your app or your agent.
$ cv convert report.sdc report/ --to parquet$ cv convert report.sdc report/ --to parquetQuestions.What people ask about SDC to PARQUET.
Yes. Each worksheet becomes one Parquet file named after it. Hidden worksheets are included, but chart sheets and empty sheets are skipped.
They come from the first row of each worksheet. The column types come from the values below it.
The cells give their last computed values. The formulas themselves are not carried over.
Yes. Set Sheet to the name of the worksheet or to its number counting from 1. Leave it out to convert every worksheet.