GSTR-1 data can be exported to Excel from the GST portal by navigating to Returns Dashboard > Prepare Offline > Download > Generate File, which provides a JSON file that can be converted to Excel using the GST Offline Tool. Alternatively, accounting software like TallyPrime or Marg allows direct export of GSTR-1 data into Excel format via their respective export menus.
How to Convert GSTR 1 JSON to Excel
Downloading GSTR-1
How To Export and Upload GSTR1 Form In CSV Files
Export GSTR-1 in Excel format
From the GST Filing Module
Steps to file the GSTR-1 summary
If the number of sales invoices is more than 500, then the GST Offline Utility has to be downloaded and the return file needs to be generated from this offline utility. There is no option to perform bulk action on invoices.
Go to Menu > Consolidated Data > GST Form (Offline Tool) > Export GSTR1 (Excel). A new window of Export GSTR1 (Excel) will appear in next slide.
Follow these steps to download any GST return form from the GST portal.
Yes, you can easily convert JSON to CSV using free online tools, programming libraries (like Python's pandas or R's jsonlite), desktop applications (Modern CSV), or even command-line utilities like PowerShell, allowing you to transform structured JSON data into flat, tabular CSV files for use in spreadsheets or databases.
Converting from JSON to Excel
To convert GSTR-1 Excel to JSON, download the GST offline tool from the GST portal. Import your GSTR-1 Excel file into the tool, check the summary, and click “Generate File” to create a GSTR-1 JSON file. This JSON format is the only file type accepted for uploading GSTR-1 returns on the GST portal.
Apply the GST Formula Use a formula like = B2 - B2 / 1.15 for a 15% tax rate to calculate the GST amount. Adjust as needed for different tax rates. (This approach works similarly for other tax rates—just replace 1.15 with 1 + (GST Rate/100). For example, if the GST rate is 18%, use 1.18 instead.)
The date format should bedd- mmm-yyyy only(eg 01-Jul-2017). ii. Incorrectinvoice format entered in excel. Invoice number should be maximum 16 digit and alphanumeric.
Step 1 : Choose the client for whom you want to import GSTR-1 book data by clicking on the client's name. This will take you to the Return Summary page. Step 2 : On the Return Summary page, you will see a list of all types of GSTR filings. Locate the Import Books Data button on the left-hand side.
A. Login and Navigate to Form GSTR-1
Once you are done uploading all the data to your GST Offline Utility Tool, click on the 'View Summary' button as highlighted below: Here, just click on 'Generate File' to generate a JSON file that can be uploaded to the GST Portal. Click on the link to download the JSON file: That's it!
Gateway of Tally > Display More Reports > Statutory Reports > GST > GSTR–1. The report displays the data for a month or quarter depending on the Periodicity of GSTR-1 set in the Company GST Details screen. Alternatively, Alt+G (Go To) > type or search GSTR-1 or Returns or GST > select and press Enter.
Form GSTR-1 is a monthly Statement of Outward Supplies to be furnished by all normal and casual registered taxpayers making outward supplies of goods and services or both and contains details of outward supplies of goods and services.
For downloading filed GST SRM -I follow these steps:
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.
In the Balance sheet screen click E : Export or press Alt+E. Select the required language from the list of Languages displayed. Select a format from the list of Formats displayed. Press Enter to accept the default Output Filename or type the filename of your choice in order to save the file with a different name.
The option Is invoice in Alt+F12 Range is available only in columnar voucher registers. All vouchers recorded in invoice mode (Account Invoice and Item Invoice) will be displayed in the columnar voucher register. All vouchers recorded in voucher mode will be displayed in the columnar voucher register.