{"id":68863,"date":"2025-03-27T13:23:04","date_gmt":"2025-03-27T07:53:04","guid":{"rendered":"https:\/\/piceapp.com\/blogs\/?p=68863"},"modified":"2025-03-27T13:23:08","modified_gmt":"2025-03-27T07:53:08","slug":"gstr-1-excel-format","status":"publish","type":"post","link":"https:\/\/piceapp.com\/blogs\/gstr-1-excel-format\/","title":{"rendered":"How to Export GSTR 1 in Excel Format?"},"content":{"rendered":"\n
GSTR-1 return forms are monthly or quarterly return documents that entail the details of outward supplies or sales<\/a>. Registered taxpayers need to file the applicable returns under 13 sections to present outward supplies details. The process to export GSTR-1 in Excel format is here to help you upload the JSON file with rate-wise HSN\/SAC details.<\/p>\n\n\n\n Here is the process to view GSTR-1 in Excel in the process of filing returns:<\/p>\n\n\n\n Step 1: <\/strong>Navigate to the \u2018Gateway of Tally\u2019, \u2018Display More Reports\u2019, \u2018GST Reports\u2019 and then \u2018GSTR-1\u2019. As an alternative, press \u2018Alt + G (Go To)\u2019, type or choose \u2018GSTR-1\u2019 and click on \u2018Enter\u2019.<\/p>\n\n\n\n Step 2:<\/strong> Choose the right period such as month and year.<\/p>\n\n\n\n Step 3<\/strong>: Click on \u2018F12 (Configure)\u2019 to set options such as \u2018Show Tax Types in Separate Columns<\/a> to Yes\u2019 and \u2018Show HSN\/SAC Summary to No\u2019.<\/p>\n\n\n\n Step 4:<\/strong> To save, press \u2018Ctrl + A\u2019.<\/p>\n\n\n\n Step 5:<\/strong> Export GSTR-1 in Excel\/JSON\/CSV format and import the acceptable format on the portal.<\/p>\n\n\n\nExport the GSTR-1 in Excel\/CSV to Upload on the Portal<\/h2>\n\n\n\n
