Skip to content
Toolyverse

№021 · GST tools

GSTR-1 PDFs to Excel

Drop the GSTR-1 PDFs you downloaded from the portal, for any number of GSTINs and months. Each return is read and checked: its tables must add up to the Total Liability printed in it, and the HSN summary must agree. You get one workbook with a coverage grid, a month-wise sheet per GSTIN and every line of every return.

How to use GSTR-1 to Excel

  1. 1Download GSTR-1 PDFs from the portal: Returns dashboard → GSTR-1 → View → Download PDF.
  2. 2Drop them all here together. GSTIN, financial year and month are read from inside each PDF.
  3. 3Check the coverage grid for missing months and the notes on any return, then download the Excel file.

Questions people ask

Are my returns uploaded anywhere?

No. The PDFs are read by your browser on your own computer. Nothing is sent to Toolyverse or anyone else.

What does "Check notes" on a return mean?

The figures in that return did not add up the way they should, for example the tables differ from the printed Total Liability. Open that return on the portal and look at the sections named in the note.

Can it read a scanned GSTR-1?

No. It needs the PDF as downloaded from the GST portal, which contains real text. A scan or a photo of a return cannot be read.

What happens if I load the same month twice?

Both are listed, and the one with the later ARN date is used, so a revised download replaces the earlier one.