Sc-im

 short for Spreadsheet Calculator — Improved is Article description::a terminal-based spreadsheet and calculator with -like key bindings. The program is fairly advanced and capable spreadsheet application with most of the features modern spreadsheet users have come to expect in GUI-based spreadsheet applications. Additionally, can be used non-interactively as a simple calculator tool somewhat like.

has a number of use-cases. It can be used non-interactively as a filter to translate incompatible spreadsheets to the text-based format. It is also popular among Mutt users who wish to have a way to view spreadsheets attached to emails without exiting the terminal.

Supported File Formats
The following file formats can be imported or exported:


 * Spreadsheet Calculator files.
 * Comma Seperated Values files.
 * Tab Separated Values files.
 * Markdown Table files.
 * Plain Text files.

The following formats are supported, but only as import filters:


 * OpenDocument Spreadsheets from LibreOffice and OpenOffice.
 * Legacy Microsoft Excel files.
 * Microsoft Office Open XML files.

History
Development of the original program, then called, began in 1981 but stalled sometime in 2002. Around 2015 a group of enthusiasts decided to resume development under the name. In late 2022 the maintained package fork was migrated from GURU to the main Gentoo package repository and the unmaintained app-office/sc was removed from the tree via.

Files

 * — Per-user configuration file.

Usage
The spreadsheet editor is closely modeled after  text editor. The program has several different modes:


 * Normal Mode: where cell navigation occurs.
 * Insert Mode: where new values are entered into cells.
 * Edit Mode: to modify existing cells.
 * Command Mode: For entering commands to modify application settings.
 * Visual Mode: For selecting ranges of cells in a visually intuitive manner.

Basic navigation is performed with keys on a QWERTY keyboard's home row. As a result moves the cursor up one cell,  moves the cursor down one cell,  moves the cursor right one cell, and the  moves the cursor right one cell. That said, the, , , and the cursor keys work as expected. The and  key works the same way it does with the less or more screen pagers.

Like vim, sc-im has an extensive internal help system that can be accessed in the following manner:

Issues loading spreadsheets larger that 65,536 rows
By default limits its spreadsheets to 65,536 rows. This was a sane limit when the software was first released but as time passed spreadsheets began to be treated as "poor man's databases" and have grown ever larger. Eventually a compile-time option was added to raise this figure to a new maximum of 1,048,576 rows. Starting with sc-im-0.8.3-r1 the compile time option of 1,048,576 rows is set. If you're having issues opening large spreadsheets upgrade to at least that version.

Currently, is limited to a maximum 720 columns. There is no compile time option to raise this figure but a feature request has been opened with the upstream project to add this. Most common spreadsheet applications now set this limit to between 1,024 and 16,384 columns.

Converting between spreadsheet formats non-interactively
It's possible to use to convert between spreadsheet file formats. In fact, this is a popular use of the program. Assuming you're trying to convert a modern Microsoft Excel file to  the command would look something like this:

Other options are possible, but at this time only, , , and files have output filters.