Remix.run Logo
bonsai_spool 5 hours ago

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.

somat an hour ago | parent | next [-]

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/

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

zie 5 hours ago | parent | prev | next [-]

There is SC and now 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 5 hours ago | parent [-]

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...

fiddlerwoaroof 39 minutes ago | parent | prev | next [-]

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.

hunter4309 4 hours ago | parent | prev | next [-]

Visidata[0] is a killer data swiss army knife. It's even inspired off Visicalc

[0] https://www.visidata.org/

somat an hour ago | parent [-]

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.

rauli_ 5 hours ago | parent | prev | next [-]

I actually created one for some time ago. It's nothing special but it has Vi keybindings.

https://github.com/RauliL/levite

vslira 5 hours ago | parent [-]

This is brilliant! Thank you for creating it

chungy 5 hours ago | parent | prev | next [-]

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

freedomben 5 hours ago | parent | prev | next [-]

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

zserge 4 hours ago | parent | next [-]

A slightly larger implementation at the end of the post does that to some extent - 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 3 hours ago | parent | prev | next [-]

I would think visidata could.

https://www.visidata.org/

phonon 4 hours ago | parent | prev | next [-]

https://github.com/zaphar/sheetsui

airstrike 5 hours ago | parent | prev | next [-]

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 4 hours ago | parent [-]

I would be interested! Clixel

segmondy 4 hours ago | parent | prev [-]

vibe one. ;-)

0x20cowboy 5 hours ago | parent | prev [-]

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