Spreadsheet Data Quality Checker
Measure blanks, outer whitespace, repeated values and case inconsistencies that can interfere with matching and reporting.
Analysis
Profile Spreadsheet Columns and Data Types
Profile column types, blanks, uniqueness, maximum text length and sample values before mapping or importing a dataset.
Processing boundary: text and files are handled only for this request. Original files are not overwritten. Generated CSV downloads use expiring private tokens.
What this tool does
A reliable reconciliation begins with understanding the shape of each dataset. The Column Profiler samples every supported field and reports the detected type, row count, blank count, unique-value count, maximum observed text length and a few readable examples. These measures help distinguish identifiers from descriptions, find unexpectedly empty fields and decide which columns need normalization. The profiler is especially useful before schema mapping, database import or the selection of a matching key.
How to use it
- Choose a CSV, TSV or XLSX file.
- Run the profiler.
- Review type, completeness and uniqueness before selecting mapping or key columns.
Limitations and review points
Type detection is based on sampled cell text and does not read Excel formatting rules. Mixed columns may be classified as text even when many values resemble numbers or dates.
Frequently asked questions
Does it read cell formatting?
No. Delivery 1 profiles stored values, not workbook display formats.
What does unique-value count show?
It shows how many distinct normalized non-blank values appear in the column.
Can it suggest a key?
Use the Key Column Finder, which scores uniqueness and completeness together.
Related spreadsheet tools
Key Column Finder
Score spreadsheet columns by completeness and uniqueness to identify likely employee, invoice, asset or transaction keys.
Smart Schema Mapper
Suggest column mappings between two files using normalized header names, business synonyms and sampled data types.