New Spreadsheet Tool Lets You Reshape Data Without Losing Your Charts

If you have ever stared at a spreadsheet trying to find a pattern, you know the drill: sort the rows, build a chart, then go back and change the filter — and your chart breaks. You rebuild it. You copy numbers into a second tool. You lose track of which version was the real one. It is slow, and it is where a lot of workplace frustration lives.

A research team has built a prototype called MuTable that tries to fix this. The idea is simple to describe: every change you make to a table — grouping rows, filtering, reordering — is saved as a separate, reusable step. You can stack those steps like building blocks, keep several versions going at once, and try out a new question without throwing away your earlier work. Your chart updates in place instead of being rebuilt from scratch. The researchers call this "in-situ" exploration, meaning you stay in one place rather than hopping between the table view and the chart view.

The team interviewed eight people who work with data professionally. Those users said the tool helped them move faster, keep their charts and numbers in sync, and feel more in control of the charts they made — treating the whole thing as a low-stakes space to poke around. The work was accepted at UIST, a respected academic conference on user interfaces.

The catch: this is a research prototype, not a product you can download. It was tested with only eight people, and there is no word yet on whether a company will turn it into real software. Still, the direction matters. Most spreadsheet pain comes from tools that force you to choose between precise numbers and visual patterns. Anything that lets you have both at once is worth watching.