3 ms·

Are there good command-line interfaces for spreadsheets? I don't do anything super financially-important and I'd prefer to stay in the terminal for quick editin

Are there good command-line interfaces for spreadsheets? I don't do anything super financially-important and I'd prefer to stay in the terminal for quick editing of things, especially if I can have Vi keybindings.

rauli_ 7mo ago
I actually created one for some time ago. It's nothing special but it has Vi keybindings. https://github.com/RauliL/levite https://github.com/RauliL/levite
- vslira 7mo ago
  This is brilliant! Thank you for creating it
chungy 7mo ago
Emacs with org-mode and evil-mode seems to be up your alley.
- zie 7mo ago
  and Emacs SES, built-in spreadsheets outside of Org-mode: https://www.gnu.org/software/emacs/manual/html_mono/ses.html#Top https://www.gnu.org/software/emacs/manual/html_mono/ses.html...
zie 7mo ago
There is SC and now sc-im: https://github.com/andmarti1424/sc-im https://github.com/andmarti1424/sc-im You can also literally run Lotus 123 if you want. Someone has binaries to make it work on linux. or under dosemu
- freedomben 7mo ago
  Neat, thank you! sc-im looks amazing, and it's even in the Fedora repos (though the repo version doesn't support xlsx, so I'll compile myself and try it out) Edit: Quite painless! Opened some test xlsx files without issue. Did get a stack trace on a very complicated one, so when I have time I'll try and dig in deeper. Added a doc to the wiki in case it's helpful to other: https://github.com/andmarti1424/sc-im/wiki/Building-sc%E2%80%90im-with-xls-support-on-Fedora https://github.com/andmarti1424/sc-im/wiki/Building-sc%E2%80...
- bombcar 7mo ago
  https://lock.cmpxchg8b.com/linux123.html https://lock.cmpxchg8b.com/linux123.html
  - zie 7mo ago
    Awesome sauce! I was too lazy to track this down, thanks for sharing! (for readers not following, this is Lotus 123 on Linux)
0x20cowboy 7mo ago
sc has been around for quite a while: https://github.com/robrohan/sc https://github.com/robrohan/sc there are several versions floating around.
freedomben 7mo ago
Oh man, a TUI spreadsheet application that can edit ODF or XLSX format would be absolutely killer. Would love to hear if anyone knows of such a tool
- airstrike 7mo ago
  Pretty sure I can build one based on code I already have. If others are interested in this, please let me know and I'll bang it out in the next couple of weeks.
  - f1shy 7mo ago
    I would be interested! Clixel
- segmondy 7mo ago
  vibe one. ;-)
- phonon 7mo ago
  https://github.com/zaphar/sheetsui https://github.com/zaphar/sheetsui
- zserge 7mo ago
  A slightly larger implementation at the end of the post does that to some extent - https://github.com/zserge/kalk https://github.com/zserge/kalk (CSV import export, Excel-like "locking" of rows/columns like $A$1). If there's a need for such a project - I'm happy to add ODF or XLSX, more compatibility with Excel formulas etc. I'm not sure about Vi keybindings, I personally find spreadsheets easier to use in a non-modal manner.
- paddy_m 7mo ago
  I would think visidata could. https://www.visidata.org/ https://www.visidata.org/
- nhatcher 7mo ago
  It's a bit low on my priority list, but I'm working on that! https://github.com/ironcalc/TironCalc https://github.com/ironcalc/TironCalc
hunter4309 7mo ago
Visidata[0] is a killer data swiss army knife. It's even inspired off Visicalc [0] https://www.visidata.org/ https://www.visidata.org/
- somat 7mo ago
  It's weird but visidata is my favorite spreadsheet. "But... visidata is not a spreadsheet" I know, that's what makes it so weird. On contemplation, I think I grew dissatisfied with the normal spreadsheet data model, I wanted something bettered structured than the "it's a big bag of cells" that spreadsheets present, I wanted row security. The best I found was the relational database. I currently use a local postgres db for most things I would have used a spreadsheet for. The interfaces sort of suck in comparison but at least I have sane data structures.
  - bombcar 7mo ago
    Microsoft access was always a moderately mediocre database but it was also always an amazing spreadsheet for so many use cases.
somat 7mo ago
I want to mention teapot. First an apology, it's not actually a good match for for question, sure, it's a curses spreadsheet, but it was made by someone who thought about the fundamentals of the problem a little too much. So it is probably a little too weird for someone who just wants to spreadsheet as Dan Bricklin intended. https://www.syntax-k.de/projekte/teapot/ https://www.syntax-k.de/projekte/teapot/ In short cell address are normalized @(1,2,3) instead of A1 or r1c1. real references so address rewriting hacks($A$1) are not needed. formula references so you can use a single master formula, and clocked expressions which allow circular dependencies/simulation. Probably a little too different for casual use but worth taking a look at, if nothing else to challenge your ideas of what a spreadsheet has to be. While looking up the website I found a rewrite in rust, which is cool I guess, someone is keeping the dream alive, I will leave a link to that as well. https://github.com/veridit/teapot https://github.com/veridit/teapot
fiddlerwoaroof 7mo ago
This might be programmer-brain, but I find sqlite is pretty nice for things people would use a spreadsheet for. It’s a little bit higher friction, but when I started designing a Improv-like terminal spreadsheet a while ago, I eventually realized I was just reinventing databases.

rauli_ 7mo ago

I actually created one for some time ago. It's nothing special but it has Vi keybindings. https://github.com/RauliL/levite https://github.com/RauliL/levite

vslira 7mo ago
This is brilliant! Thank you for creating it

chungy 7mo ago

Emacs with org-mode and evil-mode seems to be up your alley.

zie 7mo ago
and Emacs SES, built-in spreadsheets outside of Org-mode: https://www.gnu.org/software/emacs/manual/html_mono/ses.html#Top https://www.gnu.org/software/emacs/manual/html_mono/ses.html...

zie 7mo ago

There is SC and now sc-im: https://github.com/andmarti1424/sc-im https://github.com/andmarti1424/sc-im You can also literally run Lotus 123 if you want. Someone has binaries to make it work on linux. or under dosemu

freedomben 7mo ago
Neat, thank you! sc-im looks amazing, and it's even in the Fedora repos (though the repo version doesn't support xlsx, so I'll compile myself and try it out) Edit: Quite painless! Opened some test xlsx files without issue. Did get a stack trace on a very complicated one, so when I have time I'll try and dig in deeper. Added a doc to the wiki in case it's helpful to other: https://github.com/andmarti1424/sc-im/wiki/Building-sc%E2%80%90im-with-xls-support-on-Fedora https://github.com/andmarti1424/sc-im/wiki/Building-sc%E2%80...
bombcar 7mo ago
https://lock.cmpxchg8b.com/linux123.html https://lock.cmpxchg8b.com/linux123.html
- zie 7mo ago
  Awesome sauce! I was too lazy to track this down, thanks for sharing! (for readers not following, this is Lotus 123 on Linux)

0x20cowboy 7mo ago

sc has been around for quite a while: https://github.com/robrohan/sc https://github.com/robrohan/sc there are several versions floating around.

freedomben 7mo ago

Oh man, a TUI spreadsheet application that can edit ODF or XLSX format would be absolutely killer. Would love to hear if anyone knows of such a tool

airstrike 7mo ago
Pretty sure I can build one based on code I already have. If others are interested in this, please let me know and I'll bang it out in the next couple of weeks.
- f1shy 7mo ago
  I would be interested! Clixel
segmondy 7mo ago
vibe one. ;-)
phonon 7mo ago
https://github.com/zaphar/sheetsui https://github.com/zaphar/sheetsui
zserge 7mo ago
A slightly larger implementation at the end of the post does that to some extent - https://github.com/zserge/kalk https://github.com/zserge/kalk (CSV import export, Excel-like "locking" of rows/columns like $A$1). If there's a need for such a project - I'm happy to add ODF or XLSX, more compatibility with Excel formulas etc. I'm not sure about Vi keybindings, I personally find spreadsheets easier to use in a non-modal manner.
paddy_m 7mo ago
I would think visidata could. https://www.visidata.org/ https://www.visidata.org/
nhatcher 7mo ago
It's a bit low on my priority list, but I'm working on that! https://github.com/ironcalc/TironCalc https://github.com/ironcalc/TironCalc

hunter4309 7mo ago

Visidata[0] is a killer data swiss army knife. It's even inspired off Visicalc [0] https://www.visidata.org/ https://www.visidata.org/

somat 7mo ago
It's weird but visidata is my favorite spreadsheet. "But... visidata is not a spreadsheet" I know, that's what makes it so weird. On contemplation, I think I grew dissatisfied with the normal spreadsheet data model, I wanted something bettered structured than the "it's a big bag of cells" that spreadsheets present, I wanted row security. The best I found was the relational database. I currently use a local postgres db for most things I would have used a spreadsheet for. The interfaces sort of suck in comparison but at least I have sane data structures.
- bombcar 7mo ago
  Microsoft access was always a moderately mediocre database but it was also always an amazing spreadsheet for so many use cases.

somat 7mo ago

I want to mention teapot. First an apology, it's not actually a good match for for question, sure, it's a curses spreadsheet, but it was made by someone who thought about the fundamentals of the problem a little too much. So it is probably a little too weird for someone who just wants to spreadsheet as Dan Bricklin intended. https://www.syntax-k.de/projekte/teapot/ https://www.syntax-k.de/projekte/teapot/ In short cell address are normalized @(1,2,3) instead of A1 or r1c1. real references so address rewriting hacks($A$1) are not needed. formula references so you can use a single master formula, and clocked expressions which allow circular dependencies/simulation. Probably a little too different for casual use but worth taking a look at, if nothing else to challenge your ideas of what a spreadsheet has to be. While looking up the website I found a rewrite in rust, which is cool I guess, someone is keeping the dream alive, I will leave a link to that as well. https://github.com/veridit/teapot https://github.com/veridit/teapot

fiddlerwoaroof 7mo ago

This might be programmer-brain, but I find sqlite is pretty nice for things people would use a spreadsheet for. It’s a little bit higher friction, but when I started designing a Improv-like terminal spreadsheet a while ago, I eventually realized I was just reinventing databases.