Excel: R or Ipython for people who like paying for an inferior version of a free app.
In my view, the unique selling point of spreadsheet is providing a GUI per default for your data. This is not much of a selling point since a non-spreadsheet statistics program like R can also have a GUI and better graphing besides, and the spreadsheet GUI is obtrusive and limiting compared to more modern stuff like R. I say this as someone who finds the R language design icky.
But this GUI business really pays for itself when it comes to collaborative editing or analysis of your data. In the 21st century there are online collaborative spreadsheets. Sharing the workload is a good thing; hardly a data set worth having was collected by one person. (Although I do want a sneakernet version of these online apps)
Here, therefore, is a list of online collaborative data-analysis spreadsheet-like tools, which is the only kind that is not a pure waste of time.
ethersheet is a node.js-backed cypherpunkish spreadsheet made by privacy warriors, much like sibling project etherpad. Requires MySQL.
ethercalc is another node.js-backed spreadsheet with
- explicit design documentation,
- modern technology, (redis or fs)
- and an explicit pedigree starting with Dan Bricklin, the progenitor of all spreadsheets.
On the other hand,
- It may be a one-person shop, and
- the interface is… uh… vintage. Classic? Kind of a HD text mode, with certain shortcomings such as lack of column selection.
Google docs offers a spreadsheet, but it does involve giving them your data for free like a chump.
Also of note:
CKAN “is a powerful data management system that makes data accessible – by providing tools to streamline publishing, sharing, finding and using data. CKAN is aimed at data publishers (national and regional governments, companies and organizations) wanting to make their data open and available.”
- Seems to have a data table library called recline.
treesheets is an open-source data GUI which is not really calculation-focussed but more a hierarchical freeform database.
pandas can read Excel sheets into python