GST invoice to Excel with Invoice to Spreadsheet
This page opens with a fictional GST invoice that has CGST and SGST lines and amounts in 1,23,456.78 grouping, with day-first dates. Drop your own text invoice PDF to get one row per line item and the tax added up for you to check.
- Tap Choose a PDF and pick the tax invoice as a text PDF.
- Confirm the date order: invoices in this layout are normally day first, and the page starts with that selected.
- Check the item codes (HSN) and amounts in the line table.
- Read the tax: CGST and SGST (or IGST) lines are added into the Tax figure shown above the table.
- Download Excel and check the total against the printed grand total.
What to know
Tax invoices in this layout have a table with a Description of Goods column, often an HSN or SAC code, a quantity, a rate and an amount, followed by lines for CGST, SGST (or IGST) and a grand total. The tool reads the HSN column as the item code, reads the amounts including lakh grouping such as 1,23,456.78, and adds the separate tax lines into one Tax figure. It then checks that subtotal plus that tax equals the grand total.
Dates are the usual trap: 05/11/2026 is 5 November here but 11 May in a month-first file. This page starts with day first selected, and the page tells you when a file does not settle it. Currency words such as Rs. and symbols such as the rupee sign are removed before reading the number and recorded in the Currency column.
Free reads one invoice at a time, the first 3 pages, up to 15 line items per export and 3 exports a day, which is enough to try the tool on a real invoice. Pro merges many invoices into one sheet, reads up to 30 pages per invoice and removes the line and export limits.
Updated · Cosmovex
Questions
Does it read HSN or SAC codes?
If the table has a column titled HSN, SAC or HSN/SAC it is read as the item code. If your layout has no recognisable title for it, the code stays inside the description.
How is the tax worked out?
It is read, not calculated. Lines labelled CGST, SGST, IGST, VAT or Tax are added together, or a line labelled Total tax is used. The check then compares subtotal plus tax with the printed total.
Does it read amounts like 1,23,456.78?
Yes. Lakh grouping, thousands grouping and the European 1.234,56 style are all read, and the style is decided from the whole document.
What about GSTIN, place of supply and e-invoice fields?
They are not extracted. The tool returns the invoice number, dates, supplier, line items and totals.
The free plan covers everything on this page. Invoice to Spreadsheet Pro ($9/mo, billed monthly) is described on the Invoice to Spreadsheet page.