Sc-im

A cli spreadsheet editor.<
An improved fork of sc.

Supports:

• .sc
• .csv
• .tsv
• .md
• .txt

Imports from:

• .ods
• .xls
• .xlsx

Documentation

github	https://github.com/andmarti1424/sc-im
official docs	https://github.com/andmarti1424/sc-im/wiki/SCIM-command-examples

Tutorials

gentoo wiki

https://wiki.gentoo.org/wiki/Sc-im

Locations

~/.config/sc-im/scimrc

config

Install

aur sync sc-im

Usage

sc-im  # start program

Basics

help

:h

insert info

=  # enter a number or formula
<  # insert left-justified text
>  # insert right-justified text
\  # insert centered text

edit info

x    # delete cell contents
e    # edit number (vi)
E    # edit string (vi)

syntax

=a1           # ref to cell a1
=@sum(a1:a5)  # sum a1-a5

navigation

w/b  # jump forwards/backwards to filled cells
v    # visual select

rows/columns

f{h,j,k,l}  # change cell height/width vi-style directionally
{i,d}{r,c}  # insert/delete row/column (supports vi-command number prefix)

{Z,s}{r,c}  # hide/show row/column

Functions

There are tons, you can even run lua scripts (see :help).

@upper("abc")
@lower("abc")
@avg(A1:A5)

Saving

:w file.sc      " write a (native) .sc file
:e csv foo.scv  " write a csv file
:e mkd foo.mkd  " write markdown table