Skip to content
TheSpreadFix

Validate PAN Numbers in Bulk

Upload a CSV or Excel file with a PAN column and validate every entry against the 10-character format: five uppercase letters, four digits and one uppercase letter. Invalid lengths, wrong character positions and impossible entity-type codes are flagged with the specific error. Your file is processed in your browser.

Drop a CSV or Excel file here

.csv, .xlsx, .tsv

Your file stays on your device. Validation runs in your browser — nothing is uploaded.

How it works

  1. Step 1

    Upload your file

    CSV or XLSX. The PAN column is detected from its name or from 10-character alphanumeric patterns in the data.

  2. Step 2

    See what's invalid

    Each PAN is checked for length, character-position rules and valid entity type. Errors name the exact problem.

  3. Step 3

    Download results

    Get the full file with a validation column, or just the invalid rows for correction.

What it checks and fixes

Length check

PAN must be exactly 10 characters. Truncated (9) or padded (11+) entries are flagged.

Character positions

Positions 1–5 must be letters, 6–9 must be digits, position 10 must be a letter. Digit-in-letter or letter-in-digit positions are reported.

Entity type code

The 4th character encodes the type of PAN holder. Valid codes are: P (Individual), C (Company), H (HUF), A (AOP), B (BOI), G (Government), J (Artificial Juridical Person), L (Local Authority), F (Firm/LLP), T (Trust).

Common typos

O/0, I/1, S/5 confusion, lowercase letters, spaces and hyphens within the value.

PAN format structure

A Permanent Account Number is a 10-character alphanumeric identifier issued by the Income Tax Department of India. Each position carries meaning:

PositionCharacter typeMeaning
1–3Three lettersAlphabetical series (AAA–ZZZ), assigned sequentially
4One letterEntity type: P = Individual, C = Company, H = HUF, A = AOP, B = BOI, G = Government, J = AJP, L = Local Authority, F = Firm/LLP, T = Trust
5One letterFirst letter of the surname (for individuals) or entity name (for others)
6–9Four digitsSequential number (0001–9999)
10One letterCheck letter (computed from the first 9 characters)

Example: ABCPD1234E — series ABC, entity type P (Individual), surname initial D, sequence 1234, check letter E.

The 4th character: entity type codes

The 4th letter of a PAN tells you what kind of entity holds it. This is useful for validation beyond just format checking — if your vendor master says 'Company' but the PAN's 4th letter is P (Individual), something is wrong.

CodeEntity type
PIndividual (Person)
CCompany
HHindu Undivided Family
AAssociation of Persons
BBody of Individuals
GGovernment Agency
JArtificial Juridical Person
LLocal Authority
FFirm / Limited Liability Partnership
TTrust

Any other letter in the 4th position means the PAN is invalid.

Common PAN data problems

  • Truncated values — copy-paste errors that lose the last character, leaving 9 characters instead of 10.
  • Letter/digit confusion — O typed as 0, I as 1, or vice versa. Position-aware validation catches these because letters can't appear in positions 6–9 and digits can't appear in positions 1–5 or 10.
  • Lowercase input — PAN is always uppercase. The validator normalises case before checking but flags the original as needing correction.
  • Spaces and hyphens — 'ABC PD 1234 E' or 'ABCPD-1234-E' pass visual review but fail system validation.
  • Dummy values — 'AAAAA0000A' or similar repetitive patterns are technically valid format but likely placeholder data.

Why PAN validation matters for business data

PAN is required on invoices above Rs 50,000, on TDS certificates (Form 16/16A), and for vendor onboarding under Section 206AB (higher TDS for non-filers). An incorrect PAN means TDS is deducted at a higher rate, GST input credit may be disallowed (since PAN is embedded in GSTIN), and your TDS return filing will show mismatches.

Validating PAN format before submitting to TRACES or your accounting system catches the errors that would otherwise come back as challan mismatches or PAN-name mismatch notices.

Frequently asked questions

Does this verify PAN against the Income Tax database?

No. It checks the 10-character format, valid entity type and character positions. Verifying that a PAN is issued, active and matches a name requires an Income Tax or TRACES portal lookup.

Can it distinguish between individual and company PANs?

Yes. The 4th character indicates the entity type — P for Individual, C for Company and so on. The validator reports the entity type for each valid PAN.