Your Excel at a glance
Data Quality
Needs some attention
A simple score based on missing information and possible duplicates.
Mostly-empty columns (Remarks) are not counted towards completeness.
Your Data 6 charts chosen automatically
Interesting Findings
Missing information
453 records (36.3%) have at least one missing field. The column with the most gaps is “Payment Date” (309 empty).
Possible duplicates
18 records appear to be possible duplicates (repeated values in “Mobile”, “Email”).
Top state
9 different values found in “State”. “Delhi” has the most records (284, 22.8%).
Membership Type split
55.8% of records are “Annual”, followed by “Life” (24.8%).
Amount total
The “Amount” column totals ₹31,20,000 across 1,248 entries (average ₹2,500).
Busiest period
Dec 2025 was the month with the highest total value (₹4,71,500).
Date range
Records run from 01 Oct 2025 to 27 Sep 2026.
Inconsistent spellings
“State” has the same value written in different ways (e.g. “Delhi” / “delhi”). A system with fixed choices avoids this.
Mostly empty columns
1 column(s) are at least half empty: “Remarks”.
These observations come from straightforward calculations on your data — counts, totals and comparisons.
How each column was understood (13)
| Column | Type | Filled | Missing | Unique | Summary |
|---|---|---|---|---|---|
| Member ID | Identifier | 1,248 | 0 | 1,248 | — |
| Name | Text | 1,248 | 0 | 523 | — |
| Gender | Category | 1,248 | 0 | 2 | Most common: Male (52.9%) |
| Batch | Category | 1,239 | 9 | 39 | Most common: 2011 (3.9%) |
| State | Category | 1,248 | 0 | 9 | Most common: Delhi (22.8%) |
| District | Category | 1,236 | 12 | 28 | Most common: New Delhi (6.6%) |
| Mobile | Identifier · phone | 1,177 | 71 | 1,160 | — |
| Identifier · email | 1,142 | 106 | 1,125 | — | |
| Membership Type | Category | 1,248 | 0 | 4 | Most common: Annual (55.8%) |
| Payment Status | Category | 1,248 | 0 | 3 | Most common: Paid (75.2%) |
| Amount | Number · amount | 1,248 | 0 | 5 | Min ₹0 · Max ₹10,000 · Avg ₹2,500 · Total ₹31,20,000 |
| Payment Date | Date | 939 | 309 | 295 | 01 Oct 2025 → 27 Sep 2026 |
| Remarks | Category | 41 | 1,207 | 4 | Most common: Will pay next month (36.6%) |
How we read your sheet (first 5 rows)
Headings were taken from the first row.
| Member ID | Name | Gender | Batch | State | District | Mobile | Membership Type | Payment Status | Amount | Payment Date | Remarks | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ALM1971 | Sneha Gupta | Female | 2005 | Jharkhand | Dhanbad | 9858220606 | sneha.gupta107@example.com | Patron | Paid | 10000 | 12 Dec 2025 | |
| ALM1783 | Ishaan Thakur | Female | 2015 | Uttar Pradesh | Noida | 9808921734 | ishaan.thakur855@example.com | Annual | Paid | 1000 | 21 Oct 2025 | |
| ALM1374 | Vivaan Chauhan | Female | 1998 | Rajasthan | Jaipur | 9193174425 | vivaan.chauhan101@example.com | Annual | Paid | 1000 | 10 Sep 2026 | |
| ALM1715 | Rahul Agarwal | Female | 2018 | Uttar Pradesh | Varanasi | 9993952768 | rahul.agarwal167@example.com | Life | Paid | 5000 | 24 Nov 2025 | |
| ALM1921 | Aditya Srivastava | Male | 1999 | Uttar Pradesh | 9380925745 | aditya.srivastava620@example.com | Annual | Paid | 1000 | 14 Nov 2025 |