Spreadsheet tools

Tidy a spreadsheet in one pass: trim stray and invisible spaces, fix numbers stored as text, drop empty rows and columns, remove duplicates, tidy column names.

Find every difference between two versions of a spreadsheet: added, removed and changed rows, cell by cell, in a highlighted workbook.

Convert between Excel (.xlsx, .xls, .xlsb), OpenDocument, CSV, TSV and JSON, keeping numbers, dates and codes such as 00123 exactly as they are.

See what is inside a spreadsheet: every sheet (hidden ones too), rows, columns, column types and empty cells, and a CSV's encoding and delimiter.

Combine spreadsheets or sheets into one: stack their rows with columns matched by name, or gather them as the sheets of one workbook.

Understand a dataset in seconds: each column's type, blanks, distinct values, ranges, averages, most common values, and problems such as numbers stored as text.

Split a spreadsheet into several files: every N rows, one per value of a column (say, one per region), or one per sheet.