{"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<div class=\"wp-block-group has-background\" style=\"background-color:#f2f5f9\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<h3 class=\"wp-block-heading\"><strong>Key Takeaways<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>GSTR-1 reports outward supplies monthly or quarterly.<\/li>\n\n\n\n<li>Export GSTR-1 from Tally in Excel, CSV, or JSON.<\/li>\n\n\n\n<li>Use the GST offline tool to generate JSON files.<\/li>\n\n\n\n<li>Update HSN\/SAC codes with correct UQC values.<\/li>\n\n\n\n<li>Proper export ensures smooth GST return filing.<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<p>GSTR-1 return forms are monthly or quarterly return documents that entail the details of outward supplies or <a href=\"https:\/\/www.pipedrive.com\/en\/blog\/what-is-sales#:~:text=The%20best%20definition%20of%20sales,Prospecting%20and%20generating%20new%20leads\" target=\"_blank\" rel=\"noopener\">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<h2 class=\"wp-block-heading\">Export the GSTR-1 in Excel\/CSV to Upload on the Portal<\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"506\" src=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/03\/Export-the-GSTR-1-in-ExcelCSV-to-Upload-on-the-Portal.png\" alt=\"Export the GSTR-1 in ExcelCSV to Upload on the Portal\" class=\"wp-image-69014\" title=\"\" srcset=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/03\/Export-the-GSTR-1-in-ExcelCSV-to-Upload-on-the-Portal.png 900w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/03\/Export-the-GSTR-1-in-ExcelCSV-to-Upload-on-the-Portal-300x169.png 300w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/03\/Export-the-GSTR-1-in-ExcelCSV-to-Upload-on-the-Portal-150x84.png 150w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/03\/Export-the-GSTR-1-in-ExcelCSV-to-Upload-on-the-Portal-768x432.png 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>Here is the process to view GSTR-1 in Excel in the process of filing returns:<\/p>\n\n\n\n<p><strong>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<p><strong>Step 2:<\/strong> Choose the right period such as month and year.<\/p>\n\n\n\n<p><strong>Step 3<\/strong>: Click on \u2018F12 (Configure)\u2019 to set options such as \u2018Show Tax Types in <a href=\"https:\/\/www.kb.blackbaud.com\/articles\/Article\/37880\" target=\"_blank\" rel=\"noopener\">Separate Columns<\/a> to Yes\u2019 and \u2018Show HSN\/SAC Summary to No\u2019.<\/p>\n\n\n\n<p><strong>Step 4:<\/strong> To save, press \u2018Ctrl + A\u2019.<\/p>\n\n\n\n<p><strong>Step 5:<\/strong> Export GSTR-1 in Excel\/JSON\/CSV format and import the acceptable format on the portal.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"GSTR-1 mistake correction live in GSTR-1A | How to file GSTR 1A | GSTR-1A | GSTR-1 |GSTR-3B\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/ItARVlrgZR4?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Export GSTR-1 in JSON Format<\/h2>\n\n\n\n<p>Follow the process below to export GSTR-1 in JSON format:<\/p>\n\n\n\n<p><strong>Step 1: <\/strong>Click on \u2018Alt + E (Export)\u2019 and then E-return.<\/p>\n\n\n\n<p><strong>Step 2: <\/strong>Choose the format of the file as JSON (Data Interchange).<\/p>\n\n\n\n<p><strong>Step 3: <\/strong>Select \u2018Export Separate Files for each Section to Yes\u2019 to export JSON files for each section.<\/p>\n\n\n\n<p><strong>Step 4:<\/strong> Ensure you select \u2018Export Document Summary\u2019 to \u2018Yes\u2019.<\/p>\n\n\n\n<p><strong>Step 5<\/strong>: Export the JSON files and import the relevant files on the portal.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Export GSTR-1 in CSV Format<\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"506\" src=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/03\/Export-GSTR-1-in-CSV-Format.jpg\" alt=\"Export GSTR-1 in CSV Format\" class=\"wp-image-69016\" title=\"\" srcset=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/03\/Export-GSTR-1-in-CSV-Format.jpg 900w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/03\/Export-GSTR-1-in-CSV-Format-300x169.jpg 300w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/03\/Export-GSTR-1-in-CSV-Format-150x84.jpg 150w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/03\/Export-GSTR-1-in-CSV-Format-768x432.jpg 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>Here is the process to export GSTR-1 in CSV format:<\/p>\n\n\n\n<p><strong>Step 1:<\/strong> Select &#8216;Alt + E (Export)&#8217; and then E-return.<\/p>\n\n\n\n<p><strong>Step 2<\/strong>: Ensure to choose the format of the file as CSV (Comma Delimited).<\/p>\n\n\n\n<p><strong>Step 3:<\/strong> Choose \u2018Export Document Summary\u2019 to Yes and export the <a href=\"https:\/\/help.corel.com\/creator\/nxt9\/de\/help\/creator\/BOT_dialogs_relevant.html\" target=\"_blank\" rel=\"noopener\">relevant file.<\/a><\/p>\n\n\n\n<p><strong>Step 4<\/strong>: Open the \u2018GSTR-1 offline tool\u2019 that you downloaded from the unified GST portal.<\/p>\n\n\n\n<p><strong>Step 5:<\/strong> Import the exported CSV files to the GST offline too, initiate the JSON file and import it to the official GST portal.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Export GSTR-1 in Excel Format<\/h2>\n\n\n\n<p>Here are the simple steps you need to follow to export GSTR-1 in Excel format:<\/p>\n\n\n\n<p><strong>Step 1: <\/strong>Click on \u2018Alt + E (Export) and then E-return.<\/p>\n\n\n\n<p><strong>Step 2: <\/strong>Choose Excel (Spreadsheet) as the format of the file.<\/p>\n\n\n\n<p><strong>Step 3<\/strong>: Select \u2018Export Document Summary\u2019 to Yes and export the file.<\/p>\n\n\n\n<p><strong>Step 4: <\/strong>Open the GSTR-1 offline tool that you downloaded from the <a href=\"https:\/\/unifiedportal-emp.epfindia.gov.in\/epfo\/\" target=\"_blank\" rel=\"noopener\">unified portal.<\/a><\/p>\n\n\n\n<p><strong>Step 5: <\/strong>Import the Excel file to the GST offline tool to generate a JSON file. Further, import the final file into the GST portal.<\/p>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-101e6468-6bf8-4fb1-a6db-bc791e182caa\" href=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/03\/GSTR-1-Format.xlsx\">GSTR-1-Format<\/a><a href=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/03\/GSTR-1-Format.xlsx\" class=\"wp-block-file__button wp-element-button\" aria-describedby=\"wp-block-file--media-101e6468-6bf8-4fb1-a6db-bc791e182caa\" download>Download<\/a><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Process to Add HSN\/SAC Details of GST Annual Computation Report<\/h2>\n\n\n\n<p>View the sectionHSN-wise summary of outward supplies in the GST Annual Computation report in the following way:<\/p>\n\n\n\n<p><strong>Step 1:<\/strong> Go to the \u2018Gateway of Tally\u2019, \u2018Display More Reports\u2019, \u2018GST Reports\u2019 and \u2018GST Annual Computation\u2019. As an alternative, you can click on \u2018Alt + G (Go to)\u2019, type and choose \u2018GST Annual Computation\u2019 and click on \u2018Enter\u2019.<\/p>\n\n\n\n<p><strong>Step 2:<\/strong> Under the \u2018HSN\/SAC Summary\u2019 option, choose \u2018Summary of Outward Supplies\u2019 and then press \u2018Enter\u2019 to proceed.<\/p>\n\n\n\n<p><strong>Step 3: <\/strong>Click on \u2018F2 (Period)\u2019 and set the correct month and year.<\/p>\n\n\n\n<p>Here is the process to export details:<\/p>\n\n\n\n<p><strong>Step 1<\/strong>: Select \u2018Alt + E (Export)\u2019 and then \u2018Current\u2019.<\/p>\n\n\n\n<p><strong>Step 2:<\/strong> Click on &#8216;C (Configure)&#8217; and then choose Excel (Spreadsheet) as the file format.<\/p>\n\n\n\n<p><strong>Step 3<\/strong>: Ehe tax rate and HSN\/SAC columns.<\/p>\n\n\n\n<p><strong>Step 4: <\/strong>For services, the UQC will appear as \u2018OTH-Others\u2019 which you need to change to NA.<\/p>\n\n\n\n<p>Follow the steps below to manually add details:<\/p>\n\n\n\n<p><strong>Step 1: <\/strong>Open the GSTR-1 Excel workbook template on the offline tool.<\/p>\n\n\n\n<p><strong>Step 2:<\/strong> Rearrange the columns of rate and total value before you save the file.<\/p>\n\n\n\n<p><strong>Step 3:<\/strong> For CSV, open hsn.csv on the offline tool and rearrange the rate column.<\/p>\n\n\n\n<p><strong>Step 4: <\/strong>Save the file before you copy and paste the details on the CSV template. Notably, you might receive a success message on <a href=\"https:\/\/youexec.com\/questions\/what-is-meant-by-completion-confirmation-in-the-closing#:~:text=&#039;Completion%20confirmation&#039;%20in%20the%20closing%20phase%20of%20project%20management%20refers,project%20has%20met%20its%20objectives.\" target=\"_blank\" rel=\"noopener\">completion as confirmation.<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Process to Generate JSON File in the Offline Tool<\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"506\" src=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/03\/Process-to-Generate-JSON-File-in-the-Offline-Tool.png\" alt=\"Process to Generate JSON File in the Offline Tool\" class=\"wp-image-69018\" title=\"\" srcset=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/03\/Process-to-Generate-JSON-File-in-the-Offline-Tool.png 900w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/03\/Process-to-Generate-JSON-File-in-the-Offline-Tool-300x169.png 300w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/03\/Process-to-Generate-JSON-File-in-the-Offline-Tool-150x84.png 150w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/03\/Process-to-Generate-JSON-File-in-the-Offline-Tool-768x432.png 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>You can follow the process below to generate a JSON file in the offline tool:<\/p>\n\n\n\n<p><strong>Step 1: <\/strong>Open the GST offline tool in Excel format and import the relevant files.<\/p>\n\n\n\n<p><strong>Step 2:<\/strong> Under the \u2018Import Returns &#8211; One Section at a Time\u2019, choose HSN-wise summary of outward supplies- 12 or sales.<\/p>\n\n\n\n<p><strong>Step 3<\/strong>: Select \u2018Import CSV\u2019 or \u2018Copy Excel\u2019 as applicable, and then \u2018View Summary\u2019 to import.<\/p>\n\n\n\n<p><strong>Step 4:<\/strong> To generate a JSON file, click on \u2018Generate File\u2019.<\/p>\n\n\n\n<p><strong>Step 5:<\/strong> Click on the available link to download the JSON file and upload the same on the GST portal.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Steps to Fill in HSN\/SAC Details in the Offline Tool<\/h2>\n\n\n\n<p>Here are the steps to enter the SAC\/HSN summary in the GST offline tool:<\/p>\n\n\n\n<p><strong>Step 1:<\/strong> Go to the GST offline tool and choose \u2018HSN-wise Summary of Outward Supplies -12\u2019.<\/p>\n\n\n\n<p><strong>Step 2: <\/strong>Fill in the HSN\/SAC followed by the description.<\/p>\n\n\n\n<p><strong>Step 3<\/strong>: Choose the UQC as provided in the CSV\/Excel file that you generate from Tally Prime. Change the status to NA from \u2018OTH-OTHERS\u2019.<\/p>\n\n\n\n<p><strong>Step 4: <\/strong>Fill in the necessary details and save to proceed.<\/p>\n\n\n\n<p><strong>Step 5:<\/strong> Fill in all the HSN\/SAC information and click on the \u2018<a href=\"https:\/\/www.zoho.com\/analytics\/help\/summary\/\" target=\"_blank\" rel=\"noopener\">View Summary<\/a>\u2019 option.<\/p>\n\n\n\n<p><strong>Step 6: <\/strong>To generate the JSON file, click on \u2018Generate File\u2019.<\/p>\n\n\n\n<p><strong>Step 7: <\/strong>Click on the download link on the dashboard to get the JSON file.<\/p>\n\n\n\n<p><strong>Step 8: <\/strong>Once you complete downloading, upload the file on theGST portal.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>You can export GSTR-1 in Excel format besides CSV import format to upload the JSON file and update rate-wise HSN\/SAC code. It helps in seamless GSTR-1 return filing for registered taxpayers. As a result, taxpayers can seamlessly present outward supply details or <a href=\"https:\/\/kylas.io\/blog\/sales-business-importance\" target=\"_blank\" rel=\"noopener\">sales information<\/a> while filing GST (Goods and Services Tax) monthly returns or quarterly returns, as applicable.<\/p>\n\n\n\n<p>This ensures compliance with GST laws for businesses and renders a complete supply chain solution. Notably, these are not annual returns; as a result, you do not need annual return filing.<\/p>\n\n\n\n<p class=\"has-background\" style=\"background-color:#f2f5f9\">\ud83d\udca1If you want to streamline your payment and make GST payments via credit or debit card, UPI consider using&nbsp;<a href=\"https:\/\/piceapp.com\/\">the PICE App<\/a>. Explore the PICE App today and take your business to new heights.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>FAQs<\/strong><\/h3>\n\n\n<div id=\"rank-math-faq\" class=\"rank-math-block\">\n<div class=\"rank-math-list \">\n<div id=\"faq-question-1742896099763\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \"><strong><strong>What is GSTR-1 and who needs to file it?<\/strong><\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>GSTR-1 is a monthly or quarterly return that captures details of outward supplies (sales) made by registered taxpayers under GST. It includes invoices, debit\/credit notes, and HSN\/SAC summaries. All regular GST-registered businesses must file it, except those under the composition scheme or exempt categories.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1742896192915\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \"><strong><strong>How can I export GSTR-1 from Tally?<\/strong><\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>In Tally, navigate to \u2018Gateway of Tally\u2019 \u2192 \u2018GST Reports\u2019 \u2192 \u2018GSTR-1\u2019. Choose the correct period, configure settings, and export using \u2018Alt + E\u2019. You can export the return in Excel, CSV, or JSON formats depending on how you plan to upload it to the GST portal.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1742896198849\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \"><strong><strong>What is the use of the GST offline tool in GSTR-1 filing?<\/strong><\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>The GST offline tool helps taxpayers prepare and validate GSTR-1 returns offline before uploading. It accepts Excel\/CSV files exported from accounting software like Tally, generates a JSON file, and allows previewing data. This reduces errors and ensures smoother filing on the GST portal.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1742896319779\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \"><strong><strong>How do I add or modify HSN\/SAC details in the offline tool?<\/strong><\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Open the GST offline tool and select \u2018HSN-wise Summary of Outward Supplies\u2019. Enter the HSN\/SAC code, description, and correct UQC (e.g., change &#8216;OTH&#8217; to &#8216;NA&#8217; for services). Fill in tax details and click \u2018Generate File\u2019 to create a JSON file for upload.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1742896325410\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \"><strong><strong>Can I file GSTR-1 without using the JSON format?<\/strong><\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>No, the final file uploaded to the GST portal must be in JSON format. While you can export GSTR-1 in Excel or CSV for convenience, the GST offline tool must be used to convert those files into a JSON file, which is the accepted format for filing returns.<\/p>\n\n<\/div>\n<\/div>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Key Takeaways GSTR-1 return forms are monthly or quarterly return documents that entail the details of outward supplies or sales. 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 [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":69013,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-68863","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-gst"],"_links":{"self":[{"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/posts\/68863","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/comments?post=68863"}],"version-history":[{"count":10,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/posts\/68863\/revisions"}],"predecessor-version":[{"id":69021,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/posts\/68863\/revisions\/69021"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/media\/69013"}],"wp:attachment":[{"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/media?parent=68863"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/categories?post=68863"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/tags?post=68863"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}