Guides
Spreadsheet cleaning, explained
Practical, people-first how-tos for the messy-spreadsheet problems you actually get stuck on — each shows the native Excel method done right, then hands you into the exact tool, pre-set for your file.
Reshape
Split an Excel Sheet Into Multiple Files Based on a Column Value
Split one Excel sheet into a separate file (or worksheet tab) for each value in a column — by hand with filters, with a PivotTable's Show Report Filter Pages, with Power Query, or in one step with TidyCell. A worked Region example, the native methods done right, and the safety pitfalls.
Opens Split SheetsComing soon
More guides on the way
We publish a new guide as each one is written — currency-as-text, remove duplicates, standardize dates and more. Each will slot straight into this grid.
Every guide is a small how-to that hands you straight into the right tool. Fewer tools, many entry points.