Sheets: Spreadsheets in Your Terminal

Spreadsheets in your terminal.

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

h,j,k,l: Move the active cellgg,G,5G,gB9: Jump to the top, bottom, a row number, or a specific cell0,^,$: Jump to the first column, first non-empty column, or last non-empty column in the rowH,M,L: Jump to the top, middle, or bottom visible rowctrl+u,ctrl+d: Move half a page up or downzt,zz,zb,: Align the current row to the top, middle, or bottom of the window/,?: Search forward or backwardn,N: Repeat the last searchma,'a: Set a mark and jump back to it laterctrl+o,ctrl+i: Move backward or forward through the jump listq,ctrl+c: Quit

i,I,c: Edit the current cell, edit from the start, or clear the cell and editESC: Leave insert, visual, or command modeenter,tab,shift+tab: In insert mode, commit and move down, right, or leftctrl+n,ctrl+p: In insert mode, commit and move down or upo,O: Insert a row below or above and start editingv,V: Start a visual selection or row selectiony,yy: Copy the current cell, or yank the current row(s)x,p: Cut the current cell or selection, and paste the current registerdd: Delete the current rowu,ctrl+r,U: Undo and redo.: Repeat the last change

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

.

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

:wto save:w``path.csv

to save to a new file:e``path.csv

to open another CSV:qor:wqto quit:goto B9or:B9to jump to a cell

Install with Go:

go install github.com/maaslalani/sheets@main

Or download a binary from the releases.

I'd love to hear your feedback on improving sheets

.

Feel free to reach out via:

zzz