GSTIN → PAN Extractor (Free): Format Guide, Excel Formula & Online Tool
PAN-Extractor by Amrut — GSTIN → PAN tool with PAN type & CSV export. Join 450+ smart finance subscribers on Learn With Amrut.
The GSTIN (Goods & Services Tax Identification Number) was introduced in July 2017 with India’s GST rollout. It is a 15-character alphanumeric code that uniquely identifies every GST-registered taxpayer. Knowing its structure helps you validate entries and quickly extract the PAN embedded within.
| Position | Meaning | Example |
|---|---|---|
| 1–2 | State Code | 27 = Maharashtra |
| 3–12 | PAN of Taxpayer (10 chars) | ABCDE1234F |
| 13 | Entity Code (1=first registration on that PAN in the state, 2=second, …) | 1 |
| 14 | Default character | Always Z |
| 15 | Checksum | Validates entry |
27ABCDE1234F1Z5
Why extract PAN from GSTIN?
- Reconciliation: Match vendor/customer masters quickly during audits.
- Compliance: Ensure name–PAN–GSTIN consistency in ledgers and TDS/TCS mapping.
- Data hygiene: Clean master data without opening multiple portals.
Formulas & Online Tool
How to Get PAN from GSTIN
Option A — Excel / Google Sheets Formula ?
Assume GSTIN is in B2 (e.g., 27ABCDE1234F1Z5). Only basic Excel/Sheets skills needed.
| Extract PAN (positions 3–12) | Formula | |
|---|---|---|
Returns the 10-char PAN from GSTIN in B2. |
=MID(B2, 3, 10) |
| PAN Type letter | Formula | |
|---|---|---|
| Takes 4th char of PAN (overall GSTIN position 6). Map: P=Individual, C=Company, H=HUF, F=Firm/LLP, A=AOP, T=Trust, B=BOI, L=Local Authority, J=AJP, G=Government | =MID(B2, 6, 1) |
| Google Sheets — fill down entire column | Formula | |
|---|---|---|
Auto-extract PAN for all GSTINs in column B. |
=ARRAYFORMULA(IF(B2:B="","",MID(B2:B,3,10))) |
Option B — Use the Online Tool on This Page ?
- Paste GSTINs (one per line) into the input box below.
- Click Extract to get PAN, PAN Type, Entity Code & format check.
- Use Copy CSV or Download CSV to move data to Excel/Sheets.
- Runs locally in your browser — no data upload.
GSTIN → PAN Extractor
| # | GSTIN | PAN | PAN Type | Entity Code (13th) | Format Check |
|---|---|---|---|---|---|
| Results will appear here after extraction. | |||||
Note: This utility validates the format of GSTIN and derives PAN + PAN type on the client. It does not query GSTN servers.
⭐ FAQs on GSTIN & PAN Extraction
1. Is this tool legal to use?
Yes, GSTIN structure is public information under GST law. This tool only extracts the PAN portion using a mathematical formula — no database lookup or portal scraping is done.
2. How accurate is the PAN extraction?
100% accurate as long as the GSTIN is valid — positions 3–12 are always the PAN by design.
3. Can I check if the GSTIN itself is active?
No, this tool only validates the format. For real-time status, use the official GST portal Search Taxpayer option.
4. Can I use this in my office?
Yes, it is built for accountants and auditors. Data never leaves your browser, so it is safe for client use.
About This Utility
This free GSTIN → PAN extractor was developed by Amrut Chitragar for accountants, auditors, and business owners who often need to match GSTINs with PANs quickly. It is designed for professional use and runs entirely in your browser — no data upload, safe for client information.
If you find it useful, please share this page with your colleagues and friends so they can also save time during reconciliation and compliance work. Thank you for supporting Learn With Amrut and helping spread financial literacy!