Skip to content

How to Download GSTR-2A in Excel

Follow this step-by-step guide to download GSTR-2A in Excel from the GST Portal. Essential for reconciling ITC and verifying supplier filings.

Updated

On this page

GSTR-2A is an automatically generated statement containing input tax credit (ITC) information. This statement shows all purchases made by a taxpayer in a specific period, based on filings from their suppliers. The data in GSTR-2A is automatically populated from the GSTR-1 returns submitted by these suppliers. Currently, taxpayers can only download GSTR-2A on a monthly basis, or if it contains more than 500 invoices. Businesses registered under GST should reconcile their GSTR-2A data with their purchase records to claim the full eligible ITC. Manual reconciliation of GSTR-2A with purchase data can be time-consuming; an automated reconciliation tool can simplify this process.

Steps for Downloading GSTR-2A in Excel Format

Step 1: Access the GST portal using your assigned username and password to log in.

Step 2: After a successful login, navigate to and select the ‘Returns Dashboard’ option.

Step 3: Choose the specific month and financial year for which you intend to download the GSTR-2A in Excel format. Then, locate and click the ‘Download’ tab, which is found within the ‘Auto Drafted details’ section.

Step 4: On the subsequent screen, click the ‘Generate excel file to download’ button to initiate the download in Excel format. Alternatively, you can select the ‘Generate JSON file to download’ button to obtain the file in JSON format. If the Excel option is chosen, the portal may take approximately 20 minutes to process your request.

Step 5: Once the processing is complete, a link titled ‘Click here to download Excel, File 1’ will appear directly below the ‘Generate excel file to download’ button. Click this link to download your file.

Step 6: The requested file will be downloaded from the portal as a zipped folder. Ensure your system has software compatible with .rar or .zip files to decompress it. Finally, unzip the Excel file to access and use your GSTR-2A data.

Need help with GST filing & compliance?

FylFlix experts file your GST returns accurately, claim 100% of eligible ITC and keep you penalty-free — CA-led, AI-reconciled.

Talk to a GST expert →

Frequently Asked Questions

To view your GSTR-2A summary, log into the GST portal, go to the ‘Returns Dashboard,’ select the relevant tax period, and access the summary from the auto-drafted information section.

To open a GSTR-2A JSON file in Excel, you can upload it to an online JSON-to-Excel converter or use an offline utility compatible with Excel 2010 or newer versions for conversion.

For downloading GSTR-2B in Excel for an entire year, use the GST portal to select your GST number and the relevant period, then download the data and export the yearly report in Excel format.

To download all GST returns filed simultaneously, use the GST portal’s functionalities to download individual returns for the desired period.

FAQs on Downloading GSTR-2A

  • What is GSTR-2A?
    An auto-generated statement of Input Tax Credit on your purchases, populated from your suppliers’ GSTR-1 filings. Reconcile it with your purchase records to claim full ITC – see our guide on ITC discrepancies and DRC-01C.
  • How do I download GSTR-2A in Excel?
    Log in to the GST portal, open the Returns Dashboard, select the month and year, go to Auto-drafted details, click Download, choose ‘Generate excel file to download’, then download and unzip the file.
  • How long does the Excel download take?
    The portal can take around 20 minutes to process an Excel request; a ‘Click here to download’ link appears once it is ready.
  • Can I download GSTR-2A in JSON instead of Excel?
    Yes. Choose ‘Generate JSON file to download’ and convert it to Excel using an online converter or an offline utility (Excel 2010 or newer).
  • How often can GSTR-2A be downloaded?
    On a monthly basis, or when it contains more than 500 invoices.

Related reading

NEXT STEP

Get GST returns done by an expert

Same desk that wrote the guide can file it for you.

  • Officially close your GST registration to eliminate recurring return filing obligations. FylFlix offers an automated compliance thermometer to track your…

    From ₹1,9997–30 days

  • Summary Return & Tax Payment (GSTR-3B) — filed with a named professional. Government fees billed separately at cost.

    Get a quote7–15 daysEvent-based

  • File your GST returns accurately, claim 100% of your eligible ITC, and avoid heavy penalties. FylFlix combines expert CA support with AI-driven reconciliation…

    From ₹1,4993–5 daysEvent-based

Most booked

Talk to a CA

Not sure which registration or filing applies to you? Get a plan in 30 minutes.

  • Which entity, licence and tax registrations you actually need
  • Fixed prices and timelines, in writing
  • A checklist of documents to prepare
  • The call fee is adjusted against your first service

Free callback

Request a callback

If we can’t help on the call, we refund it.

NEWSLETTER

Get the next guide in your inbox

One email when we publish something worth your time. No spam, unsubscribe any time.

By sending this you agree to be contacted about your request. We never sell your data.

Focus on your business. We handle the rest.

Book a consultation today — tell us your requirement, get a customized plan, and onboard online.