GitHub - maaslalani/sheets: Terminal based spreadsheet tool (original) (raw)
Spreadsheets in your terminal.
Command Line Interface
Launch the TUI
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 Homebrew on macOS or Linux:
Or install with Go:
go install github.com/maaslalani/sheets@main
Or download a binary from the releases.
License
Feedback
I'd love to hear your feedback on improving sheets.
Feel free to reach out via:
zzz