3 Spreadsheets of the Future

Mito

Mito is a free Python package that allows users to integrate a fully functioning spreadsheet into their Jupyter Lab environment. Like any good spreadsheet, you can interactively look at your data, and make all the standard transformations that you would in Excel. Things like filtering, pivoting, and graphing your data is all only a couple clicks away in Mito. And to ensure that you’re able to take the edits that you’ve made to your dataframe with you in the rest of your analysis, every time you make an edit in the Mito spreadsheet, Mito automatically generates the equivalent Python in the code cell below.

https://www.trymito.io/

When doing data analysis in Python, you’re forced to constantly print out the dataframe to validate that the transformations you’ve made are what you expect! By integrating a spreadsheet into your Python analysis, you can have the power of Python with the intuitiveness and conectedness of a spreadsheet.

Mito is great for Python users who want to generate their syntax more quickly, without needing to go to Stack Overflow or google. It is also used by Excel users, who want to transition their skills to Python.

To install Mito, run these commands:

python -m pip install mitoinstaller
python -m mitoinstaller install

Then, run these commands that should appear in Jupyter:

import mitosheet
mitosheet.sheet()

Here are the full install instructions.

https://www.trymito.io/

Rows

Rows is a new age spreadsheet built for teams. Just like any good spreadsheet, it has all the basic Excel functions built in, SUM, VLOOKUP, and SUMIF just to name a few. But where Rows really stands out, is its collaboration and integrations features.

Rows integrates with your data sources like Google Analytics, Salesforce, and LinkedIn search, so you can pull all of your data into your Rows spreadsheet without copying and pasting across multiple spreadsheets. Use their built in connectors to pull and refresh all of your data.

After you’ve created the basic structure of your spreadsheet, you can collaborate with your teammates in real time to finish constructing your dataset.

https://rows.com/features

Clay

Clay was designed specifically for constructing datasets that relies on data from multiple, live updating data sources. Like, Rows, they use the computation of the spreadsheet to pull and refresh your data. They let you see your complete dataset and obscure all of the messy data connection logic behind the scenes.

To help you get started, they have a rich set of Clay templates that will help you connect to your data sources.

Regardless of your work, there is probably a new-age spreadsheet that is being designed specifically for you. Some other interesting projects to check out:

1. StackerHQ — Build custom software that empowers your partners, teammates and customers.
2. Smartsheet — Empower business users to collaboratively create business-driven solutions