Follow Us:

Instructions to use GSTR-1 PDF to EXCEL Extraction Tool

1. Kindly check your EXCEL version before using this tool it  shall be 2016,2019,2021 or office 365.

2. Save all GSTR-1 Final PDFs in a separate folder on your desktop, not in cloud storage (Eg. Google Drive, One Drive etc.)

3. Don’t save any other files except GSTR-1 Final PDFs in a folder

4. PDF name should be in the same format as you downloaded from Portal i.e. (GSTR-1_GSTIN_MMYYYY)

5.  Copy the folder location where you saved all PDFs by using these Shortcuts (alt+d)(ctrl+c) then paste this on the yellow cell then click on GSTR-1 Button For Extraction.

Also Read: Optimise your reports: Convert Excel data to PDF with ease

Access Denied! Only Regstered Users Can Download The File "GSTR-1 PDF to EXCEL Extraction Tool". Register Here or Login

Author Bio

⮚ Developed multiple automation tools and authored professional articles across GST, Income Tax, and Customs domains, collectively exceeding 200,000+ views on TaxGuru contributing to knowledge-sharing and process efficiency within the CA community ⮚ Designed and implemented automati View Full Profile

My Published Posts

Automatic GSTR-2B Consolidation Tool in Excel BOE pdf to Excel (HSN wise) Conversion and consolidation tool 26AS text to Excel Converter Tool GSTR-2A/2B vs Books Reconciliation Tool TDS payment challan PDF to Excel conversion and consolidation Tool View More Published Posts

Join Taxguru’s Network for Latest updates on Income Tax, GST, Company Law, Corporate Laws and other related subjects.

5 Comments

  1. MANI DEEPAK says:

    Kindly check the Excel version you are using it is not working in older versions.
    It tested in the 2019 version,2021 version, and Office 365 Version and follow the above-mentioned steps for Extracting Data from GSTR-1 Pdfs

Leave a Comment

Your email address will not be published. Required fields are marked *

Ads Free tax News and Updates
Search Post by Date
May 2026
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031