pyspread is a non-traditional spreadsheet application that is based on and written in the programming language Python. The goal of pyspread is to be the most pythonic spreadsheet.

pyspread expects Python expressions in its grid cells and returns Python objects, which makes a spreadsheet specific language obsolete. Each cell returns a Python object that can be accessed from other cells. These objects can represent anything including lists or matrices. Has a built-in renderer that interfaces with matplotlib for showing visualizations and graphics. Other Python modules can be imported and referenced as cells. Import CSV, export CSV, PDF, and SVG.

The latest stable release v1.1.3 of pyspread runs on Python 2.7.x. A Python 3 compatible version that runs on Python 3.6+ is available as a beta.

Git repo: https://gitlab.com/pyspread/pyspread

The Google Sheets API is so bad, a company built their own to make it easier.

REST API: https://docs.sheetsu.com/

A simple tool or library to generate a large database with multiple tables, filled with data of one's own choice. Generates random data to populate tables with that reflects commonly use cases of databases, such as customer records and user tables. Generates Pandas data frames, SQLite databases, and Excel spreadsheets.

EtherCalc is another web-based spreadsheet web app based upon node.js. Part of the SocialCalc project. Supports persistent storage of data on the back end, uses Redis if it's installed.