Spreadsheet Analysis
Inspect workbook structure, formulas, duplicates, missing values, dimensions and data quality signals. 25 tools are currently live in this section.
Excel Worksheet List
List every worksheet and its visible, hidden or very-hidden state.
Open tool →Excel Used Range Analyzer
Report the used range and maximum row and column for every worksheet.
Open tool →Excel Row Counter
Count non-empty and used-range rows for each worksheet.
Open tool →Excel Column Counter
Count used-range columns for each worksheet.
Open tool →Excel Non-Empty Cell Counter
Count cells containing values across the workbook.
Open tool →Excel Formula Counter
Count formula cells by worksheet and across the entire workbook.
Open tool →Excel Error Cell Counter
Count cells containing Excel error values such as #DIV/0! or #VALUE!.
Open tool →Excel Blank Cell Counter
Count blank cells inside each worksheet used range.
Open tool →Excel Merged Cell Counter
Count merged ranges in each worksheet.
Open tool →Excel Hyperlink Counter
Count cells with hyperlinks across the workbook.
Open tool →Excel Comment Counter
Count cell comments and notes in each worksheet.
Open tool →Hidden Excel Sheet Finder
List hidden and very-hidden worksheets in an XLSX workbook.
Open tool →Hidden Excel Row Counter
Count hidden rows on every worksheet.
Open tool →Hidden Excel Column Counter
Count hidden columns on every worksheet.
Open tool →Duplicate Excel Row Finder
Find duplicate non-empty rows in a selected worksheet.
Open tool →Duplicate Excel Value Finder
Find repeated values in a selected column by letter or header name.
Open tool →Excel Numeric Column Summary
Calculate count, minimum, maximum, mean, median and sum for one numeric column.
Open tool →Unique Excel Values
List unique non-empty values from one selected worksheet column.
Open tool →Excel Value Frequency Table
Build a frequency table for values in a selected worksheet column.
Open tool →Excel Missing Values by Column
Report blank-cell counts and percentages for each used column in a worksheet.
Open tool →Excel Data Type Profile
Profile text, numeric, date, boolean, formula, error and blank cells by worksheet.
Open tool →Excel Formula List
List formula cells with worksheet names, coordinates and formulas.
Open tool →Excel Named Range List
List workbook defined names and their target expressions.
Open tool →Excel Workbook Properties
Read workbook creator, title, subject, keywords, category and date properties.
Open tool →Excel Workbook Summary Report
Generate a workbook-wide summary of sheets, dimensions, cells, formulas, comments, hyperlinks and hidden content.
Open tool →About Spreadsheet Analysis
Inspect workbook structure, formulas, duplicates, missing values, dimensions and data quality signals. MediaZuno groups closely related utilities together so you can move between tasks without hunting across different websites.