Sheets Spreadsheets in Your Terminal

Summary

Spreadsheets in your terminal. 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 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 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 =: In visual mode, insert a formula after the selected range =|(B1:B8). 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 Install with Go: go install github.com/maaslalani/sheets@main Or download a binary from the releases. MIT I'd love to hear your feedback on improving sheets. Feel free to reach out via: zzz