📋 Data Types Processed
Processes B2B, B2BA (amendments), CDN, CDNA, IMPG, IMPGSEZ, ISD, ECOM, and ECOMA data seamlessly into Excel.
💼 Company Information
Note: Company name will automatically be converted to UPPERCASE format
Upload GSTR-2A JSON/ZIP Files
Drag & drop JSON or ZIP files here or click to browse
💡 Smart Processing
Tracks amendments, flags original docs, and creates categorized sheets (Overview, Purchase, ISD, TDS, TCS) with professional formatting.
Credit Notes: Automatically applies negative values to Doc Value, Item Taxable Value, GST Rate, IGST, CGST, SGST, and Cess for proper accounting.
Company Names: Automatically converts all company names to UPPERCASE format for consistency and professional appearance.
🎨 Professional Formatting
Applies Book Antiqua font, size 9; header bg #034437 with white text; borders and auto-fit columns. Supports ZIP files with nested JSON extraction.
Overview Sheet: Clean layout with merged company header (#034437 background), period ranges (mmm yyyy-mmm yyyy format), and no borders for better presentation.
NEW: Now using ExcelJS for perfect Excel formatting! All styling issues resolved.
GSTR-2A JSON to Excel Converter - Complete Guide
What is GSTR-2A?
GSTR-2A is an auto-populated return that contains details of inward supplies available to a recipient based on the outward supplies filed by the corresponding suppliers in their GSTR-1. This return helps businesses verify their purchase records and claim Input Tax Credit (ITC).
Features of Our GSTR-2A Converter
- B2B Invoice Processing: Converts business-to-business transaction data with complete item-level details
- B2BA Amendment Handling: Processes amendment data with proper tracking of original and amended invoices
- Credit/Debit Note Processing: Handles CDN and CDNA data with automatic negative value application for credit notes
- Import Data Processing: Supports IMPG and IMPGSEZ data for import transactions
- ISD Processing: Input Service Distributor data processing with proper categorization
- TDS/TCS Support: Tax Deducted at Source and Tax Collected at Source data processing
- Professional Excel Formatting: Book Antiqua font, proper borders, header styling with #034437 background
- ZIP File Support: Extract and process multiple JSON files from ZIP archives
How to Use This Tool
- Enter your company name in the input field (will be converted to UPPERCASE automatically)
- Upload your GSTR-2A JSON files or ZIP archives containing JSON files
- Click "Process Files" to convert data to professionally formatted Excel sheets
- Download the generated Excel file with all your GST data organized in separate sheets
Supported Data Types
Our converter supports all major GSTR-2A data categories:
- B2B: Business to Business invoices
- B2BA: B2B amendment records
- CDN: Credit/Debit notes
- CDNA: Credit/Debit note amendments
- IMPG: Import of goods
- IMPGSEZ: Import from SEZ
- ISD: Input Service Distributor
- ECOM: E-Commerce transactions
- ECOMA: E-Commerce amendments
- TDS: Tax Deducted at Source
- TCS: Tax Collected at Source
Why Choose Our GSTR-2A Converter?
- 100% Free to use - No subscription or hidden fees
- Secure processing - No data is stored on our servers
- Professional Excel formatting with industry-standard styling
- Handles complex JSON structures with nested data
- Supports bulk processing of multiple files
- Automatic period range detection and formatting
- Credit note handling with automatic negative value application
- Amendment tracking with original document references
Data Privacy and Security
Your data privacy is our priority. This tool processes all data locally in your browser and does not upload any information to external servers. All processing is done client-side using advanced JavaScript libraries.