GSTR 1 format in Excel and pdf | Download and Convert JSON in offline mode

File GSTR 1 return by using offline excel tool. This xls format enables you to fill outward supply data easily. You can prepare GSTR 1 return in offline mode and generate JSON file. Later, the JSON file needs to be uploaded on GST portal to file the return. Click below to Download GSTR 1 format in excel to prepare GSTR 1. Also, now you can convert your JSON of GSTR 1 into the Excel file.

gstr 1

Read how to Install GSTR 1 offline tool on your computer.  Similarly, learn how to prepare and file GSTR 1 in offline mode. GSTR 1 offline format will save your lot of time and internet usage than that actual online filing on GST portal. Thus GSTR 1 format in excel plays a very important role for filing return under Goods and service tax in India.

gstr1 format in excel image

Download GSTR 1 Format in pdf

You may download GSTR 1 format in pdf format for offline use.  This GSTR 1 form in pdf format is as per GST rules.  Click on below link to download GSTR 1 in pdf format. 

GSTR 1 Format Filing Instructions

Here are the GSTR 1 filing instructions as per CGST rules. However, the actual filing steps may vary for GSTR 1 offline filing and GSTR 1 online filing process. You will find GSTR 1 filing instructions in above GSTR 1 format in excel once you download it.
1. Terms used:
a. GSTIN: Goods and Services Tax Identification Number
b. UIN: Unique Identity Number
c. UQC: Unit Quantity Code
d. HSN: Harmonized System of Nomenclature
e. POS: Place of Supply (Respective State)
f. B to B: From one registered person to another registered person
g. B to C: From registered person to unregistered person
2.The details in GSTR 1 shall be furnished by 10thof the month succeeding the relevant tax period. Check GSTR 1 due date from here.
3.The Aggregate turnover of the taxpayer for the immediate, preceding financial year and first quarter of the current financial year shall be reported in the preliminary information in Table 3.

This information would be required to be submitted by the taxpayers only in the first year.
Quarterly turnover information shall not be captured in subsequent returns. Thus, Aggregate turnover shall be auto-populated in subsequent years.
4.Invoice-level information pertaining to the tax period should be reported for all supplies as under:

(i) For all B to B supplies (whether inter-State or intra-State), invoice level details, rate-wise, should be uploaded in Table 4, including supplies attracting the reverse charge and those effected through e-commerce operator. Outwards supply information in these categories are to be furnished separately in the Table.

(ii) For all inter-State B to C supplies, where invoice value is more than Rs. 2,50,000/- (B to C Large) invoice level details, rate-wise, should be uploaded in Table 5; and

(iii) For all B to C supplies (whether inter-State or intra-State) where invoice value is up to Rs. 2,50,000/ – State-wise summary of supplies, rate-wise, should be uploaded in Table 7.
5.Table 4 capturing information relating to B to B supplies should:
(i) be captured in:

a. Table 4A for supplies relating to other than reverse charge/ made
through e-commerce operator, rate-wise;

b. Table 4B for supplies attracting the reverse charge, rate-wise; and

c. Table 4C relating to supplies effected through e-commerce operator attracting the collection of tax at source under section 52 of the Act,
operator wise and rate-wise.

(ii) Capture Place of Supply (PoS) only if the same is different from the location of the
6.Table 5 to capture information of B to C Large invoices and other information shall be similar to Table 4. The Place of Supply (PoS) column is mandatory in this table.
7.Table 6 to capture information related to:
(i) Exports out of India
(ii) Supplies to SEZ unit/ and SEZ developer
(iii) Deemed Exports
8.Table 6 needs to capture information about the shipping bill and its date. However, if the shipping bill details are not available, Table 6 will still accept the information.

However, the same can be updated through the submission of information in
relation to amendment Table 9 in the tax period in which the details are available but before claiming any refund/rebate related to the said invoice.

Further, the detail of Shipping Bill shall be furnished in 13 digits capturing port code (six digits) followed by the number of shipping bill.
9.Any supply made by SEZ to DTA, without the cover of a bill of entry is
required to be reported by the SEZ unit in GSTR -1. Also, the supplies made by SEZ on the cover of a bill of entry shall be reported by DTA unit in its GSTR-2 as imports in GSTR-2. Similarly, the liability for payment of IGST in respect of the supply of services would Besides be created from this Table.
10.In case of export transactions, GSTIN of the recipient will not be there. Hence it will remain blank.
11.Export transactions effected without payment of IGST (under Bond/ Letter of Undertaking (LUT)) needs to be reported under ―0‖ tax amount heading in Table 6A and 6B.
12.Table 7 to capture information in respect of the taxable supply of:
(i)B to C supplies (whether inter-State or intra-State)with invoice value uptoRs 2,50,000;

(ii)Taxable value net of debit/credit note raised in a particular tax period and information pertaining to previous tax periods which was not reported earlier, shall be reported in Table 10. The Negative value can be mentioned in this table, if required;

(iii)Transactions effected through e-commerce operator attracting the collection of tax at source under section 52 of the Act to be provided operator wise and rate wise;

(iv)Table 7A (1) to capture gross intra-State supplies, rate-wise, including supplies made through e-commerce operator attracting the collection of tax at source and Table 7A (2) to capture supplies made through e-commerce operator attracting the collection of tax at source out of gross supplies reported in Table 7A (1);

(v)Table 7B (1) to capture gross inter-State supplies including supplies made through e-commerce operator attracting the collection of tax at source and Table 7B (2) to capture supplies made through e-commerce operator attracting the collection of tax at source out of gross supplies reported in Table 7B (1); and

(vi)Table 7B to capture information State wise and rate wise.
13.Table 9 to capture information of:(i)Amendments of B to B supplies reported in Table 4, B to C Large supplies reported in Table 5 and Supplies involving exports/ SEZ unit or SEZ developer/ deemed exports reported in Table 6;

(ii)Information to be captured rate-wise;

(iii)It also captures original information of debit/credit note issued and amendment to it reported in earlier tax periods; While furnishing information the original debit note/credit note, the details of invoice shall be mentioned in the first three columns, While furnishing revision of a debit note/credit note, the details of original debit note/credit note shall be mentioned in the first three columns of this Table,

(iv)Place of Supply (PoS) only if the same is different from the location of the recipient;

(v)Any debit/ credit note pertaining to invoices issued before the appointed day under the existing law also to be reported in this table; and

Shipping bill to be provided only in case of exports transactions amendment.
14.Table 10 is similar to Table 9 but captures amendment information related to B to C supplies and reported in Table 7.
15.Table 11A captures information related to advances received, rate-wise, in the tax period and tax to be paid thereon along with the respective PoS.
It also includes information in Table 11B for adjustment of tax paid on advance received and reported in earlier tax periods against invoices issued in the current tax period.
The details of information relating to advances would be submitted only if the invoice has not been issued in the same tax period in which the advance was received.
16.Summary of supplies effected against a particular HSN code to be reported only in summary table.
It will be optional for taxpayers having annual turnover uptoRs. 1.50 Cr but they need to provide information about the description of goods.
17.It will be mandatory to report HSN code at two digits level for taxpayers having the annual turnover in the preceding year above Rs. 1.50 Cr but uptoRs. 5.00 Cr and at four digits level for taxpayers having the annual turnover above Rs. 5.00 Cr
*Note: Beside this you will find actual instructions of filing in GSTR 1 format in excel. Please download the format from above link.

GSTR 1 JSON to Excel Converter

You may want to convert the downloaded GSTR 1 .json file from the GST portal into the excel sheet. There may be a number of online tools available which may convert your JSON file to excel. However, these may not give you the exact data the way you want. Also, sometimes you may not want to upload your JSON file on the third-party website containing the important data. You can extract the JSON file data as shown in the below image by using MS Excel.

image for GSTR 1 JSON to Excel Converter

Here we are going to discuss how you can import or convert your GSTR 1 JSON file into a Microsoft Excel file. Here is the step-by-step guide.

Time needed: 5 minutes

  1. Open the Microsoft Excel

  2. Click on the “Data” tab

  3. Click on “New Query”

    (Do not click on Get External Data” option

  4. Select the option “From Web” or “From JSON or “From other sources >> From Web”

    If you are using office 365, you will see the option from JSON. You can also open the “Launch power query editor”

  5. Copy the JSON file link > OK

    Copy the file path of the downloaded JSON file, from the GST portal. In the below path, I have saved my file in e: drive

    How to copy the path?
    Open the JSON file in the browser >> Right-click on the path and click copy

  6. Paste the JSON file path into the excel file >> Press the Ok button

  7. Now click on on the list as shown below

    This will get the b2b entries in the excel sheet. if you want b2c data you may click on b2c.

  8. Now click on “To table”. On the next window, click ok.

    Clicking on this option will convert your data into the table format

  9. Finally, click on the “Close and load” Option from the left-hand side.

    This step will load the data in the excel file. The loaded data can now be used in many ways like vlookup, sort, pivot table, etc.

  10. Expand the data columns >> Expand new rows >> Ok.

    In order to see the complete data click on the expand sign as shown below. you can keep on expanding the columns till you see the below sign so that the JSON file can fetch all the existing data in the JSON file of the selected sheet. No need to choose any options after clicking on the expand sign, simply hit ok.

By using the above steps you can easily convert not only GSTR 1 JSON file but any other GST-related JSON file in excel. Similarly, these steps are useful beyond the GST JSON file. Thus, the process can be used for another JSON file that contains this type of huge data.


Question 1: In which table Supplies to SEZ to be shown of GSTR 1 Return

Answer1: Supplies to SEZ should be shown in Table 6B of GSTR 1 Return.

Question 2: What happens where the details of inward supplies furnished by the recipient do not match with the outward supply details furnished by the supplier in his valid return?

Answer 2: In case of a mismatch, communication would be made to both parties. If the mismatch is not rectified, then the amount will be added to the output liability of the recipient in the return for the month succeeding the month in which the discrepancy is communicated.

Question 3: What is Table 6A of GSTR 1 Return?

Answer 3: Table 6A of GSTR 1 is meant for providing details of Export supplies made by the taxpayer during the given period.  The taxpayer should furnish these details in Table 6A if he intends to claim a refund of ITC (Input Tax credit) of tax paid on Export supplies.  These details of export invoices have been entered in this table.

Related: How to resolve https // error?

Who should file Table 6A of form GSTR 1, and why?

Any Registered taxable person, other then Input Service Distributor (ISD), Compounding Tax payer, TDS Deductor, TCS Collector and who wants to claim Refund on taxes paid on Exports made should file Table 6A of Form GSTR 1 electronically on GST Portal.

General Questions

How do I download GSTR 1 in Excel?

1. Go to GST portal
2. Click on Downloads >> Offline tools
3. Click on “Returns Offline Tool
4. Click on Download

How do I use GSTR 1 in Excel?

1. Unzip the downloaded file
2. Run the GST Offline Tool.exe from the extracted folder.
3. Complete the installation.
4. Open the GSTR1_Excel_Workbook_Template_V1.5.xlsx
5. Fill the data in above excel file.

How do I upload gstr1?

1. Open the installed GST offline Tool (Icon on Desktop)
2. Import the excel data file in the above offline tool.
3. Generate the JSON file.
4. Login to GST portal.
5. Upload the JSON file by choosing “Prepare Offline” option.

How do I file the GSTR 1 Return?

1. Choose “Prepare Online” Option
2. Verify the details and click on submit.
3. Click on “File Return” to file the return.

How to show 6% IGST OR 3% CGST in GSTR 1?

A new concessional GST tax rate of 6% IGST or 3% CGST+ 3% SGST has been implemented for certain goods vide Notification No. 02/2022 dated 31st March 2022.

Thus, the changes are being made to the GST portal to include this rate in GSTR-1. Hence as a temporary measure, taxpayers who have to report goods at this rate may do so by reporting the entries in the 5% heading and then manually increasing the system computed tax amount to 6%.

The taxpayer can do this by entering the value in the Taxable value column next to the 5% tax rate. Later the taxpayer has to increase the system computed tax-amount to 6% IGST or 3% CGST + 3% SGST in the ‘Amount of Tax’ column. This has to update under the relevant Table, namely B2B, B2C or Export, as applicable.

This process will ensure that the correct tax amount is reported in GSTR-1. The GSTN team will update this rate change provision shortly on the GST portal.

Read: How to File Returns under QRMP Scheme?

13 thoughts on “GSTR 1 format in Excel and pdf | Download and Convert JSON in offline mode

  1. GSTR-1 return मे अगर किसी बिल की डिटेल गलत चली गयी है तो उसको कैसे CORRECTION होगा…

  2. you can amend the details in the next month GSTR 1 by going through amendment tile or correct it by sending credit note/debit to the customer for tax/amount difference.

  3. In gstr 1 return I found the below error. Plz help how it solve
    “Based on your filing preference (quarterly), you are only allowed to import details for B2B, CDNR, B2BA and CDNRA tables for selected period. Please use the latest version of offline tool available on the GST portal to generate the JSON file.

  4. HI,
    I want to sell my goods to an unregistered dealer..
    How do I show it in GSTR 1 return?
    And what are the tax implications ?
    How invoice should be prepared ?
    Should I charge GST in invoice or not ?

    please clarify..

    1. hello Ashish

      Follow these simple steps:
      1 show the sales transactions under B2C block
      2 prepare invoice similar to GST Registered person
      4 charge GST In invoice


  5. I want to maintain my sales in GSTR 1 excel format, but I do not know how to add invoice to the excel sheet that have multiple items with multiple tax rates. please help…

  6. Hello sir,
    1. Is Reverse Charge applicable for B2B. Because in GSTR 1 , Reverse Charge is asking for 4A,4B,4C ? If yes Please let me know the scenario.
    2. Can be created E-invoice for Credit Note for registered Person?

    1. hi

      1. Please read it here about reverse charge on outward supplies >> On outward
      supplies if the tax is payable by the recipient, such supplies should be shown under b2b reverse charge column.

      2. e-invoice needs to be generated for credit note and debit notes if issued under Section 34 of CGST/SGST act >> Refer sec. 34

      I hope this helps


Leave a Reply

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