GST Calculator NZ

Bulk GST calculator

Open a CSV or paste from a spreadsheet. Choose the price column and the direction, then download your list with GST columns added.

The short answer

Every row is worked out to the cent in your browser and the file never leaves your device. The total GST row by row can differ by a few cents from GST on the column total; both are shown.

Drop a CSV file hereor

Direction

Your file is read in your browser and never uploaded.

Worked example: a café price list with GST added.

ItemPriceGST exclusiveGSTGST inclusive
Flat white5.505.500.836.33
Banana bread6.906.901.047.94
Beans, 1kg42.0042.006.3048.30
Keep cup24.9524.953.7428.69

How it works

Paste rows from a spreadsheet or open a CSV file. The tool finds the price column, adds or removes GST on every row, and adds three columns: before GST, GST and including GST. Commas, semicolons and tabs all work, and amounts with dollar signs and thousands separators, like “$1,234.50”, are read correctly.

Nothing is uploaded

Your file is read by your browser and never sent to us or anyone else. The result is created on your device and downloaded from the page. Close the tab and it is gone.

Rows and totals

Each row is rounded to the cent. Added up, the row-by-row GST can differ by a few cents from GST worked on the column total; the tool shows both. In a GST return, boxes 8 and 12 are worked on totals (IR375 pp12 to 13).

When this does not apply

  • Lists that mix zero-rated or exempt items: filter them out first.
  • Files over the row limit: split them.

Sources

Official sources checked 17 November 2026. General information, not tax advice; if anything here differs from Inland Revenue’s guidance, follow IRD.

Questions

Is my file uploaded?

No. It is read and processed in your browser, and the download is created on your device.

What formats work?

CSV with commas, semicolons or tabs, or rows pasted from Excel or Google Sheets. Amounts can include $ signs and thousands separators.