How to extract data from GST portal?

Asked by: Marjolaine Thompson  |  Last update: August 20, 2026
Score: 4.8/5 (55 votes)

Data can be extracted from the GST Portal (www.gst.gov.in) by logging in and navigating to the 'Returns Dashboard' to download GSTR-1, 2A, 2B, or 3B, typically in JSON or Excel formats. Key reports like GSTR-2B (input tax credit) can be downloaded by selecting the financial year and period, then clicking the download button.

How to download data from GST portal?

Step 1: Log in to the GST portal with your username and password. Step 2: After logging, select 'Returns Dashboard' as shown below. Step 3: Select the month & financial year for which you want to download GSTR-2A in excel. Click on the 'Download' tab appearing in the 'Auto Drafted details' box.

How do I export data from the GST portal to excel?

Export GSTR-1 in Excel format

  1. Press Alt+E (Export) > E-Return.
  2. Select the File Format as Excel (Spreadsheet).
  3. Set Export document summary to Yes.
  4. Export the file.
  5. Open the GSTR-1 offline tool downloaded from the GST portal. Import the MS Excel file into the GST Offline Tool.

How to access GST data?

Manual > View Filed Returns

  1. Access the https://www.gst.gov.in/ URL. ...
  2. Login to the GST Portal with valid credentials.
  3. Click the Services > Returns > View Filed Returns option.
  4. Select the Financial Year, Return Filing Period and Return Type from the drop-down list. ...
  5. Click the SEARCH button. ...
  6. The search results are displayed.

How to get e-invoice data from GST portal?

1. To download the e-Invoice, visit https://einvoice.gst.gov.in and login with valid GST credentials. Click on Download e-invoice JSONs tile on the dashboard. Alternatively, taxpayer can navigate download e-Invoice by clicking Dashboard tile > e-Invoice Download tab.

How to download GSTR 1 from GST portal in excel | download gstr-1 all data in excel | 2021

29 related questions found

How to download GSTR-1 invoice wise details in Excel from GST portal?

You can download the E-invoice details that get auto-populated in Form GSTR-1 in an excel by clicking the DOWNLOAD DETAILS FROM E-INVOICES (EXCEL) button available at the bottom of Form GSTR-1 page.

How to download e-invoice Excel utility from GST portal?

To view and download an e-Invoice list in Excel format for a specific period, utilize the "List of IRNs" tab. Select the desired Financial Year and Month, then click the "DOWNLOAD E-INVOICE (Excel)" button.

How to download GST query?

To view additional orders or notices issued by the GST tax officer, follow these steps:

  1. Step 1: Access the GST Portal. ...
  2. Step 2: Login to the GST Portal. ...
  3. Step 3: Navigate to the Additional Notices/Orders Page. ...
  4. Step 4: View Additional Orders and Notices. ...
  5. Step 5: Access the Case Details. ...
  6. Step 6: View and Download Case Details.

How to get GST API access?

How to enable GST API Access on GST Portal?

  1. Step 1: Log in to the GST portal and navigate to the 'My profile' section.
  2. Step 2: Under the quick-links panel, select 'Manage API access'.
  3. Step 3: Click 'Yes'.
  4. Step 4: Duration dropdown will be displayed. Select the desired duration and click confirm.

How to access Invoice management system in GST portal?

Login to the GST Portal with valid credentials. Click the Services > Returns > Invoice Management System (IMS) option. 2. Invoice Management System (IMS) dashboard will be displayed on the screen.

Can Excel create GST reports?

GST Tool Compatible

GST Reports are generated in excel formats that GST Offline tool recognises.

How to convert invoice data to Excel?

1. Excel's built-in PDF import feature

  1. Open Excel and create a new workbook.
  2. Go to the 'Data' tab and click 'Get Data'
  3. Select 'From File' and then 'From PDF'
  4. Browse and select your PDF invoice.
  5. In the Navigator window, choose the tables or pages you want to import.
  6. Select the appropriate delimiter in Excel's preview.

How to generate GST report?

Generating India GST Reports

  1. Go to Reports > Tax > Country Tax Reports.
  2. In the Subsidiary field, select a subsidiary from the list.
  3. In the Nexus field, select a nexus from the list. ...
  4. In the Start Period field, select the starting period for the report.
  5. In the End Period field, select an end period for the report.

How to export data from GST offline tool to Excel?

Go to Menu > Consolidated Data > GST Form (Offline Tool) > Export GSTR1 (Excel). A new window of Export GSTR1 (Excel) will appear in next slide.

How to access GST portal?

As a new taxpayer, to login first time to the GST Portal with GSTIN and password, you need to perform the following steps:

  1. Access the URL https://www.gst.gov.in/. ...
  2. Click the Login link given in top right-hand corner of the GST Home page.
  3. The Login page is displayed. ...
  4. The New User Login Page is displayed.

How to download IMS data from GST portal?

First, let us understand IMS guide for recipients to access the IMS dashboard on GST portal to review inward supplies.

  1. Step 1: Log in to the GST Portal. ...
  2. Step 2: Navigating the Recipient Dashboard. ...
  3. Step 3: Taking Action on Invoices. ...
  4. Step 4: Downloading IMS records in Excel Format. ...
  5. Step 5: Reset Action on IMS Invoices.

Is GST API free?

The cost of using the GST Verification API is typically based on the number of API calls or requests made. Some providers may offer tiered pricing plans based on usage levels.

How to get GST data of any company?

Access the www.gst.gov.in URL. The GST Home page is displayed. 2.1.1 Click the Search Taxpayer menu available at the GST Portal homepage. 2.1.2 In the GSTIN/UIN of the Taxpayer field, enter the GSTIN or UIN of the taxpayer whose details has to be searched.

How to download GST from GST portal?

Manual > View/ Download Certificates

  1. Access the www.gst.gov.in URL. The GST Home page is displayed.
  2. Login to the GST Portal with valid credentials.
  3. Click the Services > User Services > View/Download Certificates command. ...
  4. The Registration certificate is downloaded in the PDF format.

How to download Invoice data from GST portal?

Step 1: Log in to the e-invoice portal https://einvoice.gst.gov.in with valid GST login credentials. Step 2: On the 'Download e-Invoice' page, there are two tabs 'Generated' (for IRNs generated by the user) and 'Received' (for IRNs received by the user). Click on whichever applies to you.

What is the new rule of GST?

The New GST Rate Structure

The old four-slab structure (5%, 12%, 18%, 28%) has been simplified. The 12% and 28% slabs were eliminated and replaced with a new structure, which is now primarily 0%, 5%, 18%, and a 40% rate for luxury and “sin” goods.

How to download utility from GST portal?

Steps to Download the Offline Tool

  1. Visit the official GST portal at www.GST.gov.in.
  2. Navigate to the “Downloads” section from the main menu.
  3. Select “Offline Tools” from the dropdown options.
  4. Choose your required return type (GSTR-1/GSTR-3B/GSTR-9, etc.).
  5. Download the corresponding ZIP file.

How to generate GST bill in Excel?

Steps to create GST Invoice Format in Excel

  1. Step 1: Go to your Microsoft Excel. Click File -> New. ...
  2. Step 2: Fire Gridlines. ...
  3. Step 3: Add the requirements like logo & other details. ...
  4. Step 4: Include customer information. ...
  5. Step 5: Include the Transaction Details. ...
  6. Step 6: Issue the Payment Details.

How to download e-way bill data from GST portal?

How to download e-way bill history?

  1. Step 1: Log in to the e-way portal using ID, password and captcha verification procedures.
  2. Step 2: Search the specific e-way bill history you are looking for and get the e-way number from the report.
  3. Step 3: Go to the 'Print EWB' tab under 'e-waybill' dropdown menu.