Sheets

Spreadsheets in your terminal.

Command Line Interface

Launch the TUI

> sheets budget.csv

Read from stdin:

> sheets <<< ID,Name,Age
1,Alice,24
2,Bob,32
3,Charlie,26

Read a specific cell:

> sheets budget.csv B9
2760

Or, range:

> sheets budget.csv B1:B3
1200
950
810

Modify a cell:

> sheets budget.csv B7=10 B8=20

Navigation

• h, j, k, l: Move the active cell
• gg, G, 5G, gB9: Jump to the top, bottom, a row number, or a specific cell
• 0, ^, $: Jump to the first column, first non-empty column, or last non-empty column in the row
• H, M, L: Jump to the top, middle, or bottom visible row
• ctrl+u, ctrl+d: Move half a page up or down
• zt, zz, zb,: Align the current row to the top, middle, or bottom of the window
• /, ?: Search forward or backward
• n, N: Repeat the last search
• ma, 'a: Set a mark and jump back to it later
• ctrl+o, ctrl+i: Move backward or forward through the jump list
• q, ctrl+c: Quit

Editing & Selection

• i, I, c: Edit the current cell, edit from the start, or clear the cell and edit
• ESC: Leave insert, visual, or command mode
• enter, tab, shift+tab: In insert mode, commit and move down, right, or left
• ctrl+n, ctrl+p: In insert mode, commit and move down or up
• o, O: Insert a row below or above and start editing
• v, V: Start a visual selection or row selection
• y, yy: Copy the current cell, or yank the current row(s)
• x, p: Cut the current cell or selection, and paste the current register
• dd: Delete the current row
• u, ctrl+r, U: Undo and redo
• .: Repeat the last change

Visual Mode

• =: In visual mode, insert a formula after the selected range =|(B1:B8).

Command Mode

Press : to open the command prompt, then use commands such as:

• :w to save
• :w path.csv to save to a new file
• :e path.csv to open another CSV
• :q or :wq to quit
• :goto B9 or :B9 to jump to a cell

Installation

Install with Go:

go install github.com/maaslalani/sheets@main

Or download a binary from the releases.

License

MIT

Feedback

I'd love to hear your feedback on improving sheets.

Feel free to reach out via: * Email * Twitter * GitHub issues

---

_zzz