F
Selecting a set of cells across a handful empty columns in Rowboat to form a smiley face.
Selecting a set of cells across a handful empty columns in Rowboat to form a smiley face.
k
Rowboat: Summer Update
We’ve made a lot of updates to Rowboat since the—checks calendar—nine months since we last posted, and we’d love to tell you about them!

One of the biggest changes we’ve made is that you can now select columns, rows, and cells to apply an action to multiple slices of your data at once. Not exactly the flashiest thing (pretty sure even VisiCalc had selection), but we think you’ll find it’s a nice tweak to the overall experience of using the app.

Building a product is all about getting the right balance of features: we don’t want to create another spreadsheet (it’s been done), and we’re not looking to create another data cleanup tool (there are too many), but we do need some of those features, so what’s the right amount? We’re making something new but it also needs to feel familiar.

How about some quick examples?

Select rows to hide bad data, or non-data rows:

Video of 97 rows containing errors being selected and then hidden within Rowboat.
Step one with a new dataset: open in Rowboat to see what’s inside.
Step two: hide the data that’s not relevant.

Select columns to take the same action on all of them, like turning on these inline representations:

Video of multiple columns being selected within Rowboat. The inline representation feature is then applied to all selected columns.
One of our most under-utilized features: inline representations break up cells by category and color, making it easy to glance at a column and see what's similar and different.

Select cells to copy their contents:

Video of a set of cells being selected in Rowboat, copied with the Command+C keyboard shortcut, and then pasted into an empty Google Sheets spreadsheet.
Rowboat is a means, not an end: getting data in—and back out—is always a priority.

We’ve also been working on some other features that can help with light clean-up.

Double-click cells to edit their values directly:

Video filtering down to all errors within a single column, and then editing each error by removing an unnecessary apostrophe at the end of each cell entry.
Lightweight data cleanup and editing, even with massive datasets, but without the need for a complicated data cleanup workbench.

Use the in-column Find and Replace to replace text:

Video using the Find and Replace feature in Rowboat to find all cells containing an unnecessary close parenthesis symbol and remove the parenthesis.
If there’s Find and Replace, can regular expressions be far behind? Stay tuned.

These are just a few of the things we’ve implemented these past few months (we post more regular updates on our releases page), but we’ve really been enjoying these updates in our other day-to-day work. Check them out with Rowboat Web or Rowboat Desktop, and let us know how it goes! We love hearing your feedback.

Katherine, Ben, and the rest of the crew

P.S. Please enjoy this Easter egg of a demo that our intern, Rahul, found while playing with the new features.

Video of our intern Rahul selecting a set of cells across a handful empty columns in Rowboat to form a smiley face.
This is what a Harvard education will get you.

We’d love to hear what you’re working on, what you’re curious about, and what messy data problems we can help you solve. Drop us a line at hello@fathom.info, or you can subscribe to our newsletter for updates.